Data Modeler Job at HSAD North America, Englewood Cliffs, NJ

Y2xVV3dTU3JUREc1UUVtSnVZc1BuVTV1K0E9PQ==
  • HSAD North America
  • Englewood Cliffs, NJ

Job Description

Data Modeler – OneData Platform

About the Role

We are looking for a highly skilled Data Modeler to join our OneData Platform initiative—an enterprise-wide effort to centralize, govern, and operationalize data from over 35+ sources. As the Data Modeler, you will be responsible for designing conceptual, logical, and physical data models that align with business goals and technical standards.

You will work at the intersection of data engineering, data governance, and product to drive schema standardization, semantic consistency, and cross-domain scalability in Google Cloud Platform (GCP).

Key Responsibilities

  • Design conceptual, logical, and physical data models across Raw → Silver → Gold layers.
  • Collaborate with Data Engineers to translate models into performant BigQuery schemas.
  • Develop shared dimensional models, canonical entities, and fact-dimension frameworks.
  • Partner with Product and Analytics teams to define business-friendly data structures.
  • Lead schema reviews, ICD (Interface Control Document) creation, and metadata documentation.
  • Support data contract design between source systems and the OneData platform.
  • Define schema evolution strategies, data type policies, and partitioning/clustering rules.
  • Align models with governance, lineage, and access control standards.

Requirements

  • 6+ years of experience in data modeling or enterprise data architecture roles.
  • Hands-on experience with cloud data platforms, preferably GCP (BigQuery).
  • Expertise in dimensional modeling techniques, including 3NF, star schema, and snowflake schema designs.
  • Familiarity with modeling tools like dbt.
  • Proficient in SQL and understanding of ELT/ETL orchestration in modern data stacks.
  • Strong understanding of metadata, lineage, and data governance principles.
  • Experience working in multi-vendor and cross-functional environments is a plus.

Nice to Have

  • Experience in e-commerce, retail, or Marketing data domains.
  • Exposure to Google Marketing Platform integrations and CDP schemas.
  • Familiarity with CI/CD for data models (e.g., dbt cloud).
  • Reduction in data model fragmentation across OneData layers.
  • Increased reuse of core dimensions and conformed facts across domains.
  • Consistent adoption of naming conventions and schema standards.
  • Measurable improvement in model query performance and data discoverability.

Job Tags

Contract work,

Similar Jobs

Terra Contracting Inc

CDL A Truck Driver Job at Terra Contracting Inc

 ...environment where each team member plays a crucial role in our continued success. Position Overview : We are seeking skilled CDL drivers to join our team. As a vital member of our fleet, you will play a crucial role across various divisions and job sites in our... 

Ryder System

Truck Driver CDL A Home Daily Job at Ryder System

 ...Position Description Immediate opening for a SOLO Class A CDL Truck Driver and we want the right Trucker to join us at Ryder in Visalia...  ...easy. ~ Deliver SOLOTo:Central Valley CA ~ Route: Local Home Daily ~ Tractor Type: Day Cab ~ TrailerType:Tanker 48' ~... 

Matlen Silver

Senior Java Developer - Alpharetta Job at Matlen Silver

Job description Title:Senior Java Developer Location: Alpharetta, Georgia Environment: 2x/week onsite Pay: $68-$72/hour Duration: 6+ month contract MINIMUM REQUIREMENTS: Proven experience working extensively with Java 17+ , with a strong understanding... 

Larson Maddox

Sr. Legal Counsel - Food Policy Job at Larson Maddox

Position Overview An industry leading consumer packaged goods company is looking to bring in a Senior Counsel in Food Law and Policy to provide legal guidance and strategic direction on food law, regulatory compliance, and related policy matters across the organization...

Tesla

Tesla Support Advisor - Manchester Job at Tesla

 ...What To Expect Our Tesla Support Advisors aren't just technically gifted, they are also great communicators who put the customer first. As a Tesla Support Advisors, your role will be to guide our existing and future customers and create an exciting, memorable and best...