EY
Data Modeler - Manager - Consulting - Miami/South Florida
EY, Tulsa, Oklahoma, United States, 74145
Overview
Data Modeler - Manager - Consulting - Miami/South Florida
at
EY . Location: Anywhere in Country. EY is shaping your future with confidence and helping you build a better working world through diverse teams and cloud analytics solutions, with a focus on Databricks and data modeling leadership. Your Key Responsibilities
Understand and analyze business requirements and 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 enterprise analytics, BI, and reporting with high performance. Define and model Slowly Changing Dimensions (SCD), with emphasis on SCD Type 2, to preserve 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 to 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. Provide guidance to a small team (1-3 resources) and document data model designs and standards for organization-wide understanding. Create detailed source-to-target mapping (STM) for ETL/ELT developers, including SCD Type 2 logic and surrogate key rules. Stay current with industry best practices and incorporate new techniques into data modeling processes. Utilize data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio) for model creation and version control. Possess cloud knowledge; certification is an advantage (preferably Azure DP-203). Qualifications
Bachelor’s degree in STEM. 10+ years of hands-on experience in data modeling. 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 is expected. Ability to analyze complex business processes and translate into precise technical data models. Proficiency in data modeling tools (Erwin, Visio, or Power Designer). Experience designing and implementing database structures and maintaining conceptual, logical, and physical models. Knowledge of industry best practices for data modeling and database design. Ability to collaborate with cross-functional teams to gather requirements; experience with performance tuning of queries. Cloud certification is a plus. Strong analytical, problem-solving, and communication/documentation skills. Knowledge of Hospitality Domain is desirable. Preferred/Additional
Strong business acumen with the ability to manage complex client relationships. Experience leading teams; mentorship and professional development experience. Spanish and/or Italian language skills are a bonus. Willingness to apply emerging technologies to solve real-world challenges and foster an inclusive environment. What We Look For
Individuals who are technically proficient and collaborative, with a passion for continuous learning and results-driven impact. What We Offer You
Compensation and benefits package with a base salary range; details vary by geography. The Total Rewards package includes medical/dental coverage, pension/401(k), and paid time off options. Hybrid/work flexibility: expectation to work client-facing engagements in person 40-60% of the time. Flexible vacation policy and designated holidays, personal/family care leave, and other supports for well-being. Are you ready to shape your future with confidence? Apply today. EY accepts applications on an ongoing basis. EY focuses on equal employment opportunities and inclusive practices in accordance with applicable law. EY is committed to providing reasonable accommodations during the application process. Company Notes
EY | Building a better working world. Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence.
#J-18808-Ljbffr
Data Modeler - Manager - Consulting - Miami/South Florida
at
EY . Location: Anywhere in Country. EY is shaping your future with confidence and helping you build a better working world through diverse teams and cloud analytics solutions, with a focus on Databricks and data modeling leadership. Your Key Responsibilities
Understand and analyze business requirements and 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 enterprise analytics, BI, and reporting with high performance. Define and model Slowly Changing Dimensions (SCD), with emphasis on SCD Type 2, to preserve 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 to 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. Provide guidance to a small team (1-3 resources) and document data model designs and standards for organization-wide understanding. Create detailed source-to-target mapping (STM) for ETL/ELT developers, including SCD Type 2 logic and surrogate key rules. Stay current with industry best practices and incorporate new techniques into data modeling processes. Utilize data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio) for model creation and version control. Possess cloud knowledge; certification is an advantage (preferably Azure DP-203). Qualifications
Bachelor’s degree in STEM. 10+ years of hands-on experience in data modeling. 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 is expected. Ability to analyze complex business processes and translate into precise technical data models. Proficiency in data modeling tools (Erwin, Visio, or Power Designer). Experience designing and implementing database structures and maintaining conceptual, logical, and physical models. Knowledge of industry best practices for data modeling and database design. Ability to collaborate with cross-functional teams to gather requirements; experience with performance tuning of queries. Cloud certification is a plus. Strong analytical, problem-solving, and communication/documentation skills. Knowledge of Hospitality Domain is desirable. Preferred/Additional
Strong business acumen with the ability to manage complex client relationships. Experience leading teams; mentorship and professional development experience. Spanish and/or Italian language skills are a bonus. Willingness to apply emerging technologies to solve real-world challenges and foster an inclusive environment. What We Look For
Individuals who are technically proficient and collaborative, with a passion for continuous learning and results-driven impact. What We Offer You
Compensation and benefits package with a base salary range; details vary by geography. The Total Rewards package includes medical/dental coverage, pension/401(k), and paid time off options. Hybrid/work flexibility: expectation to work client-facing engagements in person 40-60% of the time. Flexible vacation policy and designated holidays, personal/family care leave, and other supports for well-being. Are you ready to shape your future with confidence? Apply today. EY accepts applications on an ongoing basis. EY focuses on equal employment opportunities and inclusive practices in accordance with applicable law. EY is committed to providing reasonable accommodations during the application process. Company Notes
EY | Building a better working world. Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence.
#J-18808-Ljbffr