MI and Reporting Developer

Serving our customers, communities, and planet a little better every day.

We’re looking for a MI and Reporting Developer to join our Insurance Money and Services team.

Salary – from £43,680 + annual bonus & benefits

Work Level – 2

Location – Permanent

Office Attendance – Our roles are hybrid; however, you should be able to travel to our Glasgow/Edinburgh/Newcastle office, 2 days per week for this position.

Closing Date – Applications close 28/02/2026 at 5pm

• Develop, enhance, and maintain MI and reporting solutions using Microsoft Fabric, Power BI, and other modern data tools.
• Work closely with product teams to understand business needs and translate them into meaningful, actionable insights.
• Support the redevelopment of existing reporting and data processes as we transition to a new Microsoft Fabric environment.
• Collaborate with data engineering and analytics teams to ensure data quality, accuracy, and consistency across reporting outputs.
• Engage with senior stakeholders to present insights, gather requirements, and influence decision making.
• Contribute to shaping new standards, processes, and ways of working within a growing and evolving data function.

• Proven experience developing MI and reporting solutions, including data modelling, DAX, and visualisation best practices.
• Strong SQL skills with the ability to query, transform, and optimise data across large and complex datasets.
• Exposure to Microsoft Fabric or modern cloud‑based data platforms (e.g., Azure Data Factory, Data Lake, Synapse, or similar).

• Experience working with Microsoft Fabric components such as Lake houses, Dataflows Gen2, Pipelines, or Notebook based development.
• Knowledge of Azure services including Azure Data Lake, Azure SQL, Synapse, or Azure Dev Ops for CI/CD.
• Familiarity with Python or other scripting languages for data transformation or automation.
• Understanding of data governance, data quality frameworks, and best practice approaches to metadata and documentation.

• Prepare for your retirement with our colleague pension scheme.
• Private Medical Insurance (WL2+) and virtual GP Service you and your family 365 days a year.
• Critical Illness Insurance.
• Performance‑related annual bonus.
• Indulge in a generous holiday allowance with a minimum of 7.2 weeks, with the opportunity to buy more.
• Benefit from our Colleague Clubcard, enjoy a 10% discount that increase to 15% every payday (worth up to 2K). As an added perk, we’ll give you a second card to share with someone else.
• Benefit from our family‑oriented initiatives, encompassing enhanced maternity leave pay, a shared parental leave policy, and a generous 8‑week paid paternity leave.
• A place to get on – take advantage of our ongoing learning opportunities and award‑winning training, to help you achieve the job and career you want.
• Take part in our Buy as You Earn and Save as Your Earn share schemes.

We want all our colleagues to always feel welcome and be themselves. We’re committed to building a more inclusive workplace and celebrating everything that makes colleagues unique, and value the richness and diversity this brings to our business. A more diverse business helps us deliver on our purpose to serve our customers, communities, and planet a little better every day.

We also know the importance of balancing work with life’s other commitments. Please talk to us at interview about the flexibility you need, as we’re committed to exploring part time and flexible working opportunities, at every level of the organisation.

Interviews are expected to be held from 09/03/2026.

Seeing your impact all around you: there's no better feeling. Lucky for us, we get to feel it all the time. Because whatever our role, we're helping our colleagues and serving our customers, communities and planet a little better every day.

We deal in the personal – from pet insurance for your best friend, and home insurance for peace of mind, to motor insurance for your dream car or travel money for that trip you’ve worked hard for.

Everything we do is about…