Data Modeler - Manager - Consulting South

Overview

Location:

Anywhere in Country

Base pay range: $/yr - $/yr

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.

Technology – Data and Decision Science – Data Modeling – Manager

The opportunity:

We are looking for a dynamic and experienced Manager of Data Modeling to lead our team in designing and implementing complex cloud analytics solutions with a strong focus on Databricks. The ideal candidate will possess deep technical expertise in data architecture, cloud technologies, and analytics, along with exceptional leadership and client management skills.

Your

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), with emphasis on SCD Type 2, to preserve historical context of dimension attributes over time.

• Collaboratively determine the appropriate grain for fact tables and identify measurable facts and their relationships to dimension tables.

• Design highly denormalized dimension structures to reduce joins and simplify querying.

• Collaborate with stakeholders and cross-functional teams to understand data requirements and design models that align with business needs.

• Create and maintain data dictionaries and metadata repositories to ensure data model consistency and integrity.

• 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 detailed source-to-target mapping (STM) documentation and data transformation specifications for ETL/ELT, including all 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 modeling tools (e.g., Erwin, Power Designer, ER/Studio) to create and maintain models and manage version control.

• Having cloud knowledge and certification is an advantage; preferably Azure DP-203 certification.

Qualifications

• A 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 modeling

• Experience with major enterprise relational database platforms 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 for preserving historical data; familiarity with other SCD types

• Ability to analyze complex business processes and translate into precise data models

• Proficiency in data modelling tools such as Erwin, Visio, or Power Designer

• Experience in designing and implementing database structures and maintaining conceptual, logical, and physical data models

• 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 knowledge and certification is an added advantage

• Strong analytical and problem-solving skills

• Excellent communication and…