Role description

Role: Data Validation Reconciliation Specialist

Role Overview

We are seeking a highly analytical and detail oriented Data Validation Reconciliation Analyst with strong hands on experience in Alteryx SQL and Advanced Microsoft Excel

The role focuses on extracting validating reconciling and analyzing largescale 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

Shift Timings 2 PM to 11 PM IST

Key Responsibilities

Extract and analyze 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 drilldown analysis in Anaplan to understand calculation logic model behavior and data flow

Analyze Anaplan formulas and data models to trace and resolve data discrepancies

Use Microsoft Excel extensively for data analysis including advanced formulas Pivot Tables lookups VLOOKUPXLOOKUP 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 experience in data validation and reconciliation across enterprise systems

Handson expertise in Alteryx including workflow development for largescale data processing and automation

Strong SQL skills

Solid understanding of Anaplan models modules and formulas including hands on analysis and troubleshooting

Advanced proficiency in Microsoft Excel including complex formulas Pivot Tables data comparisons and analytical techniques

Experience handling large transactional and high volume datasets

Robust analytical troubleshooting and problem solving skills with exceptional attention to detail

Excellent written and verbal communication skills

Preferred Good to Have Skills

Experience working with financial or operational planning systems

Knowledge of data automation and workflow optimization in Alteryx

Basic to intermediate Python experience including

oRunning and modifying existing scripts

oEnhancing scripts based on business or client requirements





oSupporting basic development and maintenance activities

Prior experience working with overseas or global clients

Skills

Mandatory Skills : Data Architecture, MS Excel, MS SQL Server, Python

About LTM
LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltm.com/careers/recruitment-fraud-alert

📌 Senior Software Engineer (Bengaluru)
🏢 LTM
📍 Bengaluru