Data Modeler

Job Description:-

Key Responsibilities:

• Design and maintain dimensional models using Star Schema and other best-practice techniques for analytical data marts.
• Work closely with business stakeholders and data engineers to define data requirements and translate them into physical and logical models.
• Conduct data analysis to convert OLTP (transactional) data into OLAP (analytical) structures.
• Develop and optimize complex SQL queries in Amazon Redshift and PostgreSQL to support ETL and reporting.
• Utilize Erwin Data Modeler to create, manage, and version data models.
• Ensure data models support performance, scalability, data integrity, and compliance with enterprise data architecture standards.
• Participate in data governance activities and metadata documentation efforts.
• Collaborate with Scrum team members and contribute to agile planning, story writing, and sprint execution.

Required Qualifications:

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