Senior Analyst

Senior/Lead Analyst MIS Reporting

Locations: Pune

US Shift: 05:30 PM - 02:30 AM

About the Company

WNS, part of Capgemini, is an Agentic AI-powered intelligent operations and transformation company. With over 700 clients across 10 industries, WNS combines deep domain expertise with advanced AI, analytics, and digital capabilities to help organizations innovate, scale, and stay resilient in a rapidly evolving business environment.

Key Responsibilities:

Reporting & Data Analysis.

• Prepare daily, weekly, monthly, and adhoc reports as per business requirements.
• Analyze trends and highlight deviations, risks, and opportunities.
• Build and maintain performance dashboards using Excel, Power BI, or other BI tools.
• Present insights and recommendations to management to support strategic decision-making.

Data Management: Collect, clean, validate, and consolidate data from multiple sources.

• Ensure accuracy and integrity of data in all reports and systems.
• Maintain master data files and version controls.

Process Automation: Automate recurring reports and workflows using Excel macros, Power Query, Power Automate, or VBA. Identify gaps and implement process improvements to reduce manual effort.

Stakeholder Collaboration: Work with Operations, Sales, Finance, HR, and other teams to understand reporting needs.

• Support leadership with analytical inputs for reviews, planning, and forecasting.
• Provide timely responses to data and reporting queries.

Compliance & Documentation: Maintain documentation for reporting logic, data definitions, and process flows.

• Ensure compliance with organizational data security and confidentiality norms.

Required Skills

• Advanced MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query, Macros).
• Experience with reporting tools: Power BI, Tableau, or equivalent.
• Strong knowledge of SQL (preferred but not mandatory).
• Ability to work with large datasets and data visualization.

Soft Skills

• Strong analytical and problemsolving ability.
• Excellent communication and presentation skills.
• Attention to detail and high accuracy.
• Ability to work under tight deadlines with minimal supervision.

Qualifications

• Bachelors degree in Business, Statistics, Computer Science, Finance, or related field.
• 25 years of experience in MIS, Reporting, or Data Analysis roles (can be adjusted based on level).
• Experience in automation and BI reporting preferred.

Key Competencies

• Datadriven mindset
• Process orientation
• Business acumen
• Collaboration & stakeholder management
• Continuous improvement attitude

If you are interested (or know anyone), please share resume on kaustubh.kande@wns.com