Data Modeler - Senior - Consulting South

Data Modeler - Senior (Consulting) – Miami/South Florida

Location:

Anywhere in Country. Join EY, a global leader shaping client futures through consulting, assurance, tax, and strategy services.

• 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, Business Intelligence (BI), and reporting requirements with high performance and query efficiency.
• Define and model Slowly Changing Dimensions (SCD) with emphasis on SCD Type 2 to capture and preserve historical context of dimension attributes.
• Collaboratively determine the appropriate grain for fact tables and identify measurable facts (metrics) and their relationships to 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 our 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.

• 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 modelling.
• 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, active flags). Familiarity with other SCD types is also expected.
• Ability to analyze complex business processes and translate abstract business requirements into precise, efficient technical data models.
• Proficiency in data modelling tools such as Erwin, Visio, or Power Designer.
• Experience designing and implementing database structures and performance tuning of database queries.
• Strong analytical and problem‑solving skills.
• Excellent communication and documentation skills.
• Knowledge in the Hospitality Domain is mandatory.
• Having a cloud certification is an added advantage.

• Proven ability to navigate complex issues and make informed decisions.
• Experience supervising and guiding junior team members.
• Demonstrated participation in sales opportunities and RFP responses.
• Cloud knowledge and/or certification – preferably Azure DP‑203.
• A passion for innovation and the strategic application of emerging technologies to solve real‑world challenges.
• Spanish speaking.
• Italian speaking.

• Competitive base salary ranging from $106,900 to $176,500, with additional performance bonuses.
• Medical, dental, vision, and life insurance coverage.
• Retirement plans (401(k) with employer match).
• Generous paid time off, including vacation, sick, and paid holidays.
• Flexibility to work 40‑60% in person and 40‑60% remotely.
• Career development programs,…