Configuration Analyst - SQL Proficient

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

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 provided