Description

You will design and maintain logical and physical data models for data warehouse solutions.

This role is on-site.

Responsibilities

• Design and maintain logical and physical data models using Erwin.
• Implement star schema designs for data warehouses following Kimball methodology.
• Analyze existing data models and recommend architectural improvements.
• Develop and maintain comprehensive data dictionaries and model documentation.
• Collaborate with business analysts and data engineers to ensure data accuracy and performance.

Required Skills

• 8+ years of experience as an Erwin Data Modeler.
• Strong SQL skills for querying, data manipulation, and performance tuning.
• Proficiency in designing star schemas and implementing Kimball methodology.
• Data Modeling experience with Databricks.
• Experience with Power BI for data visualization.
• Familiarity with CPG industry data and business processes.
• Python proficiency.

Preferred Skills

• Deep understanding of CPG domain-specific data structures.
• Experience optimizing large-scale data warehouse performance.

Key Skills

Education

Any Graduate