Description

You will design and maintain dimensional models for analytical data marts.

This role is on-site.

Responsibilities

• Design dimensional models using Star Schema and best-practice techniques.
• Translate business requirements into physical and logical data models.
• Convert OLTP transactional data into OLAP analytical structures.
• Develop and optimize complex SQL queries in Amazon Redshift and PostgreSQL.
• Manage and version data models using Erwin Data Modeler.

Required Skills

• 5+ years of experience in data modeling for enterprise-scale analytical environments.
• Expertise in dimensional modeling, including Star Schema, Snowflake Schema, and slowly changing dimensions (SCDs).
• Strong SQL development skills in Amazon Redshift and PostgreSQL.
• Proficiency with Erwin Data Modeler or similar enterprise modeling tools.
• Hands-on experience in data profiling, lineage analysis, and source-to-target mapping.
• Deep understanding of OLTP to OLAP transformations.
• Familiarity with ETL design principles and data integration strategies.

Preferred Skills

• Any Graduate degree.

Key Skills

Education

Any Graduate