Data Modeler Lead

Role Overview

The Data Modeler Lead is responsible for designing and maintaining robust data models across various platforms including data warehouses, data marts, staging areas, operational data stores, and big data environments. This role involves applying strict data naming standards, managing model repositories, and articulating data model decisions accurately.

Key Responsibilities

• Create and upkeep data models for diverse data storage systems such as data warehouses, marts, and big data platforms.
• Enforce data naming conventions and manage version control within model repositories while thoroughly documenting modeling decisions.
• Leverage data profiling tools and conduct quality assurance to validate and enhance data requirements.
• Collaborate closely with business units and application teams to implement data strategies and develop data flows through conceptual, logical, and physical data modeling.
• Govern and expand current data architecture and optimize query performance by adhering to industry best practices.
• Establish standards for document naming, security protocols, lifecycle management, and retention strategies.
• Support database administration teams in developing physical data models and deploying operational data stores, marts, and data lakes.
• Define and oversee enterprise-wide standards, tools, methodologies, and best practices for data modeling and design.
• Identify required architecture, infrastructure, interfaces, and security elements related to data sources, automated data loading tools, analytic models, and data visualization techniques.
• Proactively address project needs independently, effectively communicate challenges, and mitigate risks to ensure timely project delivery.

Qualifications and Experience

• A bachelor’s or master’s degree in computer science, data science, or related technical discipline.
• Extensive hands-on experience of at least 10 years in data modeling and related fields.
• Strong project management and organizational abilities.
• Expertise in data warehouse modeling including conceptual, logical, and physical designs, with experience in ODS, Enterprise Data Warehouses, Data Marts, and Big Data platforms.
• Proficiency with metadata management and data modeling tools such as Erwin, ER Studio, or equivalent.
• Practical skills in modeling, design, configuration, installation, performance tuning, and proof of concept initiatives.
• Advanced SQL skills and experience working with diverse relational database systems and query writing.
• Adept at conducting root cause analyses for data and process issues to resolve business queries and identify improvements.
• Experience collaborating with cross-functional teams in fast-paced environments.
• In-depth knowledge of SQL, relational database normalization (3NF for OLTP), dimensional modeling (OLAP), and full system development life cycles.
• Hands-on experience with dimensionally modeled datasets.
• Familiarity with Agile development methodologies.
• Experience managing data warehouse, data lake, and enterprise big data platforms across multiple data centers.
• Capability to use Business Intelligence tools such as Power BI for data visualization and insight presentation.