Assistant Manager - Config Ana

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)

Key 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

Graduate