MI Analyst, Capital Systems

CO1001 Corporation of Lloyd’s

Greater London

On-site

GBP 55,000 - 82,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 a data analyst to turn large datasets into actionable insights. You will develop management information using Excel, Power Query and Power BI, and support the validation of capital data submitted through Lloyd's systems.

You will build and maintain reporting that tracks capital returns and business forecasts, develop validation tools, and collaborate with actuarial, risk and syndicate performance teams to ensure robust, well-documented processes.

Qualifications

  • Strong analytical skills with experience in large datasets.
  • Advanced Excel skills and Power Query.
  • Experience with SQL Server, R or Databricks; willingness to develop.
  • Ability to translate analysis into clear information for stakeholders.
  • Excellent attention to detail and structured problem solving.
  • Ability to manage priorities and meet deadlines.
  • Strong collaboration and communication across disciplines.
  • Graduate calibre with a mathematical, analytical or finance background; other qualifications welcome.

Responsibilities

  • Analyze large and complex datasets to identify trends and insights.
  • Develop and improve management information using Excel, Power Query and Power BI.
  • Support validation and audit of capital data across Lloyd's systems.
  • Build reporting that tracks capital returns and forecasts.
  • Collaborate with actuarial, risk and syndicate performance teams.
  • Maintain documentation and audit information for robust processes.
  • Explain analysis to different audiences clearly.

Skills

Analytical skills
Excel
Power Query
Power BI
SQL Server
R
Databricks
Communication
Attention to detail
Time management
Collaboration

Education

Graduate degree in Mathematics/Statistics/Finance

Tools

SQL Server
R
Databricks
Power BI

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.

What you'll be doing
  • 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.
What you'll 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.

We will invest in attracting the best talent to Lloyd's, making sure recruitment is targeted at bringing in the skills we need to evolve. We will develop a talent pipeline that provides us with the key capabilities we will need for the future. To also create a culture in which every employee fulfils their full potential, ensuring that leaders role-model the behaviours we expect in ourselves and others.

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

Lloyd's • City Of London

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

Lloyd'S • Greater London

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

Lloyd's • Greater London

On-site
GBP 90,000 - 115,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)

CO1001 Corporation of Lloyd’s • Greater London

On-site
GBP 70,000 - 120,000
Senior Strategy Associate
Senior Strategy Associate

Lloyd S • Greater London

On-site
GBP 65,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
Head of Capital Modelling
Head of Capital Modelling

Lloyd S • Greater London

On-site
GBP 180,000 - 240,000
Senior Associate – Financial Risk – 12 Month FTC
Senior Associate – Financial Risk – 12 Month FTC

Lloyd S • Greater London

On-site
GBP 110,000 - 140,000
Capital Insights Analyst
Capital Insights Analyst

CO1001 Corporation of Lloyd’s • Greater London

On-site
GBP 55,000 - 82,000