HS Ad North America
Data Modeler
HS Ad North America - Englewood Cliffs, New Jersey, us, 07632
Work at HS Ad North America
Overview
- View job
Overview
Get AI-powered advice on this job and more exclusive features.
This range is provided by HSAD North America. Your actual pay will be based on your skills and experience talk with your recruiter to learn more.
Base pay range
$100,000.00/yr - $135,000.00/yr Direct message the job poster from HSAD North America Location: Onsite About the Role We are looking for a highly skilled Data Modeler to join our OneData Platform initiative built on Google Cloud Platform, 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 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). 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 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. 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). 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. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Analyst Industries
Marketing Services Referrals increase your chances of interviewing at HSAD North America by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Paid paternity leave Get notified when a new job is posted. Sign in to set job alerts for Data Modeler roles.
Newark, NJ $103,330.00-$128,656.00 2 weeks ago Jersey City, NJ $110,000.00-$120,000.00 1 month ago Data Analyst- $150,000-$200,000 + bonus!
New York City Metropolitan Area $150,000.00-$200,000.00 1 week ago Junior Quantitative Developer - Volatility
Want to work with us, but don't see the right job listed?
New York, NY $129,000.00-$135,000.00 2 weeks ago Sr Data Modeler- Security Services, custody
Jersey City, NJ $92,432.00-$136,600.00 3 weeks ago New York, NY $99,900.00-$133,900.00 21 hours ago Senior Data Modeler with DATaVault2.0 on Investment and Asset Management - New York, NY
New York City Metropolitan Area 4 days ago Purchase, NY $76,400.00-$127,850.00 2 weeks ago Purchase, NY $76,400.00-$127,850.00 2 weeks ago New York, NY $100,000.00-$150,000.00 1 week ago New York City Metropolitan Area $50.00-$60.00 4 weeks ago Data Engineer for a Research Team at an Elite Asset Management Firm
New York City Metropolitan Area $150,000.00-$200,000.00 2 weeks ago New York, NY $150,000.00-$200,000.00 3 weeks ago New York City Metropolitan Area $150,000.00-$200,000.00 4 days ago Purchase, NY $76,400.00-$127,850.00 4 days ago New York City Metropolitan Area $600,000.00-$1,000,000.00 4 days ago New York, NY $65,000.00-$100,000.00 2 months ago New York City Metropolitan Area $300,000.00-$300,000.00 3 weeks ago New York City Metropolitan Area 4 weeks ago Volatility Data Engineer - Systematic Data Platform
New York, NY $175,000.00-$250,000.00 15 hours ago Manhattan, NY $90,000.00-$130,000.00 2 months ago New York, NY $120,000.00-$150,000.00 2 weeks ago New York, NY $90,000.00-$130,000.00 5 months ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
$100,000.00/yr - $135,000.00/yr Direct message the job poster from HSAD North America Location: Onsite About the Role We are looking for a highly skilled Data Modeler to join our OneData Platform initiative built on Google Cloud Platform, 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 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). 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 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. 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). 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. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Analyst Industries
Marketing Services Referrals increase your chances of interviewing at HSAD North America by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Paid paternity leave Get notified when a new job is posted. Sign in to set job alerts for Data Modeler roles.
Newark, NJ $103,330.00-$128,656.00 2 weeks ago Jersey City, NJ $110,000.00-$120,000.00 1 month ago Data Analyst- $150,000-$200,000 + bonus!
New York City Metropolitan Area $150,000.00-$200,000.00 1 week ago Junior Quantitative Developer - Volatility
Want to work with us, but don't see the right job listed?
New York, NY $129,000.00-$135,000.00 2 weeks ago Sr Data Modeler- Security Services, custody
Jersey City, NJ $92,432.00-$136,600.00 3 weeks ago New York, NY $99,900.00-$133,900.00 21 hours ago Senior Data Modeler with DATaVault2.0 on Investment and Asset Management - New York, NY
New York City Metropolitan Area 4 days ago Purchase, NY $76,400.00-$127,850.00 2 weeks ago Purchase, NY $76,400.00-$127,850.00 2 weeks ago New York, NY $100,000.00-$150,000.00 1 week ago New York City Metropolitan Area $50.00-$60.00 4 weeks ago Data Engineer for a Research Team at an Elite Asset Management Firm
New York City Metropolitan Area $150,000.00-$200,000.00 2 weeks ago New York, NY $150,000.00-$200,000.00 3 weeks ago New York City Metropolitan Area $150,000.00-$200,000.00 4 days ago Purchase, NY $76,400.00-$127,850.00 4 days ago New York City Metropolitan Area $600,000.00-$1,000,000.00 4 days ago New York, NY $65,000.00-$100,000.00 2 months ago New York City Metropolitan Area $300,000.00-$300,000.00 3 weeks ago New York City Metropolitan Area 4 weeks ago Volatility Data Engineer - Systematic Data Platform
New York, NY $175,000.00-$250,000.00 15 hours ago Manhattan, NY $90,000.00-$130,000.00 2 months ago New York, NY $120,000.00-$150,000.00 2 weeks ago New York, NY $90,000.00-$130,000.00 5 months ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr