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

Overview

Data Modeler – Senior - Consulting - Miami/South Florida  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, along with 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 (dimensional modeling approach).
• 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, to accurately capture and preserve the full historical context of dimension attributes over time.
• Collaboratively determine the appropriate grain for fact tables and identify measurable facts and their relationships to the surrounding 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 to ensure consistency and integrity of data models.
• Identify and resolve data model performance issues to optimize database performance and enhance overall system functionality.
• Manage and provide guidance to a small team of 1-3 resources.
• Document and communicate data model designs and standards to ensure understanding and compliance across the organization.
• Create detailed source-to-target mapping (STM) documentation and data transformation specifications for ETL/ELT developers, including all SCD Type 2 logic and surrogate key generation rules.
• Stay current with industry best practices and trends in data modelling and incorporate new techniques and methodologies into data modelling processes.
• Guide team on implementing data modelling techniques such as Kimball’s dimensional modeling.
• Develop conceptual, logical, and physical data models to support data analysis and business intelligence.
• Utilize industry-standard data modeling tools (e.g., Erwin, Power Designer, ER/Studio) to create and maintain models and to manage version control.

• A Bachelor’s degree in STEM
• 7+ years of hands-on experience in data modelling
• Strong understanding of SQL and data modelling concepts such as Kimball dimensional modeling
• Experience working with major enterprise relational database platforms or cloud data warehouses (e.g., Oracle, SQL Server)
• Strong understanding of data warehousing principles, ETL/ELT architecture, data quality management, and metadata management
• Mastery of SCD Type 2 implementation for preserving historical data (surrogate keys, start/end dates, current/active flags); familiarity with other SCD types
• Ability to analyze complex business processes and translate requirements into precise data models
• Proficiency in data modelling tools such as Erwin, Visio, or Power Designer
• Experience in designing and implementing database structures and maintaining conceptual, logical, and physical data models
• Knowledge of industry best practices for data modelling and database design
• Ability to collaborate with cross-functional teams to gather and analyze data requirements
• Experience in 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

• Proven ability to navigate complex issues and make informed decisions
• Experience in supervising and guiding junior team members
• Participation in sales opportunities and RFP responses
• Cloud knowledge and/or certification (Azure DP-203 preferred)
• Passion for innovation and applying emerging technologies to real-world challenges
• Spanish and/or Italian speaking abilities

We seek top performers with a keen eye for detail, a passion for data-driven solutions, and the ability to thrive in a collaborative environment. Your proactive approach to problem-solving, combined with your technical expertise, will set you apart as a candidate.

• A comprehensive compensation and benefits package with a base salary range of $106,900 to $176,500 (varies by geography); total rewards include medical and dental coverage, pension and 401(k), and various Paid Time Off options.
• Hybrid work model and flexible vacation policy; work arrangements are client-facing and may require in-person collaboration.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender…