Data Architect

Job Title- Data Architect\nLocation- Bangalore, Pan India\nMode- Onsite\nJob Type: Full-Time\nOverview\nWe 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).\nThis 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.\nYou will work at the heart of the programme, bridging business requirements, data modelling, and engineering delivery.\n\nKey Responsibilities\n· Analyse complex datasets to understand structures, relationships, and data quality issues\n· Define source-to-target mappings and detailed transformation logic\n· Develop and maintain conceptual, logical, and physical data models\n· Translate requirements into clear pseudo-logic and implementation-ready specifications\n· Perform data reconciliation and variance analysis between legacy and new platforms\n· Identify and resolve data issues through structured root cause analysis\n· Support testing and validation activities during key delivery and go-live phases\n· Work closely with Data Engineers, Architects, and business stakeholders to ensure delivery of high-quality data\n\nSkills & Experience\n· Strong experience in data modelling (conceptual, logical, physical)\n· Proven capability in data analysis and source-to-target mapping\n· Advanced SQL skills for profiling, validation, and complex queries\n· Experience defining transformation logic / pseudo-code for data pipelines\n· Good understanding of data warehousing and ETL/ELT processes\n· Strong problem-solving and data debugging skills\n· Experience working in complex, multi-system data environments\n· Knowledge of PySpark, SparkSQL advantageous to the role\n\nWhat We’re Looking For\n· A hands-on, detail-oriented data specialist who thrives in complex environments\n· Someone who can bridge business and engineering with clarity and structure\n· Strong communicator, comfortable working with distributed teams within Data Architecture & Engineering function and across external functions\n· Experience in data reconciliation, quality, and governance-driven programmes is highly desirable