Data Analyst

Role : Data Analyst Experience : 4-8 years Notice Period: Immediate to 15 days Location : PAN India Shift timings : 2-11 PM shift Key Skills: Advanced MS Excel/Data Validation/Data Analytics/Alteryx/SQL/Python 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 experience in data validation and reconciliation across enterprise systems. Hands-on expertise in Alteryx, including workflow development for large-scale 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.