EY
Data Modeler - Manager - Consulting - Miami/South Florida
EY, Los Angeles, California, United States, 90079
Data Modeler - Manager - Consulting - Miami/South Florida
role at
EY
Location: Anywhere in Country. 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.
Key Responsibilities
Understand and analyze business requirements to translate them into technical requirements.
Design, build, and operate scalable data architecture and modeling solutions.
Stay up to date with the latest trends and emerging technologies to maintain a competitive edge.
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), especially SCD Type 2, to accurately capture and preserve the full historical context of dimension attributes.
Determine 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.
Manage and provide guidance to a small team of 1‑3 resources.
Document and communicate data model designs and standards.
Create detailed source‑to‑target mapping (STM) documentation and data transformation specifications for ETL/ELT developers, including SCD Type 2 logic and surrogate key generation rules.
Stay current with industry best practices and trends in data modelling and incorporate new techniques into our data modelling processes.
Guide team on implementing data modelling techniques such as Kimball’s dimensional modelling.
Utilize industry‑standard data modelling tools (e.g., Erwin, PowerDesigner, ER/Studio) to create and maintain conceptual, logical, and physical models, and manage version control.
Have cloud knowledge and certification; Azure DP‑203 preferred.
Qualifications
Bachelor’s degree in STEM.
10+ years of hands‑on experience in data modelling.
Strong understanding of SQL and data modelling concepts such as Kimball dimensional modelling.
Experience with enterprise relational databases or cloud data warehouses (e.g., Oracle, SQL Server).
Strong grasp of 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 analyze complex business processes and translate abstract business requirements into precise technical data models.
Proficiency with data modelling tools such as Erwin, Visio, or Power Designer.
Experience designing and implementing database structures.
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 advantage.
Strong analytical and problem‑solving skills.
Excellent communication and documentation skills.
Knowledge in Hospitality Domain mandatory.
Preferred Skills
Strong business acumen and experience managing complex client relationships.
Experience leading and influencing teams, with focus on mentorship and professional development.
Passion for innovation and strategic application of emerging technologies.
Inclusive leadership and ability to foster diverse perspectives.
Fluent in Spanish and Italian.
Azure DP‑203 certification preferred.
Benefits & Compensation
Base salary range: $125,500 – $230,200; adjusted by location ($150,700 – $261,600 in major metros).
Comprehensive benefits package including medical, dental, pension, 401(k), and paid time off.
Hybrid work model with 40–60% in‑person expectation for client‑serving roles.
Flexible vacation policy and EY Paid Holidays.
EY accepts applications for this position on an ongoing basis.
EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis. EY is committed to providing reasonable accommodation to qualified individuals with disabilities, including veterans.
#J-18808-Ljbffr
role at
EY
Location: Anywhere in Country. 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.
Key Responsibilities
Understand and analyze business requirements to translate them into technical requirements.
Design, build, and operate scalable data architecture and modeling solutions.
Stay up to date with the latest trends and emerging technologies to maintain a competitive edge.
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), especially SCD Type 2, to accurately capture and preserve the full historical context of dimension attributes.
Determine 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.
Manage and provide guidance to a small team of 1‑3 resources.
Document and communicate data model designs and standards.
Create detailed source‑to‑target mapping (STM) documentation and data transformation specifications for ETL/ELT developers, including SCD Type 2 logic and surrogate key generation rules.
Stay current with industry best practices and trends in data modelling and incorporate new techniques into our data modelling processes.
Guide team on implementing data modelling techniques such as Kimball’s dimensional modelling.
Utilize industry‑standard data modelling tools (e.g., Erwin, PowerDesigner, ER/Studio) to create and maintain conceptual, logical, and physical models, and manage version control.
Have cloud knowledge and certification; Azure DP‑203 preferred.
Qualifications
Bachelor’s degree in STEM.
10+ years of hands‑on experience in data modelling.
Strong understanding of SQL and data modelling concepts such as Kimball dimensional modelling.
Experience with enterprise relational databases or cloud data warehouses (e.g., Oracle, SQL Server).
Strong grasp of 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 analyze complex business processes and translate abstract business requirements into precise technical data models.
Proficiency with data modelling tools such as Erwin, Visio, or Power Designer.
Experience designing and implementing database structures.
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 advantage.
Strong analytical and problem‑solving skills.
Excellent communication and documentation skills.
Knowledge in Hospitality Domain mandatory.
Preferred Skills
Strong business acumen and experience managing complex client relationships.
Experience leading and influencing teams, with focus on mentorship and professional development.
Passion for innovation and strategic application of emerging technologies.
Inclusive leadership and ability to foster diverse perspectives.
Fluent in Spanish and Italian.
Azure DP‑203 certification preferred.
Benefits & Compensation
Base salary range: $125,500 – $230,200; adjusted by location ($150,700 – $261,600 in major metros).
Comprehensive benefits package including medical, dental, pension, 401(k), and paid time off.
Hybrid work model with 40–60% in‑person expectation for client‑serving roles.
Flexible vacation policy and EY Paid Holidays.
EY accepts applications for this position on an ongoing basis.
EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis. EY is committed to providing reasonable accommodation to qualified individuals with disabilities, including veterans.
#J-18808-Ljbffr