Data Modeler - Manager - Financial Services - Consulting

Ernst & Young Advisory Services Sdn Bhd; New York (NY); Hybrid; USD 150,700 - 261,600; Full time

Benefits offered by this job

Hybrid work model

Medical and dental coverage

401(k) plans

Paid time off options

Job summary

EY seeks a Data Modeler - Manager to design and deliver scalable data models for analytics, governance, and AI use cases. Located in New York, you will translate business requirements into conceptual, logical, and physical models across Snowflake, Azure, and Databricks, and collaborate with data engineers on ETL/ELT mappings and lineage.

You will drive data quality, metadata management, and documentation while aligning with enterprise architecture and data standards in a hybrid work environment.

Qualifications

• 10+ years in data modeling / data architecture.
• 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 platforms.
• Design dimensional and normalized models based on use case.
• Translate business requirements into entities, attributes, relationships, and 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, metadata management and documentation.
• Optimize models for performance, scalability and cost.
• Maintain data dictionaries, lineage and design documentation.

Skills

Data modeling

Data architecture

Snowflake

Databricks

SQL

Data warehousing

Cloud data platforms

Tools

ERwin

ER/Studio

PowerDesigner

Job description

Data Modeler - Manager - Financial Services - Consulting

Location: New York

Other locations: Primary Location Only

Date: Jul 27, 2026

Requisition ID: 1728580

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
• 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
• Deep understanding of data process lifecycle
• Clear communication and documentation skills

What we offer you
At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learnmore .

• We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. The base salary range for this job in all geographic locations in the US is $125,500 to $230,200. The base salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $150,700 to $261,600. Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.
• Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year.
• Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information,national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law.

EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at [e-mail] .

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.