Data Modeler (Englewood Cliffs, NJ)

Our client, an inhouse Advertising Agency with offices in Englewood Cliffs, NJ, is seeking an experienced Data Modeler starting ASAP. This is a long term fully on-site contract position, so only candidates who are within a commutable location to Northern NJ will be considered. As the Data Modeler, you will be responsible for designing conceptual, logical, and physical data models to centralize and activate data in Google Cloud Platform 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).

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.

QUALIFICATIONS:

• 6+ years of experience in data modeling or enterprise data architecture roles utilizing Google Cloud Platform (GCP).
• Hands-on experience with Google Cloud Platform (GCP).
• 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 Google Cloud Platform (GCP).
• Strong understanding of metadata, lineage, and data governance principles and utilizing Cataloging and metadata management tools like DataPlex.
• Experience working in multi-vendor and cross-functional environments is a plus.