Senior Data Modeler

Job description

Job Description

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
• Denormalized analytical data structures
• Customer 360 architectures
• Experience interpreting complex SQL transformation logic.
• Ability to navigate environments containing hundreds of interconnected tables and datasets.