DE&A - Core - Advanced Visualization & Cloud Reporting - Power BI

ROLE DESCRIPTION

Purpose

We are seeking a skilled and detail-oriented Power BI Fabric Developer to join our Data & MI team. The ideal candidate will be responsible for designing, developing, and maintaining robust data models and visualizations using Microsoft Fabric , Power BI , and related Azure services. You will work closely with analysts and stakeholders to transform raw data into actionable insights that drive business decisions.

Specific Responsibilities

• Design and develop scalable data models using Microsoft Fabric and Power BI.
• Build and maintain Power BI reports, dashboards, and datasets. Integrating data from various sources including Synapse, Dataverse, and SQL Server.
• Optimize performance of Power BI reports and datasets.
• Collaborate with business users and analysts to gather requirements and deliver tailored BI solutions.
• Ensure data governance, security, and compliance best practices are followed.
• Pro-actively stay updated with the latest features and updates in Microsoft Fabric and Power BI.
• Development of Paginated Power BI reports.
• MS SQL Server development.
• Define data structures, flows and transformations to enable the accurate delivery of MI for the business.
• Document all work and ensure that any solution delivered can be supported across the team.
Systems Analysis and Design activities.

Specific Skills & Experience

• Insurance experience.
• Proven experience with Power BI and Microsoft Fabric.
• Strong understanding of DAX, Power Query (M), and data modelling principles.
• Excellent problem-solving and strong communication skills.
• Strong knowledge of BI industry best practices.
• Strong demonstrable PBI Visualization skills.
• Ability to produce comprehensive technical and analytical documentation.
• Strong MS SQL Server TSQL development.
• Source Control - Team Foundation Server or GIT experience.
Data warehouse design and implementation using the Kimball methodology (SSAS Tabular).

Desirable

• Azure Synapse.
• MS SQL Server SSIS.
• Azure DevOps.
• Microsoft Power Apps development.
• Exposure to new Fabric ecosystem (Dataflows, Notebooks, etc).
• Python.
• Experience with Azure Synapse, Data Factory, Data Lake.
• Familiarity with Git integration, deployment pipelines, and CI/CD practices.
Flexibility and a willingness to get involved in many tasks and technologies.

Lancashire Values

• Leadership, exhibiting passion and commitment in all aspects of Lancashire life and inspiring others to do the same, we are
• Aspirational, aspiring to deliver a superior service for our clients, ourselves and our business partners, we are
• Nimble in our decisions, actions and business processes, we are
• Collaborative, valuing teamwork and a diversity of skills and experience and sharing in our success, and we are
• Straightforward in conducting our business in an accountable, open, honest and sustainable way.