Analyst

Job Description

We are looking for a strong self-starter with a genuine passion for data and a drive to produce results. The right candidate will thrive in a fast-paced environment, where priorities can shift quickly, and will demonstrate the self-motivation and intellectual curiosity needed to continuously learn and develop within a specialist, high-performing team.

\n

\n

Above all, the successful candidate must embody Lockton's core principles:

\n

\n

\n
• Client first

\n

• Results and impact driven

\n

• Self-motivated

\n

• Continuous improvement

\n\n

\n

Role Purpose

\n

The LPS Analyst will report to the LPS Data Lead, providing hands-on analytical and data support across LPS's monoline facilities and wider Lockton portfolio solutions initiatives. The primary focus of the role will be to:

\n

\n

\n
• Continue building and maintaining the data infrastructure underpinning Lockton Portfolio Solutions monoline facilities.

\n

• Support opportunity scoping through the interrogation and modelling of premium and claims data.

\n

• Support the Data Lead in the preparation of high-quality data packs and submissions for insurance markets.

\n

• Build and maintain reporting and dashboards to monitor the performance of LPS facilities.

\n

• Provide analytical support across a range of LPS strategic initiatives.

\n\n

\n

\n

Key Responsibilities

\n

Monoline Facilities – Data & Analytics

\n

\n
• Extract, interrogate and analyse data to support the Portfolio solutions Lead in internal scoping discussions with relevant stakeholders, using BI and analytics to identify opportunities and support the PS Lead.

\n

• Produce Meaningful BI and reporting to assess the profitability and scope of monoline facility opportunities.

\n

• Continue to develop and build on the data infrastructure for the monoline facility initiative

\n\n

\n

Market Submissions & Engagement

\n

\n
• Work with Data Lead to produce professional data packs for submission to market in Excel, PowerPoint and PDF, including a range of analytical exhibits.

\n

• Respond to ad-hoc data requests from markets in a timely and accurate manner.

\n

• Support data lead on maintaining robust reporting on key facility metrics, ideally delivered via interactive dashboards, including:

\n\n

\n
• Indexation: percentage of in-scope business placed versus not placed.

\n

• Premium and claims performance by team and risk code.

\n

• Aggregate accumulations versus limits and modelled loss estimates versus limits (using RMS / AIR outputs).

\n\n

\n
• Ensure reporting remains current and reliable as facilities grow and data sources evolve.

\n\n

\n

Must-Have Skills & Experience

\n

\n
• End-to-end development of Power BI reports, including ETL, data modelling, DAX expression writing and report creation.

\n

• Proficiency in SQL development and good practices in query writing and optimisation.

\n

• Good understanding of relational databases and data architecture.

\n

• Advanced Excel, including Power Query and Power Pivot.

\n

• Strong analytical and problem-solving skills with the ability to translate complex data into clear insights.

\n

• Strong communication skills — able to present findings to both technical and non-technical audiences.

\n\n

\n

Desirable Skills & Experience

\n

\n
• Experience working in the insurance or financial services sector.

\n

• Familiarity with London Market data processes, including BDX, Xchanging or Vipr.

\n

• Experience working with large, multi-source datasets and building data pipelines.

\n

• Knowledge of Python for data analysis and automation.

\n

• Experience building automated reporting solutions or data workflows.

\n

• Hands-on experience using Databricks for analytics and reporting workflows

\n\n