EY
Data Modeler - Manager - Consulting - Miami/South Florida
EY, Irvine, California, United States, 92713
Overview
Data Modeler - Manager - Consulting - Miami/South Florida role at EY. Location: Anywhere in Country.
Your Responsibilities
Understand and analyze business requirements to translate them into technical requirements.
Design, build, and operate scalable data architecture and modeling solutions.
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 analytics, BI, and reporting with high performance and query efficiency.
Define and model Slowly Changing Dimensions (SCD), with emphasis on SCD Type 2, to capture full historical context over time.
Collaboratively determine the appropriate grain for fact tables and identify measurable facts and their relationships to dimension tables.
Design 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 align data models 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 (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, 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 processes.
Guide the 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 modelling tools (e.g., Erwin, PowerDesigner, ER/Studio) to create and maintain models and manage version control.
Cloud knowledge and certification is advantageous (Azure DP-203 preferred).
Qualifications
A Bachelor's degree in STEM.
10+ years of hands-on experience in data modelling.
Strong understanding of SQL and data modelling concepts (Kimball dimensional modeling).
Experience with major enterprise relational databases 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 (SCD2) with surrogates; familiarity with other SCD types (1, 3, 4, 6) is expected.
Ability to translate complex business processes into precise data models.
Proficiency in data modelling tools such as Erwin, Visio, or PowerDesigner.
Experience designing and implementing database structures and maintaining conceptual, logical, and physical models.
Knowledge of industry best practices for data modelling and database design.
Ability to collaborate with cross-functional teams to gather requirements.
Experience in performance tuning and optimization of queries.
Cloud knowledge and certifications are an added advantage.
Strong analytical and problem-solving skills; excellent communication and documentation skills.
Knowledge in Hospitality Domain is mandatory.
Ideal/Preferred
Strong business acumen with the ability to manage complex client relationships.
Proven experience in leading teams within a dynamic environment.
Cloud knowledge and certifications (Azure DP-203) are advantageous.
Experience in leading and mentoring teams and fostering professional development.
Passion for innovation and applying emerging technologies to solve real-world challenges.
Ability to foster an inclusive environment and work with diverse perspectives.
Spanish and/or Italian language skills.
What We Look For We seek technically proficient professionals with strong collaboration, adaptability, and a drive for continuous learning. If you are results-driven with a desire to make an impact, we want to hear from you.
FY26NATAID
What We Offer You
Comprehensive compensation and benefits; base salary ranges vary by geography (examples provided in the original posting). Total Rewards include medical and dental coverage, pension and 401(k), and paid time off.
Hybrid work model with most client-facing roles expected to be in person 40-60% of the time.
Flexible vacation policy and designated holidays, with additional leave options for personal, family, and wellness needs.
Are you ready to shape your future with confidence? Apply today. EY accepts applications on an ongoing basis. For California residents, additional information is available. EY is committed to equal employment opportunities and provides reasonable accommodations to qualified individuals with disabilities.
Equal Opportunity Statement EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or other legally protected bases.
EY | Building a better working world. Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for today and tomorrow.
Heightened by a globally connected network with diverse ecosystem partners, EY offers services in more than 150 countries.
#J-18808-Ljbffr
Your Responsibilities
Understand and analyze business requirements to translate them into technical requirements.
Design, build, and operate scalable data architecture and modeling solutions.
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 analytics, BI, and reporting with high performance and query efficiency.
Define and model Slowly Changing Dimensions (SCD), with emphasis on SCD Type 2, to capture full historical context over time.
Collaboratively determine the appropriate grain for fact tables and identify measurable facts and their relationships to dimension tables.
Design 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 align data models 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 (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, 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 processes.
Guide the 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 modelling tools (e.g., Erwin, PowerDesigner, ER/Studio) to create and maintain models and manage version control.
Cloud knowledge and certification is advantageous (Azure DP-203 preferred).
Qualifications
A Bachelor's degree in STEM.
10+ years of hands-on experience in data modelling.
Strong understanding of SQL and data modelling concepts (Kimball dimensional modeling).
Experience with major enterprise relational databases 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 (SCD2) with surrogates; familiarity with other SCD types (1, 3, 4, 6) is expected.
Ability to translate complex business processes into precise data models.
Proficiency in data modelling tools such as Erwin, Visio, or PowerDesigner.
Experience designing and implementing database structures and maintaining conceptual, logical, and physical models.
Knowledge of industry best practices for data modelling and database design.
Ability to collaborate with cross-functional teams to gather requirements.
Experience in performance tuning and optimization of queries.
Cloud knowledge and certifications are an added advantage.
Strong analytical and problem-solving skills; excellent communication and documentation skills.
Knowledge in Hospitality Domain is mandatory.
Ideal/Preferred
Strong business acumen with the ability to manage complex client relationships.
Proven experience in leading teams within a dynamic environment.
Cloud knowledge and certifications (Azure DP-203) are advantageous.
Experience in leading and mentoring teams and fostering professional development.
Passion for innovation and applying emerging technologies to solve real-world challenges.
Ability to foster an inclusive environment and work with diverse perspectives.
Spanish and/or Italian language skills.
What We Look For We seek technically proficient professionals with strong collaboration, adaptability, and a drive for continuous learning. If you are results-driven with a desire to make an impact, we want to hear from you.
FY26NATAID
What We Offer You
Comprehensive compensation and benefits; base salary ranges vary by geography (examples provided in the original posting). Total Rewards include medical and dental coverage, pension and 401(k), and paid time off.
Hybrid work model with most client-facing roles expected to be in person 40-60% of the time.
Flexible vacation policy and designated holidays, with additional leave options for personal, family, and wellness needs.
Are you ready to shape your future with confidence? Apply today. EY accepts applications on an ongoing basis. For California residents, additional information is available. EY is committed to equal employment opportunities and provides reasonable accommodations to qualified individuals with disabilities.
Equal Opportunity Statement EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or other legally protected bases.
EY | Building a better working world. Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for today and tomorrow.
Heightened by a globally connected network with diverse ecosystem partners, EY offers services in more than 150 countries.
#J-18808-Ljbffr