Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data and create reports for pension systems, ensuring clarity and accuracy.
- Company: Join a leading insurance firm focused on innovative financial solutions.
- Benefits: Enjoy hybrid work options and the chance to develop your skills in a dynamic environment.
- Why this job: Be part of a collaborative team making a real impact in the pensions sector.
- Qualifications: Experience with SQL and knowledge of HR or payroll systems is essential.
- Other info: This is a 6-month contract role with opportunities for professional growth.
The predicted salary is between 36000 - 60000 £ per year.
We are currently hiring for a Systems Data Analyst with Pensions/HR experience to join one of our Insurance clients on a 6 month contract.
Responsibilities:
- Working knowledge of SQL to allow back end data queries, cross table joins and data analysis.
- Strong knowledge of databases structures, administration systems and member/employee data in a financial, HR or payroll related business.
- Work closely with business users to understand the administration system front end and understand how it relates to the back end data.
- Create and maintain system documentation to ensure completeness and clarity of communication to stakeholders.
- Gather data from back end tables, ensuring good understanding of table relationships and shaping to allow accurate analysis against system front end.
- Create comprehensive reports, visualizations, and dashboards to communicate findings to stakeholders.
- Liaise with business analysts and/or other stakeholders as appropriate to ensure that requirements are well defined and understood to achieve project goals.
- Work in a collaborative manner within a high-pressure environment to develop key relationships.
- Pensions (Defined benefit) experience.
System Analyst employer: Lorien
Contact Detail:
Lorien Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land System Analyst
✨Tip Number 1
Familiarise yourself with SQL and database structures before your interview. Brush up on your skills by working on sample queries or projects that involve data analysis, as this will demonstrate your practical knowledge during discussions.
✨Tip Number 2
Understand the specific requirements of the pensions sector, especially defined benefit plans. Research common challenges faced in this area and think about how your experience can help address them, so you can speak confidently about your insights.
✨Tip Number 3
Prepare to discuss your experience in creating reports and visualisations. Have examples ready that showcase your ability to communicate complex data clearly, as this is crucial for the role and will set you apart from other candidates.
✨Tip Number 4
Network with professionals in the pensions and HR fields. Attend relevant webinars or local meetups to build connections and gain insights into industry trends, which can be beneficial when discussing your fit for the role.
We think you need these skills to ace System Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL, databases, and any relevant Pensions or HR knowledge. Use specific examples that demonstrate your skills in data analysis and system documentation.
Craft a Strong Cover Letter: In your cover letter, explain why you are interested in the Systems Data Analyst position. Mention your experience with back-end data queries and how you can contribute to the team. Be sure to connect your skills to the responsibilities listed in the job description.
Showcase Relevant Projects: If you have worked on projects involving data visualisation or dashboard creation, include these in your application. Describe your role and the impact of your work, especially in a high-pressure environment.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a Systems Data Analyst role.
How to prepare for a job interview at Lorien
✨Brush Up on SQL Skills
Make sure you're comfortable with SQL, as you'll need to demonstrate your ability to perform back-end data queries and cross table joins. Practise writing queries that showcase your analytical skills and understanding of database structures.
✨Understand the Pensions Landscape
Familiarise yourself with pensions, particularly defined benefit schemes. Being able to discuss relevant terminology and concepts will show your potential employer that you have a solid grasp of the industry and its challenges.
✨Prepare for Scenario-Based Questions
Expect questions that assess how you would handle real-world scenarios related to data analysis and stakeholder communication. Think of examples from your past experience where you've successfully collaborated with business users or created impactful reports.
✨Showcase Your Documentation Skills
Be ready to discuss how you create and maintain system documentation. Highlight your attention to detail and ability to communicate complex information clearly, as this is crucial for ensuring stakeholders understand the data and its implications.
