Data Analyst

LTM

Hyderabad, Pune District, Bengaluru

Hybrid

INR 900,000 - 1,300,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

LTM in Hyderabad, India seeks a Data Validation Reconciliation Analyst with hands-on Alteryx, SQL and advanced Excel for large-scale datasets. You will extract, validate and reconcile transactional and planning data while collaborating with overseas clients.

You will analyze Anaplan models, SAP HANA data, and design automated validation workflows in Alteryx to ensure data accuracy and integrity, documenting findings and root causes for stakeholders.

Qualifications

  • Hands-on data validation and reconciliation across enterprise systems.
  • Proficient with Alteryx workflow development for large data processing.
  • Strong SQL skills and data analysis capabilities.
  • Knowledge of Anaplan models, modules and formulas.
  • Advanced Microsoft Excel skills including Pivot Tables and lookups.
  • ,

Responsibilities

  • Extract and analyze data from SAP HANA backend systems using SQL queries, validating accuracy.

Skills

Alteryx
SQL
Anaplan
SAP HANA
Excel advanced
Data validation
Data reconciliation
Stakeholder comms

Tools

Alteryx
SAP HANA
Anaplan
Excel
Python

Job description

Role & responsibilities

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
  • Hand son 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
  • Strong 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 Running and modifying existing scripts
  • Basic to intermediate Python experience including Enhancing scripts based on business or client requirements
  • Basic to intermediate Python experience including Supporting basic development and maintenance activities
  • Prior experience working with overseas or global clients
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Validation & Reconciliation Specialist
Data Validation & Reconciliation Specialist

Elabs Infotech • Hyderabad, Chennai, Bengaluru

Hybrid
INR 600,000 - 900,000
Alteryx Data Analyst
Alteryx Data Analyst

EXL • Maharashtra

On-site
INR 1,200,000 - 1,800,000
Senior Alteryx Developer
Senior Alteryx Developer

Vivid Edge Corp • Hyderabad, Bengaluru

Hybrid
INR 1,500,000 - 2,100,000
Alteryx Developer | Technical Reconciliation Developer
Alteryx Developer | Technical Reconciliation Developer

Wipro Ltd. • Hyderabad, Chennai District, Bengaluru

Remote
INR 800,000 - 1,200,000
Alteryx Professional
Alteryx Professional

Infosys • Bengaluru

On-site
INR 900,000 - 1,300,000
Data Analyst with Alteryx
Data Analyst with Alteryx

PwC • Kolkata, Hyderabad, Bengaluru

On-site
INR 900,000 - 1,300,000
Alteryx
Alteryx

Chandigarh News • Chandigarh, Hyderabad, Bengaluru

Hybrid
INR 500,000 - 900,000
Associate Manager - Alteryx
Associate Manager - Alteryx

Annalect, Omnicom Media Group India Private Limited. • Gurugram District

Hybrid
INR 1,500,000 - 2,100,000
Alteryx
Alteryx

Infosys • Dadri, Chennai District, Mumbai

Hybrid
INR 600,000 - 900,000
Alteryx
Alteryx

Infosys • Kolkata District, Ahmedabad District, Bengaluru

Hybrid
INR 600,000 - 1,200,000