Data Modeler - Senior - Consulting South

Data Modeler - Senior – Consulting – Miami/South Florida

EY is hiring a Senior Consultant Data Modeler to design and build analytics solutions that deliver significant business value. The role is located in Miami/South Florida and is suitable for professionals who thrive in a globally connected, inclusive culture.

Location: Anywhere in Country (preferred in Miami/South Florida)

Key Responsibilities

• Lead the design and development of conceptual, logical, and physical data models for the Enterprise Data Warehouse (EDW) using Kimball dimensional methodology.
• Design and implement star schemas to support analytical, BI, and reporting requirements with high performance and query efficiency.
• Define and model Slowly Changing Dimensions (SCD), emphasizing SCD Type 2 for accurate historical tracking.
• Determine appropriate grain for fact tables and identify measurable facts and their relationships.
• Design highly denormalized dimension structures to reduce joins and simplify end‑user queries.
• Collaborate with stakeholders to understand business requirements and design appropriate data models.
• Create and maintain data dictionaries and metadata repositories for consistency and integrity.
• Identify and resolve data model performance issues to optimize database performance.
• Manage and guide 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 transformation specifications for ETL/ELT developers.
• Stay current with industry best practices and incorporate new techniques into data modeling processes.
• Guide the team on implementing Kimball dimensional modeling techniques.
• Develop and maintain conceptual, logical, and physical models using industry‑standard tools such as Erwin, Power Designer, or ER/Studio, and manage version control.

Qualifications

• Bachelor’s degree in STEM.
• 7+ years of hands‑on experience in data modeling.
• Strong understanding of SQL and Kimball dimensional modeling concepts.
• Experience with major enterprise relational database platforms or cloud data warehouses (e.g., Oracle, SQL Server).
• Proficiency in data warehousing principles, ETL/ELT architecture, data quality management, and metadata management.
• Mastery of SCD Type 2 implementation and familiarity with other SCD types.
• Ability to translate complex business requirements into efficient technical data models.
• Proficiency in data modeling tools such as Erwin, Visio, or Power Designer.
• Performance tuning and query optimization experience.
• Cloud certification (e.g., Azure DP‑203) is an added advantage.
• Strong analytical, problem‑solving, communication, and documentation skills.
• Knowledge of the hospitality domain is mandatory.

Preferred Qualifications

• Experience supervising and guiding junior team members.
• Participation in sales opportunities and RFP responses.
• Spanish and/or Italian speaking.
• Passion for innovation and emerging technologies.

EY offers competitive compensation and benefits, including medical, dental, retirement plans, and generous paid time off. We are committed to building a better working world through diversity, equity, and inclusion.

EY accepts applications for this position on an ongoing basis. For candidates with disabilities, EY provides reasonable accommodations.

EY is an equal employment opportunity employer and follows all applicable laws regarding discrimination and disability accommodations.