Job Summary

The Senior Data Warehouse Analyst will be responsible for analyzing, designing, and documenting end-to-end data warehouse solutions on Google Cloud Platform (GCP), 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 GCP BigQuery.
• Develop detailed source-to-target mapping (STM) and data lineage documentation for ETL/ELT processes and BI reports.
• Collaborate with product owners and business users to create detailed user stories with well-defined acceptance criteria.
• Work closely with data engineering teams to validate data ingestion, transformation logic, and semantic model consistency.
• 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.
• Coordinate with multiple stakeholders for requirement clarifications, dependency management, and milestone alignment.
• Define and document Epics and User Stories aligned with release milestones and sprint delivery plans.

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 GCP 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.

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 (GCP), 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 GCP BigQuery.
• Develop detailed source-to-target mapping (STM) and data lineage documentation for ETL/ELT processes and BI reports.
• Collaborate with product owners and business users to create detailed user stories with well-defined acceptance criteria.
• Work closely with data engineering teams to validate data ingestion, transformation logic, and semantic model consistency.
• 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.
• Coordinate with multiple stakeholders for requirement clarifications, dependency management, and milestone alignment.
• Define and document Epics and User Stories aligned with release milestones and sprint delivery plans.

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 GCP 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.

Skill Requirements

The Senior Data Warehouse Analyst will be responsible for analyzing, designing, and documenting end-to-end data warehouse solutions on Google Cloud Platform (GCP), 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 GCP BigQuery.
• Develop detailed source-to-target mapping (STM) and data lineage documentation for ETL/ELT processes and BI reports.
• Collaborate with product owners and business users to create detailed user stories with well-defined acceptance criteria.
• Work closely with data engineering teams to validate data ingestion, transformation logic, and semantic model consistency.
• 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.
• Coordinate with multiple stakeholders for requirement clarifications, dependency management, and milestone alignment.
• Define and document Epics and User Stories aligned with release milestones and sprint delivery plans.

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 GCP 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.

Other Requirements