Data Architect

Job Title- Data Architect

Location- Bangalore, Pan India

Mode- Onsite

Job Type: Full-Time

Overview

We are looking for a highly capable Data Analyst / Data Modeler / Data Architect to support a major enterprise data transformation programme, the Data Integration Hub (DIH).

This role sits within a high-performing Data Architecture & Engineering function and will play a key part in delivering clean, reconciled, and business-ready data into our analytical platforms.

You will work at the heart of the programme, bridging business requirements, data modelling, and engineering delivery.

Key Responsibilities

Analyse complex datasets to understand structures, relationships, and data quality issues

Define source-to-target mappings and detailed transformation logic

Develop and maintain conceptual, logical, and physical data models

Translate requirements into clear pseudo-logic and implementation-ready specifications

Perform data reconciliation and variance analysis between legacy and new platforms

Identify and resolve data issues through structured root cause analysis

Support testing and validation activities during key delivery and go-live phases

Work closely with Data Engineers, Architects, and business stakeholders to ensure delivery of high-quality data

Skills & Experience

Strong experience in data modelling (conceptual, logical, physical)

Proven capability in data analysis and source-to-target mapping

Advanced SQL skills for profiling, validation, and complex queries

Experience defining transformation logic / pseudo-code for data pipelines

Good understanding of data warehousing and ETL/ELT processes

Strong problem-solving and data debugging skills

Experience working in complex, multi-system data environments

Knowledge of PySpark, SparkSQL advantageous to the role

What Were Looking For

A hands-on, detail-oriented data specialist who thrives in complex environments

Someone who can bridge business and engineering with clarity and structure

Strong communicator, comfortable working with distributed teams within Data Architecture & Engineering function and across external functions

Experience in data reconciliation, quality, and governance-driven programmes is highly desirable