Senior Data & Insights Consultant: Power BI & SQL

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

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.