Pensions SME with Data Migration experience and strong SQL required by a large Financial Services firm. You will need to have prior experience of migrating and mapping pensions admin data for Defined Benefit (DB) occupational schemes from a major third-party administration system to another. You will need to be able to demonstrate awareness of how to calculate a DB pension with experience of mapping DB data and knowing what to look for in deferred DB data.
Knowledge of Defined Contribution schemes is nice to have, with an undersanding of lifestyling and switching.
In addition you should have a passion for technical detail and problem solving with excellent client facing skills. You'll be working in a fast paced environment with multiple concurrent projects. You will need strong analysis skills to ensure client changes and installations are right first time. You will need excellent understanding of database table design and dependencies with significant experience of data comparison and experience of direct database use with strong SQL. Clear and concise communication skills are essential.
The role will involve:
Onboarding new pension clients across multiple product lines.
Analysing scheme benefit structures and incoming client data.
Data Interface analysis and configuration.
Data migration analysis, mapping and validation.
Scheme configuration within the administration systems.
Working closely with new clients as well as the Installs and Data Migration teams and other owners in non technology teams involved in the business change to ensure that the implementation of new clients and client changes achieve high quality outcomes within the administration function post implementation.
This is a 6 month initial contract paying circa £575/day, inside IR35 with the ability to work fully remote.
","Position":"Pensions SME - Defined Benefit Data Migration","RecruiterName":"Lexstra Plc","ShortDescription":"Pensions SME with Data Migration experience and strong SQL required by a large Financial Services firm. You will need to have prior experience of migrating and mapping pensions admin data for Defined Benefit (DB) occupational schemes from a major third-party administration system to another. You will need to be able to demonstrate awareness of how to calculate a DB pension with experience of mapping DB data and knowing what to look for in deferred DB data. Knowledge of Defined Contribution schemes is nice to have, with an undersanding of lifestyling and switching. In addition you should have a passion for technical detail and problem solving with excellent client facing skills. You'll be working in a fast paced environment with multiple concurrent projects. You will need strong analysis skills to ensure client changes and installations are right first time. You will need excellent understanding of database table design and dependencies with significant experience of data comparison and experience of direct database use with strong SQL. Clear and concise communication skills are essential. The role will involve: Onboarding new pension clients across multiple product lines. Analysing scheme benefit structures and incoming client data. Data Interface analysis and configuration. Data migration analysis, mapping and validation. Scheme configuration within the administration systems. Working closely with new clients as well as the Installs and Data Migration teams and other owners","Start":"","Telephone":"0208 255 6100"},{"Country":"GBR","Industries":["01","02"],"JobType":"Contract","Location":{"Country":"GBR","ID":"28195,0,3502,147,80,1,5","Latitude":51.5122184753418,"Longitude":-0.064999997615814209,"Text":"London"},"PermanentID":"aJdJH","Salary":"£500 - 600 per day + Fully Remote - Inside IR35","ID":"D901347D233B2719DBC086C7B7960005","AccountID":"F1C7EB7F8168D80074B95D24F40952AF","Permalink":"http://www.jobserve.com/aJdJH?utm_source=LIVE&utm_medium=Live&utm_campaign=Web-API-LexstraPLC","AdvertiserName":"Lexstra Plc","AdvertiserReference":"JSMS/DA/PEN2","ContactName":"Mike Shorricks","DatePosted":"2024-09-12T06:55:33Z","LastModifiedUTC":"2024-09-12T06:55:42Z","Duration":"","Email":"Mike.Shorricks.D7C79.C5F640E@apps.jobserve.com","Expired":false,"Fax":"","HtmlDescription":"Pensions Data Analyst/Configuration Analyst with strong knowledge of Pensions and related data required by a large Financial Services firm. You will need to have prior experience of migrating pensions admin data for Defined Benefit, Defined Contribution and hybrid occupational pension shcemes from one third party administrator to another. In addition you should have a passion for technical detail and problem solving with excellent client facing skills. You'll be working in a fast paced environment with multiple concurrent projects. You will need strong analysis skills to ensure client changes and installations are right first time. You will need excellent understanding of database table design and dependencies with significant experience of data comparison and experience of direct database use (strong SQL is highly desirable). Clear and concise communication skills are essential.
The successful hire will be responsible for:
Onboarding new pension clients across multiple product lines.
Analysing scheme benefit structures and incoming client data.
Data Interface analysis and configuration.
Data migration analysis, mapping and validation.
Scheme configuration within our administration systems.
Working under the direction of the Lead Configuration Analyst, the Configuration Analyst will work closely with new clients as well as the Installs and Data Migration teams and other owners in non technology teams involved in the business change to ensure that the implementation of new clients and client changes achieve high quality outcomes within the administration function post implementation.
Pension Data Analyst/Configuration Analyst with SQL needed urgently for role involving pension administration data migration from a third party administration system. Proven experience of dealing with Defined Benefit, hybrid and Defined Contribution occupational pension schemes - ESSENTIAL Ideal for a candidate with strong analysis skills and proven pensions industry experience, who enjoys working with systems software and understands database table design and dependencies. 6 month contract, likely to become rolling. Remote working with requirement to attend the Redhill office 1/2 days per month. Full job spec' available.
","Position":"Data Migration Analyst - Occupational pensions - SQL","RecruiterName":"Lexstra Plc","ShortDescription":"Pension Data Analyst/Configuration Analyst with SQL needed urgently for role involving pension administration data migration from a third party administration system. Proven experience of dealing with Defined Benefit, hybrid and Defined Contribution occupational pension schemes - ESSENTIAL Ideal for a candidate with strong analysis skills and proven pensions industry experience, who enjoys working with systems software and understands database table design and dependencies. 6 month contract, likely to become rolling. Remote working with requirement to attend the Redhill office 1/2 days per month. Full job spec' available.","Start":"","Telephone":"0208 255 6100"}],"Duration":"00:00:00.1250000","JobCount":3,"PageCount":1,"PageNo":1,"PageSize":20,"RoleSuggestions":[null],"Search":{"Locations":[{"Country":"GBR"}],"AccountGroupIDs":["F1C7EB7F8168D80074B95D24F40952AF"],"JobTypes":["Any"],"ExcludeUnknownSalaries":false,"JobIDsOnly":false,"MaxDistance":25.0,"PageSize":20,"SortOrder":"OVERALL_SCORE_DESC"},"SkillsSuggestions":[null],"Started":"2024-09-19T14:19:09.5589724Z","ThisPageSize":3}