Data Analyst – Lloyd’s Insurance, MGAs

We’re recruiting on behalf of a fast growing MGA capital partner that backs underwriting talent to launch and scale their own specialist insurance businesses.

They’re now looking for a Data Analyst to join their Digital and Technology team, with a strong lean toward data engineering. The bulk of the role is building and maintaining pipelines in Azure Data Factory, but you’ll also get stuck into data quality, triage, requirements gathering and genuine problem solving alongside underwriters, finance, sales and operations.

• Building and maintaining ETL pipelines in Azure Data Factory, including linked services, data flows and scheduling
• Writing and optimising SQL against SQL Server to support reporting and transformation
• Delivering dashboards and analytics in Qlik that actually get used
• Supporting Function Apps and Logic Apps for automation and integration
• Triaging data incidents, digging into root causes and working with the technical team to fix them
• Running requirements workshops and turning business questions into data solutions

• Solid hands on SQL Server and Azure Data Factory experience in a live production environment
• Comfort with Qlik or a similar BI tool
• Insurance industry background, ideally with exposure to commercial insurance, policy lifecycle, BDX production or premium calculations
• A genuinely flexible mindset. Priorities here can shift from one day to the next, and you’ll need to be just as happy deep in a pipeline as you are in a stakeholder meeting