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 We’re 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