Senior Consultant Data & Insights

Intact Insurance is recruiting for the role of Senior Consultant Data & Insights. This role turns complex data into executive-ready insight and reporting to support informed business decisions. It combines Power BI, SQL and Microsoft Fabric with data storytelling, stakeholder collaboration and support for best practice.

What you’ll do

• Deliver executive-ready insight and reporting that supports informed decision making.
• 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 by sharing knowledge, coaching colleagues and supporting best practice.
• Collaborate with stakeholders to define KPIs, maintain data quality and support analytical projects.

What they’re looking for

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