Data Modeler - Senior - Consulting - Miami​/South Florida

Pay found in job post

Retrieved from the description.

$/yr - $/yr

Anywhere in Country

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 build a better working world.

AI & Data – Data Modeler – Senior

We are seeking a highly skilled Senior Consultant Data Modeler with expertise in delivering data models that meet business requirements. The ideal candidate will have strong client management and communication skills, and a proven track record of successful end‑to‑end implementations in data engineering projects.

• Lead the design and development of conceptual, logical, and physical data models for the Enterprise Data Warehouse (EDW), adhering to Kimball dimensional methodology.
• Design and implement star schemas (Fact and Dimension tables) to support enterprise analytical, BI, and reporting requirements with high performance and query efficiency.
• Define and model Slowly Changing Dimensions (SCD), with an emphasis on SCD Type 2.
• Determine the appropriate grain for fact tables and identify measurable facts and their relationships to dimension tables.
• Design highly denormalized dimension structures to reduce joins and simplify querying for end‑users and analytical tools.
• Collaborate with stakeholders and cross‑functional teams to understand data requirements and design appropriate data models that align with business needs.
• Create and maintain data dictionaries and metadata repositories.
• Identify and resolve data model performance issues to optimize database performance.
• Manage and provide guidance to a small team of 1‑3 resources.
• Document and communicate data model designs and standards across the organization.
• Create detailed source‑to‑target mapping (STM) documentation and data transformation specifications for ETL/ELT developers.
• Stay current with industry best practices and trends in data modelling.
• Guide team on implementing data modelling techniques such as Kimball’s dimensional modeling.
• Utilize industry‑standard tools (Erwin, Power Designer, ER/Studio) and manage version control.

• Bachelor’s degree in STEM.
• 7+ years of hands‑on experience in data modelling.
• Strong understanding of SQL and Kimball dimensional modelling.
• Experience with enterprise relational database platforms or cloud data warehouses (e.g., Oracle, SQL Server).
• Knowledge of data warehousing principles, ETL/ELT architecture, data quality management, and metadata management.
• Mastery of SCD Type 2 implementation.
• Ability to translate complex business requirements into precise technical data models.
• Proficiency in data modelling tools such as Erwin, Visio, or Power Designer.
• Experience in designing and implementing database structures.
• Performance tuning and optimization of database queries.
• Cloud certification is an added advantage.
• Strong analytical and problem‑solving skills.
• Excellent communication and documentation skills.
• Knowledge in Hospitality Domain is mandatory.

• Ability to navigate complex issues and make informed decisions.
• Experience supervising and guiding junior team members.
• Participation in sales opportunities and RFP responses.
• Cloud knowledge and/or certification (preferably Azure DP‑203).
• Passion for innovation and emerging technologies.
• Spanish speaking.
• Italian speaking.

• Comprehensive compensation and benefits package.
• Base salary range for all geographic locations in the US is $106,900 to $176,500.
• Medical and dental coverage, pension and 401(k) plans, and paid time off options.
• Hybrid work model with 40‑60% onsite requirement.
• Flexible vacation policy with designated paid holidays and other leaves of absence.

Apply today. EY accepts applications for this position on an on‑going basis.

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

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

EY teams work across a full spectrum of…