Data Modeler

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