Data Modeler - Manager - Financial Services - Consulting
EY•New York, NY
•$125,500 - $261,600•Hybrid
About The Position
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.
Requirements
- 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)
Nice To Haves
- 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
- Strong analytical and problem-solving capability
- Ability to bridge business and technical stakeholders
- Deep understanding of data process lifecycle
- Clear communication and documentation skills
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
Benefits
- medical and dental coverage
- pension and 401(k) plans
- a wide range of paid time off options
- flexible vacation policy
- designated EY Paid Holidays
- Winter/Summer breaks
- Personal/Family Care
- other leaves of absence
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Manager
Education Level
No Education Listed
