Senior Data Analyst

We are recruiting for a Senior Data Analyst on behalf of an award‑winning Lloyd's Syndicate.

The successful candidate must have experience working in a Lloyd's syndicate, managing agent, London Market broker or specialty (re) insurer.

You will help the team through its shift from platform delivery toward value‑added analytics and commercial insight. They will support the Data Analytics Manager by applying and role‑modeling technical standards, contributing to complex analysis, and introducing new techniques including the practical application of AI tools within the analytics workflow.

• Act as the senior analytics business partner to one or more underwriting classes, proactively identifying where analytics can improve pricing, portfolio steering, renewal decisions and exposure management.
• Translate open‑ended commercial questions into well‑scoped analyses and dashboard requirements, and collaborate with the wider business to identify opportunities for automation and operational efficiency gains.
• Identify and apply practical AI tooling within the analytics workflow, including LLMs, agentic tools and code‑generation assistants, with a pragmatic view on where they add genuine value.
• Embed the team's development lifecycle for BI and analytics assets, including robust source‑control practices for Power BI content (PBIP / TMDL format, Git‑backed repositories, feature branches, pull requests and meaningful commit history), and contribute to workspace governance across Dev / Test / Prod environments.
• Coach analysts and BI developers on SQL, DAX, data modelling, visual design and engineering hygiene.
• Work closely with Data Engineering on changes to the semantic and curated layer and data marts.
• Deliver complex analytics work streams end‑to‑end, and work within an Agile framework to break down requirements into epics and user stories, contribute to backlog prioritisation and provide realistic estimates.

• 5+ years' experience in a data analytics or BI role, with at least 2 to 3 years in a Lloyd's syndicate, managing agent, London Market broker or specialty (re) insurer.
• Advanced SQL, including query optimisation and working with the Azure data stack (Data Factory, Synapse / Fabric, SQL‑based semantic layers).
• Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query / M, performance tuning, RLS and deployment via pipelines.
• A strong understanding of Power BI engineering discipline: PBIP / TMDL source format, Git‑based version control, pull‑request review and structured release processes, with demonstrable experience in a team setting.
• Proven ability to carry out peer review and QA of analytics work, spotting model errors, DAX issues, performance problems and UX weaknesses.
• Excellent written and verbal communication skills, including presenting to underwriting and senior stakeholders, with a track record of turning ambiguous business problems into delivered analytical outcomes.

• Python for data analysis and an appreciation of wider data science techniques, sufficient to collaborate credibly with Data Scientists and Actuarial colleagues.
• Hands‑on experience applying AI and LLM tooling to analytics work (such as Copilot for Power BI / Fabric, MCP‑style integrations or agentic assistants).
• Experience with Microsoft Fabric, dbt, Azure Dev Ops / Git Hub Actions and data‑quality tooling.