Portfolio Data Analyst

Data Analyst | Remote (UK) | Full-time | 35-50K + bonus | Path to Head of Data

Ready to build the data "brain" of a fast-growing MGA?

We are looking for a hands-on Data Analyst or Data Scientist to take ownership of our underwriting analytics. This is a rare "greenfield" opportunity: we need someone to turn raw BDX, policy, and claims data into the actionable insights that drive our profitability. You'll be given the guidance and tools to build out our data function as we scale, and we'll be looking for you to take over the data leadership function with our firm in time.

This is a hybrid role blending Data Engineering-lite (building pipelines, cleaning BDX) with High-Level Analytics (pricing, portfolio strategy, and dashboards).

About the Opportunity:

• You will report directly to the Head of Underwriting and help leadership test hypotheses on new products and pricing. We're targeting 3x growth this year, so this role is crucial in making sure our data and product understanding evolves with the firm.
• You will choose the tools and build the infrastructure (Azure/SQL/Python) required to make data flow.
• As we scale, this role is designed to evolve into a Lead Data or Head of Data & Analytics position.

Key Responsibilities:

• Analyse loss ratios, rate changes, and retention to tell us why the portfolio is performing the way it is.
• Help underwriters make better decisions by providing case-by-case analysis and monitoring referrals from our clients.
• Build frameworks and dashboards to track aggregates and concentrations (by geography, industry, peril).
• Design and maintain a lightweight but robust data stack (e.g., Azure SQL, Data Lake, Fabric).
• Use Python/SQL to move data from messy sources (BDX, finance systems) into a clean, usable analytics layer.
• Be the guardian of "the number." Ensure data is reconciled, version-controlled, and accurate.
• Own the data side of BDX including ingestion, validation, and mapping from multiple partners.
• Design data models that turn messy partner data into a standardised format we can actually use.
• Design clear, commercial dashboards for underwriters, finance, and leadership.
• Kill the manual spreadsheets. Automate monthly MI packs and portfolio deep dives.

What We’re Looking For:

• You can write complex queries, joins, and window functions in your sleep.
• You are comfortable using pandas/NumPy for data wrangling and automation.
• You know how to build data models and use DAX to create meaningful visualizations.
• Experience with Azure (SQL/Data Lake/Fabric) is highly desirable.
• You understand (or can quickly learn) concepts like Loss Ratios, Earned Premium, IBNR, and Delegated Authority.
• You aren't afraid of messy, real-world data. You know how to clean it, validate it, and fix it.
• You can explain complex data insights to non-technical underwriters and finance teams in plain English.
• You treat the data as your own product. You care about accuracy and traceability.

Qualifications:

• Experience in a Data Analyst / Data Scientist role (Insurance, Banking, Credit Risk, or similar regulated sector).
• Experience specifically within the MGA / Lloyd’s / Specialty market.
• Experience with predictive modelling (GLMs, Gradient Boosting) for pricing insights.