Senior Data Modeler - Enterprise Data Warehouse

Senior Data Modeler - Enterprise Data Warehouse

We are seeking a highly experienced Senior Data Modeler to lead the design, development, and ongoing evolution of dimensional data models for a large-scale enterprise data warehouse, primarily built on Amazon Redshift. This role is critical in shaping the analytical capabilities of our enterprise platform, ensuring data is trustworthy, structured effectively, and optimized for informed decision-making.

Key Responsibilities:

• Lead the design and maintenance of enterprise-grade dimensional models adhering to Kimball methodology.
• Develop fact tables, dimensions, conformed dimensions, and implement robust surrogate key strategies.
• Ensure data models are optimized for Amazon Redshift performance, including strategic use of distribution styles, sort keys, and understanding query patterns.
• Review and refactor existing data models to enhance usability, performance, and scalabilit...