TechDigital Group is hiring: Senior Data Warehouse Analyst in Secaucus

Mandatory - GCP BigQuery, Data Lineage, BI & Analytics

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