Automation Specialist - Data Analysis and Reporting

REF99019U_2026242571 - Data Analyst - Power BI + Advanced Excel - 3 to 4 years Exp

Company Description

WNS, part of Capgemini, is an Agentic AI-powered leader in intelligent operations and transformation, serving more than 700 clients across 10 industries, including Banking and Financial Services, Healthcare, Insurance, Shipping and Logistics, and Travel and Hospitality. We bring together deep domain excellence – WNS’ core differentiator – with AI-powered platforms and analytics to help businesses innovate, scale, adapt and build resilience in a world defined by disruption.Our purpose is clear: to enable lasting business value by designing intelligent, human-led solutions that deliver sustainable outcomes and a differentiated impact. With three global headquarters across four continents, operations in 13 countries, 65 delivery centers and more than 66,000 employees, WNS combines scale, expertise and execution to create meaningful, measurable impact.

Job Description

Job Description – Automation Specialist (Python, Power BI, Advanced Excel)Role OverviewWe are looking for an Automation Specialist with strong experience in Python (Pandas), MS Power BI, and Advanced Excel to support data automation, reporting, and process optimization. The ideal candidate should have hands-on experience in building automated workflows, transforming datasets, and developing interactive dashboards.Key Responsibilities• Develop and maintain automation scripts using Python, especially leveraging Pandas for data cleaning, transformation, and analysis.• Build and enhance Power BI dashboards, ensuring accurate data modeling, DAX calculations, and visualizations.• Use Advanced Excel (Power Query, Pivot Tables, excel advance formulas ) for data analysis and reporting.• Design and implement automated solutions to reduce manual effort in reporting and operations.• Collaborate with business teams to gather requirements and translate them into scalable automation solutions.• Troubleshoot, optimize, and refine existing automation processes.• Ensure data accuracy, quality, and timely delivery of reports/dashboards.• Manage scheduled automation pipelines and monitor performance.

Qualifications

Required Skills• Python Expertiseo Strong in Pandas, NumPy, data manipulation, data wrangling, and automation scripting.• Power BIo Ability to create dashboards, data models, DAX measures, and KPIs.o Experience with working on power BI DAX calculations, and visualizations.• Advanced Excelo Pivot Tables, Power Query, advanced formulas (Index/Match, XLOOKUP, SUMIFS, etc.).o VBA/Macros experience is an added advantage.• General Skillso Strong analytical and problem-solving abilities.o Good written and verbal communication skills.Preferred Qualifications• Bachelor’s degree• 2 – 6 years of experience in data automation/reporting roles.• Ready to work with night shift

Experience Level

Entry Level