Senior Data Warehouse Analyst

6 days ago

Secaucus, NJ, United States Omni Inclusive Full time
Mandatory - GCP 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 (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.
- 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.

  • Senior ETL Developer

    2 days ago

    Secaucus, NJ, United States Sunrise Systems Full time

    Job Title - Senior ETL Developer - Azure Data Tools Location - Secaucus NJ Full time position About the Role We are looking for a passionate Senior ETL Developer - SSIS /Azure Data tools. The ETL Developer will be involved in developing solutions for enterprise data warehousing (EDW), reporting and business intelligence ( SSIS / SSRS ) initiatives. Work with...

  • Senior Data Engineer

    2 weeks ago

    Secaucus, NJ, United States Omni Inclusive Full time

    Mandatory - GCP BigQuery, Dataflow, Python, Cloud Composer, Data Governance & ValidationJob Description: Key Responsibilities - Design and implement end-to-end data pipelines using Cloud Dataflow (Python/Apache Beam) for batch and streaming data. - Develop, optimize, and maintain BigQuery stored procedures (SPs), SQL scripts, and user-defined functions...

  • Senior Data Engineer

    3 days ago

    Secaucus, NJ, United States Omni Inclusive Full time

    Mandatory - GCP BigQuery, Dataflow, Python, Cloud Composer, Data Governance & ValidationJob Description: Key Responsibilities - Design and implement end-to-end data pipelines using Cloud Dataflow (Python/Apache Beam) for batch and streaming data. - Develop, optimize, and maintain BigQuery stored procedures (SPs), SQL scripts, and user-defined functions...

  • Senior Data Engineer

    1 week ago

    Secaucus, NJ, United States Omni Inclusive Full time

    Mandatory - GCP BigQuery, Dataflow, Python, Cloud Composer, Data Governance & ValidationJob Description: Key Responsibilities - Design and implement end-to-end data pipelines using Cloud Dataflow (Python/Apache Beam) for batch and streaming data. - Develop, optimize, and maintain BigQuery stored procedures (SPs), SQL scripts, and user-defined functions...

  • Senior ETL Developer

    2 weeks ago

    Secaucus, NJ, United States ZT Systems Full time

    About the Role We are looking for a passionate Senior ETL Developer - SSIS/Azure Data tools. The ETL Developer will be involved in developing solutions for enterprise data warehousing (EDW), reporting and business intelligence (SSIS/SSRS) initiatives. Work with business users and functional and development teams to collect, analyze, and document...

  • Data Engineer

    2 weeks ago

    Secaucus, NJ, United States Omni Inclusive Full time

    Job Summary: Strong Snowflake Data warehousing knowledge Basic-Medium level Python Development ETL-ELT Technologies (Expertise in any of the ELT Tool, preferably in Matillion) Basic understanding of AWS Cloud platform Basic understanding of BI ToolWe are looking for a skilled Data Engineer to join our team. The ideal candidate will have experience in...

  • Senior IT Security Analyst

    1 week ago

    Secaucus, NJ, United States Yusen Logistics Full time

    Overview Salary Range: $105,628-$177,513 The Sr. IT Security Analyst is responsible for assessing information risk and facilitates remediation of identified vulnerabilities for IT security and IT risk across the enterprise. Assesses information risk and facilitates remediation of identified vulnerabilities with the Bank network, systems and applications....

  • Senior IT Security Analyst

    1 day ago

    Secaucus, NJ, United States Yusen Logistics Full time

    Overview Salary Range: $105,628-$177,513 The Sr. IT Security Analyst is responsible for assessing information risk and facilitates remediation of identified vulnerabilities for IT security and IT risk across the enterprise. Assesses information risk and facilitates remediation of identified vulnerabilities with the Bank network, systems and applications....

  • Export Compliance Senior Staff Analyst

    16 hours ago

    Secaucus, NJ, United States ZT Systems group Full time

    Export Compliance Senior Staff Analyst page is loaded## Export Compliance Senior Staff Analystlocations: Secaucus, NJtime type: Full timeposted on: Posted Yesterdayjob requisition id: R-104249**About The Role**The Export Compliance Senior Staff Analyst will oversee daily operations related to export compliance for finished goods, components and RMA/RTV...

  • Export Compliance Senior Staff Analyst

    16 hours ago

    Secaucus, NJ, United States ZT Systems group Full time

    Export Compliance Senior Staff Analyst page is loaded## Export Compliance Senior Staff Analystlocations: Secaucus, NJtime type: Full timeposted on: Posted Yesterdayjob requisition id: R-104249**About The Role**The Export Compliance Senior Staff Analyst will oversee daily operations related to export compliance for finished goods, components and RMA/RTV...