Data Modeler

At EY, we’re all in to shape your future with confidence. 

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.  Join EY and help to build a better working world.

 

Design and deliver scalable, high-quality data models that enable enterprise analytics, reporting, and AI use cases. Translate business requirements into optimized data structures aligned with enterprise data architecture and governance standards.

Key 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

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)

Preferred

• Exposure to Dimensional Modeling, Data Vault 2.0 / Lakehouse architectures
• Familiarity with data governance tools (Collibra, Alation)
• Experience supporting AI/ML or advanced analytics data structures
• Domain experience in financial services / enterprise data modernization

Key Skills

• Strong analytical and problem-solving capability
• Ability to bridge business and technical stakeholders