Senior Data Modeler - Tata Consultancy Services - Experience interpreting complex SQL transformation

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.
Location
Melbourne
Job Function
TECHNOLOGY
Role
Engineer
Job Id
419335
Desired Skills
Data Modeling