Pensions Migration Consultant - Data
Posted 6 days ago by Lorien
£520 Per day
Inside
Remote
England, UK
Summary: The Pensions Migration Consultant - Data is a lead-level role focused on the end-to-end implementation of pensions data projects within a specialist team. The consultant will manage the data phase of implementation, ensuring data quality and guiding junior team members. This position requires extensive experience in pensions data, including analysis, cleansing, and transformation of data formats. The role is remote and operates under a 6-month contract inside IR35.
Key Responsibilities:
- Lead and deliver pensions data implementation projects end-to-end
- Receive and analyse pensions data from clients in varied formats
- Use Excel and SQL extensively to query, validate, manipulate, and analyse data
- Identify data gaps, inconsistencies, and quality issues, and resolve them effectively
- Map data from source formats into target system schemas
- Work with data dictionaries and pension system structures
- Own complex or unusual data processes and troubleshoot technical issues
- Act as a subject matter expert within the data team, reviewing and checking others' work.
Key Skills:
- Strong experience in a directly comparable pensions data role
- Proven lead-level experience delivering end-to-end data implementations or migrations
- Advanced Excel skills (pivot tables, lookups, formulas, data validation; macros desirable)
- Strong SQL skills for querying and analysing data
- Solid understanding of databases and data structures
- Hands-on experience with data mapping, data manipulation, and data validation
- Strong pensions knowledge, including DB, DC, CARE and annuities
- Experience working with pension administration systems and member records
Salary (Rate): £520 per day
City: undetermined
Country: UK
Working Arrangements: remote
IR35 Status: inside IR35
Seniority Level: Senior
Industry: Other
- Pensions Migration Consultant - Data
- Remote
- 6 month contract
- Inside of IR35
- £520 per day
We're looking for an experienced Implementation Consultant (Data) to join a specialist pensions data team, working on the delivery of complex client implementation and transition projects.
This role sits within a wider pensions department made up of multiple specialist teams. Your focus will be on the data phase of implementation, taking ownership of pensions data from receipt through to successful migration and system configuration.
You'll work with pensions data in multiple formats, analysing, cleansing, mapping, and transforming it into formats required by internal pension systems. Importantly, this is a lead-level role, with responsibility for guiding delivery, ensuring data quality, and supporting junior team members.
What You'll Be Doing- Lead and deliver pensions data implementation projects end-to-end
- Receive and analyse pensions data from clients in varied formats
- Use Excel and SQL extensively to query, validate, manipulate, and analyse data
- Identify data gaps, inconsistencies, and quality issues, and resolve them effectively
- Map data from source formats into target system schemas
- Work with data dictionaries and pension system structures
- Own complex or unusual data processes and troubleshoot technical issues
- Act as a subject matter expert within the data team, reviewing and checking others' work.
- Strong experience in a directly comparable pensions data role
- Proven lead-level experience delivering end-to-end data implementations or migrations
- Advanced Excel skills (pivot tables, lookups, formulas, data validation; macros desirable)
- Strong SQL skills for querying and analysing data
- Solid understanding of databases and data structures
- Hands-on experience with data mapping, data manipulation, and data validation
- Strong pensions knowledge, including DB, DC, CARE and annuities
- Experience working with pension administration systems and member records
If you are available and interested, please apply today!
Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.
