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

SVF6UGE2aVhrcEg3Mi9SanJOb2xJam5xQUE9PQ==
  • 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

Georgetown Learning Centers

Online Math and Science Tutor Job at Georgetown Learning Centers

Online Math and Science TutorThinkingStorm is a national online tutoring company seeking writing tutors to conduct live online tutoring sessions from home.Our ideal tutor has a BA/BS degree or higher in a math or science related discipline. If tutor is applying... 

Oldcastle Payroll, Inc in

Business Development Partner - Customer Solutions Midwest - Remote (Chicago) Job at Oldcastle Payroll, Inc in

Business Development Partner - Customer Solutions Midwest - Remote Chicago, IL, US, 60611 Job ID: 515127 CRH is a leading global diversified building materials group, employing over 75,800 people at more than 3,160 locations in 29 countries. CRH is the leading building...

Iremote Professionals

Sales & Marketing Operations Assistant (Remote) Job at Iremote Professionals

 ...Were seeking a proactive, detail-oriented assistant to support our Sales and Marketing Lead in managing operations, logistics, and coordination for our construction and real estate team. Youll keep projects, materials, and communications organized so leadership can... 

Lensa

Data analyst Job at Lensa

 ...growth by connecting people, data and applications - quickly, securely...  ...Intern must be available to work full time (40 hours/week)...  ...position is fully remote / work from home in the continental US. Work...  ...is looking for a Data Analyst on our Service Delivery team.... 

Kikoff

Software Engineer - Recent College Graduate Job at Kikoff

Calling all new grad and junior software engineers who are looking for fast personal and career growth in consumer fintech. Skip the bureaucracy of a big company and work with a seasoned startup product and engineering team. We balance best practices from our experience...