EY
Data Modeler - Senior - Consulting - Miami/South Florida
EY, Columbus, Ohio, United States, 43224
Overview
Data Modeler - Senior - Consulting - Miami/South Florida at EY. Location: Anywhere in Country. EY is shaping the future with confidence and building a better working world.
Responsibilities
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.
Define and model Slowly Changing Dimensions (SCD), with emphasis on SCD Type 2.
Collaboratively determine the appropriate grain for fact tables and identify measurable facts and their relationships to dimensions.
Design denormalized dimension structures to reduce joins and simplify querying.
Collaborate with stakeholders to understand data requirements and align data models with business needs.
Create and maintain data dictionaries and metadata repositories.
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 across the organization.
Create source-to-target mappings (STM) and data transformation specifications for ETL/ELT, including SCD Type 2 logic and surrogate key rules.
Stay current with industry best practices in data modelling and incorporate new techniques.
Guide the team on Kimball dimensional modeling techniques.
Develop conceptual, logical, and physical data models to support data analysis and business intelligence.
Utilize data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio) to create models and manage version control.
Qualifications
Bachelor’s degree in STEM.
7+ years of hands-on experience in data modelling.
Strong SQL and data modeling knowledge, including Kimball dimensional modeling.
Experience with major enterprise relational databases or cloud data warehouses (e.g., Oracle, SQL Server).
Strong understanding of data warehousing, ETL/ELT architecture, data quality, and metadata management.
Mastery of SCD Type 2; familiarity with other SCD types (1, 3, 4, 6).
Ability to translate complex business processes into precise data models.
Proficiency with data modeling tools (Erwin / Visio / Power Designer).
Experience designing and implementing database structures and maintaining conceptual, logical, and physical data models.
Knowledge of industry best practices for data modeling and database design.
Ability to collaborate with cross-functional teams to gather requirements.
Experience in performance tuning and optimization of queries.
Cloud knowledge or certification is a plus.
Strong analytical, problem-solving, communication, and documentation skills.
Knowledge in Hospitality Domain is mandatory.
What We Look For Top performers with a keen eye for detail, data-driven solutions, and the ability to thrive in a collaborative environment. Proactive problem-solving and technical expertise help you stand out.
What We Offer You EY provides future-focused development, a flexible environment, and a diverse, inclusive culture. The total rewards package includes comprehensive compensation, benefits, and paid time off. Most client-facing roles are hybrid (40-60% in-person).
Equal Opportunity 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 any other legally protected basis. EY is committed to reasonable accommodation for qualified individuals with disabilities, including veterans. If you need assistance applying online or an accommodation during any part of the application process, please contact EY’s Talent Shared Services Team.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Professional Services
#J-18808-Ljbffr
Responsibilities
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.
Define and model Slowly Changing Dimensions (SCD), with emphasis on SCD Type 2.
Collaboratively determine the appropriate grain for fact tables and identify measurable facts and their relationships to dimensions.
Design denormalized dimension structures to reduce joins and simplify querying.
Collaborate with stakeholders to understand data requirements and align data models with business needs.
Create and maintain data dictionaries and metadata repositories.
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 across the organization.
Create source-to-target mappings (STM) and data transformation specifications for ETL/ELT, including SCD Type 2 logic and surrogate key rules.
Stay current with industry best practices in data modelling and incorporate new techniques.
Guide the team on Kimball dimensional modeling techniques.
Develop conceptual, logical, and physical data models to support data analysis and business intelligence.
Utilize data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio) to create models and manage version control.
Qualifications
Bachelor’s degree in STEM.
7+ years of hands-on experience in data modelling.
Strong SQL and data modeling knowledge, including Kimball dimensional modeling.
Experience with major enterprise relational databases or cloud data warehouses (e.g., Oracle, SQL Server).
Strong understanding of data warehousing, ETL/ELT architecture, data quality, and metadata management.
Mastery of SCD Type 2; familiarity with other SCD types (1, 3, 4, 6).
Ability to translate complex business processes into precise data models.
Proficiency with data modeling tools (Erwin / Visio / Power Designer).
Experience designing and implementing database structures and maintaining conceptual, logical, and physical data models.
Knowledge of industry best practices for data modeling and database design.
Ability to collaborate with cross-functional teams to gather requirements.
Experience in performance tuning and optimization of queries.
Cloud knowledge or certification is a plus.
Strong analytical, problem-solving, communication, and documentation skills.
Knowledge in Hospitality Domain is mandatory.
What We Look For Top performers with a keen eye for detail, data-driven solutions, and the ability to thrive in a collaborative environment. Proactive problem-solving and technical expertise help you stand out.
What We Offer You EY provides future-focused development, a flexible environment, and a diverse, inclusive culture. The total rewards package includes comprehensive compensation, benefits, and paid time off. Most client-facing roles are hybrid (40-60% in-person).
Equal Opportunity 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 any other legally protected basis. EY is committed to reasonable accommodation for qualified individuals with disabilities, including veterans. If you need assistance applying online or an accommodation during any part of the application process, please contact EY’s Talent Shared Services Team.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Professional Services
#J-18808-Ljbffr