At a Glance
- Tasks: Ensure data quality and integrity for a multi-employer pension scheme.
- Company: Join a leading pension trustee with a collaborative and supportive culture.
- Benefits: Up to £37,000 salary, hybrid work, and professional development opportunities.
- Other info: Dynamic role with opportunities for growth and learning in a fast-paced environment.
- Why this job: Make a real difference in the lives of over 80,000 pension members.
- Qualifications: Experience in data entry and pension administration, plus strong Excel and SQL skills.
The predicted salary is between 37000 - 37000 £ per year.
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
- UPM knowledge.
For more information on the role, please visit our website.
Data Integrity Analyst employer: SAUL Trustee Company
Contact Detail:
SAUL Trustee Company Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Integrity Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions and scenarios related to data integrity. We recommend doing mock interviews with friends or using online resources to boost your confidence.
✨Tip Number 3
Showcase your skills! Bring examples of your previous work or projects that demonstrate your data analysis abilities. This will help you stand out and prove you're the right fit for the role.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Data Integrity Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Integrity Analyst role. Highlight your relevant experience in data entry, maintenance, and pension administration. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data integrity and how you can contribute to our team. Keep it concise but impactful – we love a good story!
Show Off Your Skills: Don’t forget to showcase your Excel and SQL skills in your application. Mention specific formulas you've used and any projects where you've demonstrated your data analysis prowess. We’re looking for those who can hit the ground running!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you don’t miss out on any important updates. Plus, it’s super easy!
How to prepare for a job interview at SAUL Trustee Company
✨Know Your Data Inside Out
Make sure you brush up on your data integrity knowledge before the interview. Understand the key concepts related to data quality, especially in the context of pensions. Be ready to discuss how you've handled data inconsistencies in the past and what solutions you've implemented.
✨Excel Skills on Display
Since this role requires advanced Excel skills, be prepared to showcase your proficiency. You might be asked to solve a problem using Excel formulas like VLOOKUP or INDEX. Practise these formulas beforehand so you can demonstrate your expertise confidently.
✨Familiarise Yourself with Regulations
Understanding the Pensions Regulator's guidelines is crucial for this position. Take some time to read up on relevant legislation and be ready to discuss how you would ensure compliance in your work. This shows that you're not just technically skilled but also aware of the regulatory landscape.
✨Showcase Your Team Spirit
This role involves collaboration with various teams, so highlight your teamwork experience during the interview. Share examples of how you've built strong relationships with colleagues or external parties to achieve data quality goals. This will demonstrate your ability to work well within a team environment.