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

Borverk Eurotrade d.o.o

Dynamics NAV/BC Solution Developer Job at Borverk Eurotrade d.o.o

...services and products extend beyond borders, including Spain, Hungary, Switzerland, and the US.What are your responsibilities as a Dynamics NAV Solution Developer? You join a small and dynamic team of solution developers within the Resilux group.You determine the new or...

Heart Institute

Fellow, Cardiac Anesthesiology Job at Heart Institute

...Description The Pediatric Cardiac Anesthesiology Fellowship Program 1-Year ACGME Fellow position at Childrens National Hospital, Washington D.C This one-year, ACGME accredited Pediatric Cardiac Anesthesiology fellowship at Childrens National Medical Center...

Diversified Transfer and Storage, Inc.

Class A OTR and Local Truck Driving Jobs Job Job at Diversified Transfer and Storage, Inc.

Class A OTR and Local Truck Driving Jobs JobDiversified Transfer & Storage, one of the best paying trucking companies, is looking for experienced drivers to deliver temperature sensitive LTL freight. We are a family business offering more than just dedicated routes with...

Trendsetter Engineering, Inc.

Subsea Controls Technician Job at Trendsetter Engineering, Inc.

...mechanical equipment of minor to moderate difficulty. All other duties as assigned by management. Minimum Qualifications: Offshore deployment is required to global destinations possibly totaling up to 180 days per year. A minimum of 1-2 years experience as...

Saint Louis University

Counselor/Therapist - School of Law and University Counseling Center Job at Saint Louis University

...assigned. The role requires a Masters Degree and full licensure as Licensed Clinical Social Work (LCSW), Licensed Professional Counseling (LPC), Licensed Marriage and Family Therapist (LMFT), or Licensed Psychologist with training and experience with intake interviewing/...

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

VUtHRGo5bHlYaHpGdWQwa0k0M2pKWnRySHc9PQ==