REF99019U_2026242571 - Data Analyst - Power BI + Advanced Excel - 3 to 4 ye at WNS Global Services

Pune, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

23 Jul, 26

Salary

0.0

Posted On

24 Apr, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Python, Pandas, NumPy, Power BI, DAX, Data Modeling, Advanced Excel, Power Query, Pivot Tables, Data Automation, Data Wrangling, Automation Scripting, VBA, Macros, Data Visualization, Problem-solving

Industry

Business Consulting and Services

Description

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

Responsibilities

Develop and maintain automation scripts using Python and Pandas to streamline data processes and reporting. Build and enhance interactive Power BI dashboards while ensuring data accuracy and quality through advanced Excel techniques.