Job Description: Data Validation & Reconciliation Specialist

Role Overview

We are seeking a highly analytical and detail-oriented Data Validation & Reconciliation Analyst with robust hands-on experience in Alteryx, SQL, and Advanced Microsoft Excel. The role focuses on extracting, validating, reconciling, and analysing large-scale transactional and planning datasets, while collaborating closely with technical and functional stakeholders, including overseas clients.
Experience & hand on knowledge in Anaplan & SAP HANA will be an added advantage, but not mandatory.
Shift Timings : 2 PM to 11 PM IST

Key Responsibilities
- Extract and analyse master and transactional data from SAP HANA backend systems using SQL queries.
- Retrieve and validate planning and forecast data from Anaplan models and modules.
- Perform data validation, reconciliation, and comparison between SAP HANA database and Anaplan datasets to ensure data accuracy and integrity.
- Conduct drill-down analysis in Anaplan to understand calculation logic, model behaviour, and data flow.




- Analyse Anaplan formulas and data models to trace and resolve data discrepancies.
- Use Microsoft Excel extensively for data analysis, including advanced formulas, Pivot Tables, lookups (VLOOKUP/XLOOKUP), and comparison techniques.
- Design, build, and maintain automated data validation workflows in Alteryx to process high-volume transactional datasets efficiently.
- Clean, transform, and compare large datasets using Alteryx tools and best practices for workflow optimization.
- Identify, investigate, and resolve data mismatches, inconsistencies, and integrity issues across systems.
- Document validation results, findings, and root-cause analyses clearly and accurately.
- Collaborate with technical, functional, and business teams to resolve data issues and support decision-making.
- Communicate effectively with overseas stakeholders and clients, ensuring clarity and alignment.

Required Skills & Experience
- Strong experie

📌 Data Analyst (India)
🏢 LTM
📍 India