Senior Data Warehouse Analyst

TechDigital Group; Secaucus (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading tech consulting firm in New Jersey is seeking a data specialist proficient in Google BigQuery and data warehouse migration. The role involves analyzing on-premise and cloud data systems, developing data lineage documentation, and ensuring data quality across multiple layers. Ideal candidates will possess strong SQL scripting skills and experience in Agile environments. This position promises an exciting opportunity to contribute to various data projects in a dynamic team atmosphere.

Qualifications

• Strong hands-on experience with Google BigQuery and SQL scripting.
• Experience in migrating data warehouses to GCP BigQuery.
• Solid understanding of data lineage and metadata management.

Responsibilities

• Analyze data warehouses and define migration paths to GCP BigQuery.
• Develop source-to-target mapping and data lineage documentation.
• Perform data validation and reconciliation across data layers.

Skills

Google BigQuery

SQL scripting

Data modeling

Data validation

Requirement analysis

ETL/ELT frameworks

BI tools

Agile experience

SQL optimization

Communication skills

Tools

Dataflow

Informatica

dbt

Job description

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.