Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Skills
Data Warehouse Consultant
GCP
Big query
Job Details
Hello Professional,
I hope you are doing well..!!
We have a very urgent opening for the role of Senior Data Warehouse Analyst. Kindly let us know if you are interested.
Job Title: Senior Data Warehouse Analyst
Location: Secaucus, NJ(Remote)
Mandatory - Google Cloud Platform BigQuery, Data Lineage, BI & Analytics
Job Description / Key Responsibilities:
The Senior Data Warehouse Analyst will be responsible for analyzing, designing, and documenting
end-to-end data warehouse solutions on Google Cloud Platform (Google Cloud Platform), with a strong focus on
BigQuery modernization, data lineage documentation, and business intelligence (BI) source
mapping. This role requires close collaboration with data engineers, business stakeholders, and
product owners to ensure analytical requirements are met through robust and scalable data
warehouse designs.
Key Responsibilities
- Analyze existing on-premise or cloud data warehouses and define migration paths to Google Cloud Platform
BigQuery.
- Develop detailed source-to-target mapping (STM) and data lineage documentation for ETL/ELT
processes and BI reports.
- Perform data validation and reconciliation across layers (staging, warehouse, semantic layer, BI).
- Partner with BI developers to ensure consistent data definitions and metrics alignment across
visualization tools.
- Support data quality monitoring, data profiling, and issue resolution to ensure trusted analytics.
- Provide domain knowledge to support business requirements gathering and solution
walkthroughs.
- Support UAT (User Acceptance Testing) and contribute to data governance activities.
- Create and review Source System Interface Agreements or Data Delivery Agreements to ensure
clarity in data ownership, frequency, and delivery standards.
Technical & Soft Skills Required
- Strong hands-on experience with Google BigQuery, SQL scripting, and data modeling
(Star/Snowflake schemas).
- Experience in data warehouse migration from on-premise systems (e.g., Teradata, Oracle,
Netezza, SQL Server) or other cloud platforms (Snowflake, Redshift) to Google Cloud Platform BigQuery.
- Solid understanding of data lineage, metadata management, and source-to-report traceability.
- Proven experience in requirement analysis, user story creation, and defining acceptance criteria in
Agile environments.
- Knowledge in any BI tools for data validation and lineage documentation.
- Strong SQL optimization and performance tuning capabilities.
- Familiarity with ETL/ELT frameworks (e.g., Dataflow, Dataform, dbt, Informatica, Talend,
Matillion).
- Good communication skills, interactions with end users on requirement validations.
- Agile work experience.
Location: Secaucus, NJ(Remote)
Mandatory - Google Cloud Platform BigQuery, Data Lineage, BI & Analytics
Job Description / Key Responsibilities:
The Senior Data Warehouse Analyst will be responsible for analyzing, designing, and documenting
end-to-end data warehouse solutions on Google Cloud Platform (Google Cloud Platform), with a strong focus on
BigQuery modernization, data lineage documentation, and business intelligence (BI) source
mapping. This role requires close collaboration with data engineers, business stakeholders, and
product owners to ensure analytical requirements are met through robust and scalable data
warehouse designs.
Key Responsibilities
- Analyze existing on-premise or cloud data warehouses and define migration paths to Google Cloud Platform
BigQuery.
- Develop detailed source-to-target mapping (STM) and data lineage documentation for ETL/ELT
processes and BI reports.
- Perform data validation and reconciliation across layers (staging, warehouse, semantic layer, BI).
- Partner with BI developers to ensure consistent data definitions and metrics alignment across
visualization tools.
- Support data quality monitoring, data profiling, and issue resolution to ensure trusted analytics.
- Provide domain knowledge to support business requirements gathering and solution
walkthroughs.
- Support UAT (User Acceptance Testing) and contribute to data governance activities.
- Create and review Source System Interface Agreements or Data Delivery Agreements to ensure
clarity in data ownership, frequency, and delivery standards.
Technical & Soft Skills Required
- Strong hands-on experience with Google BigQuery, SQL scripting, and data modeling
(Star/Snowflake schemas).
- Experience in data warehouse migration from on-premise systems (e.g., Teradata, Oracle,
Netezza, SQL Server) or other cloud platforms (Snowflake, Redshift) to Google Cloud Platform BigQuery.
- Solid understanding of data lineage, metadata management, and source-to-report traceability.
- Proven experience in requirement analysis, user story creation, and defining acceptance criteria in
Agile environments.
- Knowledge in any BI tools for data validation and lineage documentation.
- Strong SQL optimization and performance tuning capabilities.
- Familiarity with ETL/ELT frameworks (e.g., Dataflow, Dataform, dbt, Informatica, Talend,
Matillion).
- Good communication skills, interactions with end users on requirement validations.
- Agile work experience.
Thanks & Regards,
Dharm Sharma
SunRay Enterprise, Inc.
Phone: ext.244
(Fax)
Email:
URL:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.