Portfolio Data Analyst — BI Dashboards & SQL

Lockton; City Of London; On-site; GBP 45,000 - 65,000; Full time

Job summary

Lockton is seeking a data-driven LPS Analyst to join our fast-paced Portfolio Solutions team in London. You will build and maintain BI reports, model data, and support market submissions with robust analyses.

You will own end-to-end Power BI reporting, SQL data queries, and Excel-based workbooks, partnering with stakeholders to translate complex data into actionable insights across monoline facilities and wider Lockton portfolio initiatives.

Qualifications

• End-to-end development of Power BI reports and dashboards.
• Proficiency in SQL development and query optimization.
• Strong Excel skills including Power Query and Power Pivot.
• Ability to translate data into actionable insights for technical and non-technical audiences.

Responsibilities

• Extract, interrogate and analyse data to support market submissions.
• Build meaningful BI reports to monitor facility performance.
• Develop data pipelines and maintain data infrastructure.
• Collaborate with stakeholders across Lockton portfolio initiatives.
• Provide analytical support for strategic initiatives.

Skills

Power BI

SQL

Excel

Data modelling

DAX

Stakeholder communication

Tools

Power BI

SQL

Excel

Power Query

Power Pivot

Databricks

Job description

Lockton is seeking a data-driven LPS Analyst to join our fast-paced Portfolio Solutions team in London. You will build and maintain BI reports, model data, and support market submissions with robust analyses.

You will own end-to-end Power BI reporting, SQL data queries, and Excel-based workbooks, partnering with stakeholders to translate complex data into actionable insights across monoline facilities and wider Lockton portfolio initiatives.