Key Responsibilities
Data Modeling & Design
Design, build, and maintain conceptual, logical, and physical data models for data warehouses, data lakes, and operational data stores.
Apply dimensional modeling techniques (Kimball star/snowflake schemas, slowly changing dimensions, conformed dimensions) and Inmon-style normalized enterprise models as appropriate.
Define naming conventions, modeling standards, and reusable design patterns; review peers’ models and provide constructive feedback.
Partner with data engineers to translate models into performant physical implementations and ELT/ETL pipelines.
Requirements Gathering & Stakeholder Engagement
Lead workshops with business stakeholders, product owners, and SMEs to elicit data requirements and translate them into clear modeling artifacts.
Document business definitions, source-to-target mappings, lineage, and data quality rules.
Act as a trusted advisor to analytics and engineering teams on the right modeling...