Senior Data Modeler & Architect Lead

EY; New York (NY); Hybrid; USD 125,500 - 261,600; Full time

Benefits offered by this job

Hybrid work model

Competitive compensation package

Comprehensive benefits and PTO

Job summary

EY is seeking an experienced Data Modeling/Architecture professional to design scalable data models for analytics, reporting, and AI use cases. You will translate business requirements into robust data structures and collaborate with data engineers on ETL/ELT mappings and lineage.

Role requires 10+ years in data modeling, strong dimensional modeling skills, and hands-on cloud platform experience. Hybrid work in the US with a focus on data governance and enterprise standards.

Qualifications

• 10+ years in data modeling / data architecture.
• Strong expertise in dimensional modeling (Kimball), normalization, and/or Data Vault.
• Hands-on experience with cloud data platforms (Snowflake, Databricks).
• Proficiency in SQL and data warehousing concepts.
• Experience with data modeling tools (ERwin, ER/Studio, PowerDesigner).

Responsibilities

• Develop conceptual, logical, and physical data models across modern data platforms (e.g., Snowflake, Azure, Databricks).
• Design dimensional (star/snowflake) and normalized models based on use case.
• Translate business requirements into entities, attributes, relationships, and business rules.
• Partner with data engineers to define ETL/ELT mappings, transformations, and lineage.
• Ensure alignment with enterprise architecture, data standards, and governance policies.
• Drive data quality, consistency, and metadata management (e.g., Collibra/Alation).
• Optimize models for performance, scalability, and cost efficiency.
• Maintain data dictionaries, lineage, and design documentation.

Skills

data modeling

data architecture

dimensional modeling

SQL

data warehousing

Tools

ERwin

ER/Studio

PowerDesigner

Job description

EY is seeking an experienced Data Modeling/Architecture professional to design scalable data models for analytics, reporting, and AI use cases. You will translate business requirements into robust data structures and collaborate with data engineers on ETL/ELT mappings and lineage.

Role requires 10+ years in data modeling, strong dimensional modeling skills, and hands-on cloud platform experience. Hybrid work in the US with a focus on data governance and enterprise standards.