Job 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.

Key Responsibilities

• Design, build, and maintain data pipelines and automated workflows across various internal systems.
• Perform data extraction from multiple source systems (databases, APIs, flat files), ensuring data accuracy and integrity.Manage and optimize SQL databases, including query tuning, stored procedures, and performance monitoring.
• Develop ETL processes to clean, transform, and aggregate large datasets for analytics and reporting
• Build and maintain Power BI dashboards, including data modeling, DAX calculations, and performance optimization.
• Develop VBA-based automation solutions to streamline data processing and reporting tasks.
• Perform data analysis and prepare insights, trend reports, and data validation outputs for stakeholders.Collaborate closely with cross-functional teams (Technology, Actuarial/Engineering teams) to understand business requirements and translate them into technical solutions.
• Ensure strong documentation, version control, and adherence to data governance best practices.

Core Technical Requirements

• Strong hands-on experience with SQL (complex queries, stored procedures, performance tuning) and database administration concepts.
• Experience building and managing ETL pipelines using tools or custom scripts.
• Proficiency in VBA, particularly for automation of recurring data processes.Strong capability in Power BI, including data modeling, DAX, and report optimization.Advanced Excel skills (Power Query, Power Pivot, macros, complex formulas).
• Solid understanding of data structures, data quality checks, and data validation methods.Experience with data extraction from enterprise systems, APIs, and other structured or unstructured sources.
• Knowledge of scripting languages (Python preferred) for data wrangling would be an advantage.

Preferred Qualifications

• Exposure to insurance, financial services, or other data-rich operational environments (nice to have, not mandatory).Experience working in a fast-paced shared services or analytics setup.

Qualifications

Graduate