Senior BI Developer - Hybrid

Oliver James Associates Ltd.; United Kingdom; Hybrid; GBP 55,000 - 85,000; Full time

Job summary

A leading Lloyd's market syndicate is seeking a Senior BI Developer to transform data into critical insights. This pivotal role involves designing and maintaining BI solutions using Power BI, DAX, and SQL, working closely with various stakeholders in a dynamic environment.

Qualifications

• Proven experience in BI development, particularly in the Lloyd's or London Insurance Market.
• Advanced proficiency in Power BI, DAX, and SQL.
• Strong insurance-specific data modeling knowledge.

Responsibilities

• Design and develop end-to-end BI solutions for the Lloyd's insurance market.
• Collaborate with underwriting teams and transform complex data into scalable solutions.
• Lead data governance initiatives to ensure data integrity.

Skills

Business Intelligence

Power BI

DAX

SQL

Problem-solving

Stakeholder Management

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.