Senior Consultant Data & Insights in Liverpool

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

#J-18808-Ljbffr