Deputy Manager - Data Engineering at WNS Global Services

Gurgaon, haryana, India -

Full Time

Start Date

Immediate

Expiry Date

24 Aug, 26

Salary

0.0

Posted On

26 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, ETL Pipelines, VBA, Power BI, DAX, Advanced Excel, Data Modeling, Python, Data Analysis, Database Administration, Power Query, Power Pivot, Data Governance, API Data Extraction, Stored Procedures, Query Tuning

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

Responsibilities

Design and maintain automated data pipelines and ETL processes to extract and transform data from various sources. Develop Power BI dashboards and VBA automation solutions to provide actionable insights for stakeholders.