Senior Consultant Data & Insights

Intact Insurance; Liverpool; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Annual discretionary bonus

Up to 11% pension contributions

Hybrid working + flexible hours

25 days annual leave + bank holidays +

Career development and mentoring

Inclusive culture + employee networks

Share investment options

Job summary

Intact Insurance in Liverpool is seeking a data analytics professional to turn complex data into actionable insights. You will design and maintain Power BI dashboards and semantic models, and build automated data pipelines using SQL and Microsoft Fabric to improve reporting efficiency.

You will translate findings into clear narratives for senior stakeholders, coach colleagues, and support best practices in analytics and governance across the team.

Qualifications

• Advanced Power BI data modelling, DAX, and dashboards.
• SQL for data transformation, optimisation, and reporting.
• Experience with Microsoft Fabric, pipelines, lakehouse, warehouse.
• Clear data storytelling to diverse audiences.
• Knowledge of data governance and data quality.
• Ability to coach colleagues and manage priorities.

Responsibilities

• Deliver executive-ready insights and reporting.
• Design and maintain scalable Power BI dashboards and semantic models.
• Develop automated data pipelines using SQL and Fabric.
• Translate data into clear narratives for stakeholders.
• Collaborate with stakeholders to define KPIs and ensure data quality.

Skills

Power BI

SQL

Microsoft Fabric

Data storytelling

Data governance

Self-service BI

Coaching

Tools

Microsoft Fabric

DAX

Job description

Location: LiverpoolHybrid working: 3 days per week in the officeIntact 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