Data Integrity Analyst
Location: Hybrid/London EC2R 7AF, with up to 3 days working from home after an initial period of training.
Salary: Up to £37,000 a year (depending on relevant knowledge, skills and experience).
Type of contract: Permanent, full time. 35 hours per week, Monday to Friday.
We are the trustee and administrator of a multi-employer hybrid pension scheme and a Master Trust, looking after the pensions of more than 80,000 members.
Responsibilities
- Understand and operate within the team processes, following project plans and working collaboratively to meet project objectives.
- Operate to a standard that meets the Pensions Regulator Recordkeeping Guidance.
- Work with the Operations team to ensure data is fit for purpose.
- Build strong relationships with internal teams and external parties, including Scheme employers, to facilitate data quality goals.
- Agree on the extent of data cleanses and timeframes required.
- Amend incorrect data and identify and resolve gaps in data.
- Correct data fields where insufficient or incorrect historical separation or tranche divisions have occurred.
- Align Scheme data with data held by other stakeholders and ensure data is current.
- Carry out initial analysis to assess data quality.
- Pro‑actively investigate data inconsistencies and develop potential solutions.
- Load data in bulk to ensure member data is complete and up to date.
- Undertake analysis to determine data accuracy and currency.
- Complete regular data analysis reports to maintain data quality, and operate within the Pension Regulator's validation procedure.
Qualifications
- At least two years of data entry, data amendment and data maintenance experience.
- At least two years of pension and data administration experience.
- Understanding of relevant legislation, regulations, and The Pension Regulator.
- Experience assessing and responding to non‑routine work situations.
- Experience using Excel formulas (DATE(), INDEX(), VLOOKUP(), HLOOKUP(), MATCH() and more advanced formulas).
- Experience using SQL Server Studio.
- Ability to develop solutions to non‑standard problems and willingness to experiment and find efficient solutions.
- Advanced level in data analysis and calculations in spreadsheets.
- Computer literacy (strong experience of using MS Office, Excel and SharePoint).
- Customer‑focused, able to work well in a team, self‑motivated.
- Strong written and oral communication skills, attention to detail.
Desirable Experience
For more information on the role, please visit our website.
#J-18808-Ljbffr