Lead Associate - Config Ana

at  WTW

DESCRIPTION

Responsibilities:

• Provide technical and pensions support to the Configuration Analysis team
• Receive data from ceding administrator’s system
• Load data into a temporary database
• Analyse data received alongside scheme documentation and map to our target database
• Develop data reconciliations in SQL
• Analyse, map and test interface data
• Liaise with calc analysts to agree benefit tranches and structure
• Configure base scheme and category set ups to match benefit structure of the scheme

QUALIFICATIONS

Education: Graduate

Required skills:

• Experience in UK Pensions Data Analysis (DB or DC, with DB being preferable)
• Advanced SQL skills to link tables for analysis and data updates, must be familiar with joining multiple tables and subqueries/ Sub select statements, rank, Inner Join, Outer Join, Min and Max statements, Generating sequential number, Case statement etc.
• Good written and verbal communication as may be engaging directly with clients (depending on project)

Location: Gurugram Haryana
Shift - UK Shift
Transport will be provide

• Provide technical and pensions support to the Configuration Analysis team
• Receive data from ceding administrator’s system
• Load data into a temporary database
• Analyse data received alongside scheme documentation and map to our target database
• Develop data reconciliations in SQL
• Analyse, map and test interface data
• Liaise with calc analysts to agree benefit tranches and structure
• Configure base scheme and category set ups to match benefit structure of the schem