Senior Consultant Data & Insights

Royal & Sun Alliance Insurance Ltd; Liverpool; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Annual discretionary bonus

Pension contributions up to 11%

Hybrid working

25 days annual leave + bank holidays +

Buy/sell holiday options

Career development and mentoring

Inclusive culture and networks

Share investment options

Job summary

Royal & Sun Alliance Insurance Ltd is seeking a data analytics professional to shape strategic decisions by turning data into concise, visual insights. You will build Power BI dashboards, design semantic models, and automate data pipelines using SQL and Microsoft Fabric.

The role emphasizes data storytelling, governance, and the ability to coach colleagues while partnering with stakeholders across the business. Hybrid working in Liverpool is offered with development opportunities.

Qualifications

• Advanced expertise in Power BI, including data modelling and DAX.
• Strong storytelling to translate data into actionable insights.
• Experience with data governance and data quality practices.
• Ability to coach colleagues and share best practices.

Responsibilities

• Deliver executive-ready insight and reporting for informed decisions.
• Design and maintain scalable Power BI dashboards and semantic models.
• Develop automated data pipelines using SQL and Microsoft Fabric.
• Translate complex data into clear narratives for stakeholders.
• Act as a technical expert, mentor teammates and drive best practices.
• Collaborate with stakeholders to define KPIs and ensure data quality.

Skills

Power BI modelling

Data storytelling

Data governance

Data quality management

Coaching colleagues

Tools

SQL

Microsoft Fabric

Job description

Location: Liverpool
Hybrid working: 3 days per week in the office
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

You will play a key role in turning complex data into meaningful insight that helps Intact make informed business decisions. In your role, you will collaborate with colleagues and stakeholders across the business, bringing together advanced analytics, data storytelling, and technical expertise to deliver impactful outcomes while supporting continuous improvement and high quality decision making.

You’ll make an impact by:

• Delivering executive ready insight and reporting that supports informed decision making across the business.
• Designing and maintaining scalable Power BI dashboards and semantic models that provide consistent and accessible data.
• Developing automated data pipelines using SQL and Microsoft Fabric to improve reporting efficiency and reliability.
• Translating complex data into clear narratives that help stakeholders understand performance and opportunities.
• Acting as a technical expert, sharing knowledge, coaching colleagues, and supporting best practice across analytics and visualisation.
• Collaborating with stakeholders to define KPIs, maintain data quality, and support complex analytical projects.

Your skills and experience:

• Advanced expertise in Power BI, including data modelling, DAX, and dashboard design.
• Capability in SQL for data transformation, optimisation, and reporting solutions.
• Experience using Microsoft Fabric, including pipelines, lakehouse, and warehouse functionality.
• Confidence communicating insight to a range of audiences through clear data storytelling and analysis.
• Knowledge of data governance, data quality management, and building self service, governed data models.
• Ability to coach and support colleagues while managing priorities across multiple activities.

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
• 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