Senior Data Analyst

We are recruiting for a Senior Data Analyst on behalf of an award-winning Lloyds Syndicate.

The successful candidate must have experience working in a Lloyds 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-modelling technical standards contributing to complex analysis and introducing new techniques including the practical application of AI tools within the analytics workflow.

Key Responsibilities

• Acting 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.
  
• Translating open-ended commercial questions into well-scoped analyses and dashboard requirements and collaborating with the wider business to identify opportunities for automation and operational efficiency gains.
  
• Identifying and applying 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.
  
• Embedding the teams 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 contributing to workspace governance across Dev / Test / Prod environments.
  
• Coaching analysts and BI developers on SQL DAX data modelling visual design and engineering hygiene.
  
• Working closely with Data Engineering on changes to the semantic and curated layer and data marts.
  
• Delivering complex analytics workstreams end-to-end and working 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 Lloyds 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.
  

Desirable

• 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 DevOps / GitHub Actions and data-quality tooling.