EY
Data Modeler - Manager - Consulting - Miami/South Florida
EY, Baton Rouge, Louisiana, us, 70873
Data Modeler – Manager – Consulting – Miami/South Florida
Location: Anywhere in Country
Join EY and shape a better working world. We help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Key Responsibilities
Design and build analytics solutions that deliver significant business value.
Collaborate with data and analytics professionals, management, and stakeholders to translate business requirements into technical solutions.
Understand and analyze business requirements to translate them into technical requirements.
Design, build, and operate scalable data architecture and modeling solutions.
Remain current with emerging technologies to maintain a competitive edge.
Lead design and development of conceptual, logical, and physical data models for the Enterprise Data Warehouse (EDW) using Kimball dimensional methodology.
Design star schemas (fact and dimension tables) to support BI and reporting with high performance and query efficiency.
Define and model Slowly Changing Dimensions (SCD), primarily SCD Type 2.
Determine appropriate grain for fact tables and identify measurable facts and their relationships to surrounding dimensions.
Design highly denormalized dimension structures to reduce joins and simplify querying for end‑users and analytical tools.
Create and maintain data dictionaries and metadata repositories.
Identify and resolve data model performance issues to optimize database performance.
Manage and guide a small team of 1‑3 resources.
Document and communicate data model designs and standards.
Create source‑to‑target mapping and data transformation specifications for ETL/ELT developers.
Apply industry best practices and incorporate new data modelling techniques.
Utilize data‑modelling tools such as Erwin, PowerDesigner, and ER/Studio.
Qualifications
Bachelor’s degree in STEM.
10+ years of hands‑on experience in data modelling.
Strong understanding of SQL and Kimball dimensional modelling concepts.
Experience with enterprise relational database platforms or cloud data warehouses (e.g., Oracle, SQL Server).
Knowledge of data warehousing principles, ETL/ELT architecture, data quality management, and metadata management.
Mastery of SCD Type 2 implementation; familiarity with other SCD types.
Ability to analyze complex business processes and translate requirements into efficient technical data models.
Proficiency with data‑modelling tools (Erwin, Visio, PowerDesigner).
Experience designing and implementing database structures.
Strong analytical and problem‑solving skills.
Excellent communication and documentation skills.
Knowledge in Hospitality Domain is mandatory.
Cloud certification (e.g., Azure DP‑203) is an advantage.
Preferred Qualifications
Strong business acumen and ability to manage complex client relationships.
Proven experience managing and leading teams in a dynamic environment.
Excellent communication and interpersonal skills.
Experience in mentorship and professional development.
Passion for innovation and strategic application of emerging technologies.
Ability to foster an inclusive environment that values diverse perspectives.
Spanish speaking.
Italian speaking.
What We Offer
Competitive compensation: base salary range $125,500 to $230,200 (US) plus performance‑based rewards.
Medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off.
Hybrid work model; most client‑serving roles work together in person 40‑60% of the time.
Flexible vacation policy tailored to personal circumstances.
Equal Employment Opportunity FY26NATAID
EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity or expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis.
Reasonable Accommodation We are committed to providing reasonable accommodation to qualified individuals with disabilities. If you require assistance applying online or need to request an accommodation during any part of the application process, please call 1‑800‑EY‑HELP3 and navigate as instructed, or email TSS at ssc.customersupport@ey.com.
Application EY accepts applications for this position on an ongoing basis. If you are ready to shape your future with confidence, apply today.
#J-18808-Ljbffr
Join EY and shape a better working world. We help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Key Responsibilities
Design and build analytics solutions that deliver significant business value.
Collaborate with data and analytics professionals, management, and stakeholders to translate business requirements into technical solutions.
Understand and analyze business requirements to translate them into technical requirements.
Design, build, and operate scalable data architecture and modeling solutions.
Remain current with emerging technologies to maintain a competitive edge.
Lead design and development of conceptual, logical, and physical data models for the Enterprise Data Warehouse (EDW) using Kimball dimensional methodology.
Design star schemas (fact and dimension tables) to support BI and reporting with high performance and query efficiency.
Define and model Slowly Changing Dimensions (SCD), primarily SCD Type 2.
Determine appropriate grain for fact tables and identify measurable facts and their relationships to surrounding dimensions.
Design highly denormalized dimension structures to reduce joins and simplify querying for end‑users and analytical tools.
Create and maintain data dictionaries and metadata repositories.
Identify and resolve data model performance issues to optimize database performance.
Manage and guide a small team of 1‑3 resources.
Document and communicate data model designs and standards.
Create source‑to‑target mapping and data transformation specifications for ETL/ELT developers.
Apply industry best practices and incorporate new data modelling techniques.
Utilize data‑modelling tools such as Erwin, PowerDesigner, and ER/Studio.
Qualifications
Bachelor’s degree in STEM.
10+ years of hands‑on experience in data modelling.
Strong understanding of SQL and Kimball dimensional modelling concepts.
Experience with enterprise relational database platforms or cloud data warehouses (e.g., Oracle, SQL Server).
Knowledge of data warehousing principles, ETL/ELT architecture, data quality management, and metadata management.
Mastery of SCD Type 2 implementation; familiarity with other SCD types.
Ability to analyze complex business processes and translate requirements into efficient technical data models.
Proficiency with data‑modelling tools (Erwin, Visio, PowerDesigner).
Experience designing and implementing database structures.
Strong analytical and problem‑solving skills.
Excellent communication and documentation skills.
Knowledge in Hospitality Domain is mandatory.
Cloud certification (e.g., Azure DP‑203) is an advantage.
Preferred Qualifications
Strong business acumen and ability to manage complex client relationships.
Proven experience managing and leading teams in a dynamic environment.
Excellent communication and interpersonal skills.
Experience in mentorship and professional development.
Passion for innovation and strategic application of emerging technologies.
Ability to foster an inclusive environment that values diverse perspectives.
Spanish speaking.
Italian speaking.
What We Offer
Competitive compensation: base salary range $125,500 to $230,200 (US) plus performance‑based rewards.
Medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off.
Hybrid work model; most client‑serving roles work together in person 40‑60% of the time.
Flexible vacation policy tailored to personal circumstances.
Equal Employment Opportunity FY26NATAID
EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity or expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis.
Reasonable Accommodation We are committed to providing reasonable accommodation to qualified individuals with disabilities. If you require assistance applying online or need to request an accommodation during any part of the application process, please call 1‑800‑EY‑HELP3 and navigate as instructed, or email TSS at ssc.customersupport@ey.com.
Application EY accepts applications for this position on an ongoing basis. If you are ready to shape your future with confidence, apply today.
#J-18808-Ljbffr