Senior BI Developer - Hybrid

Oliver James Associates Ltd.; England; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading company in the Lloyd's market is seeking a Senior BI Developer who will be instrumental in transforming data into insights that drive strategic decisions. This role involves developing BI solutions using Power BI, DAX, and SQL, while collaborating closely with various underwriting and finance teams. You will also have the opportunity to mentor junior developers and ensure data integrity within a dynamic insurance environment.

Qualifications

• Proven experience as a BI Developer in the Lloyd's or London Insurance Market.
• Advanced proficiency in Power BI, DAX, and SQL.
• Experience with cloud-based BI platforms is advantageous.

Responsibilities

• Design, build and optimize interactive Power BI dashboards.
• Write efficient DAX measures and develop SQL queries.
• Lead data governance and mentor junior developers.

Skills

Power BI

DAX

SQL

Problem-solving

Stakeholder management

Tools

Azure SQL

MS SQL Server

Azure Data Factory

Synapse Analytics

Job description

Senior BI Developer - Hybrid Working

About the Role

We are seeking a Senior Business Intelligence (BI) Developer to join a leading Lloyd's market syndicate. This is an exciting opportunity to play a pivotal role in transforming data into critical insights that drive business performance and strategic decision-making within a dynamic and fast-paced insurance environment.

You will be responsible for designing, developing, and maintaining end-to-end BI solutions using Power BI, DAX, and SQL, working closely with underwriters, actuaries, finance, and senior stakeholders.

Key Responsibilities

• Design, build and optimize interactive Power BI dashboards and reports tailored to the Lloyd's insurance market.
• Working specifically with underwriting teams to support their BI processes.
• Write efficient DAX measures and calculated columns to support analytical requirements.
• Develop robust SQL queries, stored procedures, and ETL processes to source and transform data.
• Translate complex data requirements into scalable BI solutions.
• Collaborate with business users to gather requirements and deliver meaningful insights.
• Lead data governance and quality initiatives to ensure data integrity and consistency.
• Mentor junior developers and contribute to BI strategy and best practices.

Skills & Experience Required

• Proven experience as a BI Developer, ideally within the Lloyd's or London Insurance Market.
• Advanced proficiency in Power BI, DAX, and SQL.
• Experience working with Underwriting teams.
• Strong understanding of insurance-specific data models including premiums, claims, exposures, and bordereaux.
• Hands-on experience working with data warehouses, data marts, and ETL pipelines.
• Solid knowledge of relational databases (e.g., MS SQL Server, Azure SQL).
• Excellent problem-solving skills and ability to work independently or as part of a team.
• Strong stakeholder management and communication skills.

Desirable

• Experience with cloud-based BI platforms (e.g., Azure Data Factory, Synapse Analytics).
• Familiarity with Lloyd's regulatory reporting and actuarial datasets.
• Exposure to Python or R for advanced analytics.