Intact Insurance UK
People & Reporting Insights Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
APPLY NOW!
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
If you meet the core criteria but not every requirement, we’d still love to hear from you. Let’s explore how this role could support your next career step. If you need adjustments during the recruitment process, just let us know we’re here to support you.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills