At a Glance
- Tasks: Transform complex people data into clear insights for better decision-making.
- Company: Join Intact Insurance, a forward-thinking company reshaping the insurance landscape.
- Benefits: Enjoy flexible hours, hybrid working, and generous annual leave.
- Other info: Be part of an inclusive culture that values diversity and personal growth.
- Why this job: Make a real impact in a role that drives evidence-based decisions.
- Qualifications: Experience in Power BI, SQL, and strong analytical skills required.
The predicted salary is between 40000 - 50000 £ per year.
Intact Insurance is the new name for RSA in the UK, Ireland, and across Europe. It’s a new name and a new way to do business. Backed by global expertise and a commitment to service that feels different, we’re focused on making insurance simpler, faster, and more responsive.
Shape the future
We’re leading a transformation in insurance helping people, businesses and society prosper in good times and be resilient in bad times. When you join us, you’re not just taking a job, you’re stepping into a career where you can make a real difference.
Grow with us
We’re customer-driven, community-focused, and committed to helping our people grow. Whether you’re early in your journey or bringing years of experience, we’ll support you with the tools, flexibility, and opportunities to thrive.
Win as a Team
In this role, you will sit at the heart of the people analytics agenda at Intact Insurance UK, turning complex people data into clear insights that shape better decisions and stronger performance. Your work will help leaders understand what is happening across the business and why, supporting a culture of evidence-based decision making and helping the organisation focus on the areas that matter most to colleagues and customers. You will be based in Liverpool on a hybrid basis.
You’ll make an impact by:
- Designing and building intuitive self-service dashboards that enable stakeholders to easily access, understand and act on people data and trends.
- Producing high quality insight packs that combine accurate people data with meaningful analysis and commentary to support senior decision making.
- Driving improvements in automated reporting and insight generation, strengthening the people data structure and applying best practice techniques.
- Applying a deep understanding of people data structures and hierarchies to identify anomalies, risks and considerations, and to protect data integrity.
- Partnering with stakeholders across UK&I to provide clear oversight of key people metrics, including culture, capability and priority workforce themes.
Your skills and experience:
- End-to-end delivery of production Power BI reporting, from data preparation and modelling through to build, release, and ongoing optimisation.
- Advanced DAX and data modelling capability, writing clean, maintainable measures that follow best practice and support scalable semantic models.
- Strong visual design & UX skills, producing intuitive, executive-ready dashboards with clear storytelling and usability.
- Microsoft Fabric experience across ETL components (dataflows, pipelines, lakehouses, warehouses) and building Power BI reports on Fabric datasets.
- Extensive hands-on SQL expertise, including complex joins, transformations, and performance-aware querying using clean, maintainable code.
- Strong analytical and communication skills—able to interrogate complex datasets and translate insights into clear narratives for senior stakeholders.
- Sound judgement with strong data governance and data protection awareness; advanced Excel skills for validation and rapid analysis.
Why you'll love it here:
Being part of our team means you’ll have the support and freedom to bring your best self to work each day. As a permanent member, here’s what you can look forward to:
- Annual discretionary bonus
- Up to 11% pension contributions
- Hybrid working + flexible hours
- 25 days annual leave + bank holidays + buy/sell options
- Health & wellbeing + virtual GP
- Career development and mentoring
- Inclusive culture + employee networks
- Share investment options
Our DEI commitment
We celebrate individuality and believe our differences make us stronger. We’re proud to foster a culture where everyone feels respected, valued, and empowered to thrive.
As an Equal Opportunity and Disability Confident Employer, we ensure fair consideration for all applicants and offer interviews to all disabled candidates who meet the essential criteria. We understand that everyone’s circumstances are different and are happy to explore flexible working options such as reduced hours or job shares to support work–life balance.
People & Reporting Insights Analyst in Liverpool employer: Intact Insurance (previously RSA)
At Intact Insurance, we are not just offering a job; we are providing a meaningful career where you can truly make a difference. Located in Liverpool, our hybrid working model promotes flexibility and work-life balance, while our commitment to employee growth is evident through comprehensive development opportunities and a supportive culture. With competitive benefits including an annual bonus, generous pension contributions, and a focus on diversity and inclusion, joining our team means being part of a forward-thinking organisation that values your contributions and empowers you to thrive.
Contact Details:
Intact Insurance (previously RSA) Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land People & Reporting Insights Analyst in Liverpool
✨Dive Into Industry Networking Events
Get your foot in the door by attending insurance industry events and conferences. Not only will you learn about the latest trends, but you'll also meet potential employers and industry peers. Check out local chapters of professional bodies like the Chartered Insurance Institute for valuable meetups.
✨Use LinkedIn to Your Advantage
Don’t underestimate the power of LinkedIn in the insurance world. Engage with industry content, join relevant groups, and connect with professionals at companies you admire (like Intact Insurance (previously RSA)). A thoughtful message explaining your interest can really make a difference!
✨Look Out for Graduate Schemes
Many firms in insurance have structured graduate programmes. Keep an eye on application windows and utilise your university's career services for insider tips. These schemes are designed to develop talent and often lead to permanent roles after your initial training.
✨Leverage Your Current Connections
Got friends or family in the industry? Now’s the time to reach out! Personal referrals can give you a head start, so let them know you're on the lookout for full-time opportunities at places like Intact Insurance (previously RSA). Don’t shy away from asking for a coffee chat; you never know what doors it might open!
We think you need these skills to ace People & Reporting Insights Analyst in Liverpool
Some tips for your application 🫡
Highlight Your Analytical Skills:In insurance, we love a candidate who can crunch numbers and analyse data effectively. When crafting your CV, make sure to showcase any relevant coursework or experiences that highlight your analytical abilities, especially if you’ve tackled risk assessment or financial modelling.
Showcase Industry Knowledge:Don’t be shy about your knowledge of the insurance sector! We want to see that you've done your homework on current trends, regulations, and challenges in the industry. Mention any relevant projects or studies you’ve completed that demonstrate your understanding of the field in your cover letter.
Craft a Compelling Cover Letter:Your cover letter should tell us why you’re passionate about insurance. Share any personal experiences or what drew you into this profession. We’re looking for enthusiasm and a clear motivation for why you want to be part of our team at Intact Insurance (previously RSA).
Tailor Your CV for the Role:Don't just send a generic CV! Focus on tailoring it specifically for the insurance role at Intact Insurance (previously RSA). Highlight relevant skills such as risk management, customer service experience, or any certifications you've earned in the industry to make your application stand out.
How to prepare for a job interview at Intact Insurance (previously RSA)
✨Know Your Numbers: Insurance Fundamentals
Brush up on your understanding of key insurance concepts, like underwriting principles and risk assessment. Expect the interviewer at Intact Insurance (previously RSA) to throw some technical questions your way, so be ready to demonstrate your grasp of these essentials.
✨Showcase Your Analytical Side
In the insurance world, it's all about data. Prepare to discuss any analytical tools or methodologies you've used in past experiences. If you have a portfolio of projects where you've tackled complex data, bring that along to impress the team!
✨Prepare for Behavioural Questions
As a full-timer at Intact Insurance (previously RSA), they'll want to know how you handle real-life scenarios, not just theory. Think about challenges you've faced in teamwork or customer service, and how those experiences can relate to a career in insurance.
✨Know the Company Culture Inside Out
Understanding Intact Insurance (previously RSA)'s values and workplace culture is essential. Don’t just memorise their mission statement; think about how your personal values align with theirs. This will show your genuine interest in being part of their team long-term.