MI Analyst, Capital Systems

Lloyd's

City Of London

On-site

GBP 52,000 - 76,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Lloyd's in London is seeking an MI Analyst to turn large capital and reserving data into clear insights. You will work across syndicate and member capital, building reporting, validating data flows, and supporting capital forecasting using Excel, Power BI, Power Query, and SQL-based tools.

The role emphasizes rigorous data analysis, attention to detail, and the ability to explain complex findings to diverse audiences while collaborating with actuarial, risk and performance teams.

Qualifications

  • Strong analytical skills with the ability to manipulate large datasets.
  • Advanced Excel skills and experience with Power Query.
  • Experience with analytical or data tools such as SQL Server, R or Databricks.
  • Ability to translate detailed analysis into clear information for diverse audiences.
  • Excellent attention to detail and a logical approach to problem solving.
  • Capable of managing priorities and meeting deadlines.
  • Collaborative across disciplines and clear communication.

Responsibilities

  • Analyse large and complex datasets to identify trends, outliers, and insights.
  • Develop and improve management information using Excel, Power Query and Power BI.
  • Support processing, validation and audit of capital data in Lloyd's systems.
  • Build and maintain reporting tracking capital returns and forecast submissions.
  • Develop validation tools and improve data movement into/out of capital models.

Skills

Data analysis
Advanced Excel
Power Query
SQL Server
R
Databricks
Communication

Education

Mathematics/Statistics/Finance degree

Tools

Power BI
SQL

Job description

Lloyd’s is the world’s leading insurance and reinsurance marketplace, bringing together the world’s leading risk takers to advance global progress.Our strategy is focused on delivering strong underwriting performance, operating an efficient and flexible marketplace, and maximising the capital advantage of the Lloyd’s market — while continuing to build a Lloyd’s we are proud of.How we deliver this, matters. We take the risk, make things happen, and own the outcome — working together across our global network to turn insight into impact.Lloyd’s are recruiting for an MI Analyst, Member Capital. This is an opportunity to work with the data at the heart of the Lloyd’s market. You’ll turn complex capital and reserving information into clear, useful insight, helping us understand performance, strengthen our oversight and make better-informed decisions. If you enjoy solving data problems, improving how information flows and finding the story within complex datasets, you’ll have plenty of scope to make an impact here.What you’ll be doingYou’ll work across syndicate and member capital, combining data analysis, management information and continuous improvement.You’ll:Analyse large and complex datasets, identifying trends, outliers and insights that matter.Help develop and improve management information using tools including Excel, Power Query and Power BI.Support the processing, validation and audit of capital data submitted through Lloyd’s systems.Build and maintain reporting that tracks capital returns and business forecast submissions.Develop validation tools and improve how data moves into and out of capital models.Carry out analysis on member capitalisation and syndicate benchmark capital.Help answer data and capital-related queries from across the Lloyd’s market.Support the ongoing development of systems used by market participants to assess capital requirements.Maintain clear documentation, controls and audit information so our processes remain robust.Collaborate with colleagues across actuarial, risk, catastrophe and syndicate performance teams.It’s analytical work with a clear purpose: helping Lloyd’s maintain strong oversight while making our marketplace more efficient and effective.What you’ll bringWe’re interested in what you can do and your potential to develop, not whether you tick every box.You’ll ideally bring:Strong analytical skills and confidence working with large datasets.Advanced Excel skills, including experience with Power Query.Experience with analytical or data tools such as SQL Server, R or Databricks, or a good foundation and the appetite to develop further.The ability to translate detailed analysis into clear information for different audiences.Excellent attention to detail and a logical approach to solving problems.Confidence managing your own priorities and delivering accurate work to deadlines.The ability to collaborate with people across different disciplines and communicate clearly.You’ll be of graduate calibre, ideally with a mathematical, analytical or finance-based background. Other relevant professional qualifications are welcome.Being inclusive at Lloyd’s is integral to how we work — and how we deliver impact.We aim to build a diverse, inclusive environment that reflects the global markets we serve, where everyone is treated with dignity and respect and supported to reach their full potential.We take the risk by challenging traditional thinking and being proactive about inclusion. That means being open and positive about workplace adjustments, prioritising health and wellbeing, and investing in diversity and inclusion training so everyone feels able to contribute and succeed.We make things happen by turning our commitment into action. Through employee networks, mentoring, volunteering opportunities and sustained investment in professional development, we create an environment where inclusion is experienced day‑to‑day — not just talked about.We own the outcome by focusing on impact. By bringing together diverse perspectives and the best minds in the industry, we work collaboratively with underwriters and brokers to create innovative, responsive solutions that share risk and solve complex problems across global markets.Should you require any additional support with your application, or any adjustments, please click the following link;https://urldefense.com/v3/__http:/ctir.cleartalents.com/apply/experiencedhires__;!!BHksnLxjsWnPVFM!Zw-sfFLbBNwtuHUIxAmJhLtq95RHC4LwVQ7lnk_w-3aFwpTfsLqE3qds0B5si5JOpqnfgYCoarWa3kTt1ET-Wfj94vZY_A$Please note, clicking on this link does not register your application for the vacancy
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

MI Analyst, Capital Systems
MI Analyst, Capital Systems

CO1001 Corporation of Lloyd’s • Greater London

On-site
GBP 55,000 - 82,000
Senior Actuarial Associate (Capital Oversight)
Senior Actuarial Associate (Capital Oversight)

Lloyd • Greater London

Hybrid
GBP 90,000 - 120,000
Head of Capital Modelling
Head of Capital Modelling

Lloyd's • Greater London

On-site
GBP 130,000 - 190,000
Senior Actuarial Associate (Capital Oversight)
Senior Actuarial Associate (Capital Oversight)

Lloyd's • Greater London

On-site
GBP 90,000 - 115,000
Capital MI Analyst: Turn Data into Market Insights
Capital MI Analyst: Turn Data into Market Insights

Lloyd's • City Of London

On-site
GBP 52,000 - 76,000
Senior Actuarial Associate (Capital Oversight)
Senior Actuarial Associate (Capital Oversight)

CO1001 Corporation of Lloyd’s • Greater London

On-site
GBP 70,000 - 120,000
Senior Actuary (Capital Oversight)
Senior Actuary (Capital Oversight)

Lloyd S • Greater London

On-site
GBP 120,000 - 180,000
Senior Actuarial Associate (Capital Oversight)
Senior Actuarial Associate (Capital Oversight)

Lloyd'S • Greater London

On-site
GBP 90,000 - 130,000
Insights Hub & Data AI Community Manager
Insights Hub & Data AI Community Manager

Lloyd's • Greater London

On-site
GBP 60,000 - 90,000
Head of Capital Modelling
Head of Capital Modelling

CO1001 Corporation of Lloyd’s • Greater London

On-site
GBP 140,000 - 190,000