Lead Data Modeler

Job Summary:

We are seeking an experienced and detail-oriented Lead Data Modeler to design, implement, and manage robust data models that support our enterprise data warehouse and analytics ecosystem. The ideal candidate will have deep expertise in data analysis, dimensional modeling, and database design, with strong hands-on experience using tools like ERwin to create scalable, optimized, and maintainable data structures.

Key Responsibilities:

• Analyze business requirements and translate them into logical and physical data models.
  
• Design and develop enterprise-level conceptual, logical, and physical data models for OLTP and OLAP systems.
  
• Build and maintain dimensional models (star/snowflake schemas) to support business intelligence and reporting needs.
  
• Lead the data modeling and data architecture efforts for large-scale data warehouse and data integration projects.
  
• Define data standards, naming conventions, metadata, and data lineage documentation.
  
• Work closely with business analysts, data engineers, and application developers to ensure alignment of data structures with business needs.
  
• Collaborate with DBAs and ETL developers to implement models in physical databases.
  
• Use ERwin (or similar data modeling tools) to create and manage models and reverse-engineer existing structures.
  
• Ensure data models are optimized for performance, scalability, and data integrity.
  
• Participate in data governance initiatives and data quality improvement projects.

Required Skills & Qualifications:

• 8-12 years of experience in data modeling, data architecture, and database design.
  
• Strong experience with dimensional modeling, data warehouse architecture, and data mart development.
  
• Strong Proficiency in ERwin Data Modeler (or equivalent tools such as PowerDesigner).
  
• Solid understanding of relational databases (e.g., SQL Server, Oracle, PostgreSQL) and data warehouse platforms.
  
• Strong SQL skills and ability to analyze and understand complex data sets.
  
• Experience with data integration, ETL, and data governance principles.
  
• Ability to manage multiple priorities in a fast-paced environment and work collaboratively across teams.
  
• Strong communication and documentation skills.
  

Preferred Qualifications:

• Experience in cloud-based data platforms (e.g., Azure Synapse, Snowflake, AWS Redshift).
  
• Familiarity with Data Vault modeling or NoSQL modeling is a plus.
  
• Experience in Agile/Scrum environments and using version control tools (e.g., Git)