Senior Data Modeler

Roles and Responsibilities

• Key Responsibilities
• Analyse and document the current-state customer data ecosystem across staging, integration, and consumption layers.
• Trace data lineage from source systems through transformation pipelines into customer data marts.
• Reverse engineer existing BigQuery schemas, transformation logic, and table dependencies.
• Understand and document how customer attributes, metrics, and business rules are derived.
• Identify modelling issues, redundancies, duplication, and inefficient data structures.
• Assess the suitability of current dimensional, denormalized, and analytical data models.
• Create conceptual, logical, and physical data models for customer domains.
• Collaborate with business stakeholders, data engineers, analysts, and architects to validate findings.
• Produce source-to-target mappings and transformation documentation.
• Recommend target-state modelling approaches including dimensional modelling, wide-table strategies, or domain-oriented designs where appropriate.
• Support estimation and roadmap development for customer data mart modernization initiatives.
• Establish traceability between business requirements, customer metrics, and underlying data assets.
• Required Experience
• 8+ years of data modelling and data engineering experience.
• Strong expertise in customer, CRM, loyalty, marketing, or customer analytics domains.
• Hands-on experience with Google BigQuery.
• Proven experience reverse engineering complex data platforms and undocumented environments.
• Strong understanding of:
• Data lineage analysis
• Source-to-target mapping
• Dimensional modelling
• Star schemas