Data Insights Analyst - Power BI & SQL Specialist

Lockton; Greater London; On-site; GBP 42,000 - 64,000; Full time

Job summary

Lockton in the United Kingdom is seeking a data professional to join our analytics team. You will design, develop, and maintain Power BI reports and semantic models, and write scalable SQL to support reporting and decision-making.

You will collaborate with business stakeholders to translate requirements, analyse large datasets, and deliver insights that drive data-driven decisions across the organisation. This role also involves working with modern data platforms to enable strategic actions

Qualifications

• Power BI end-to-end development: ingestion, modelling and DAX.
• Strong SQL development, optimisation and data modelling.
• Advanced Excel: Power Query, Power Pivot, complex formulas.

Responsibilities

• Partner with stakeholders to gather and translate analytics requirements.
• Extract, transform, analyse data from multiple sources for decision-making.
• Design, develop and maintain Power BI reports and semantic models.
• Write scalable SQL queries to support reporting.
• Deliver insights and recommendations on trends, risks and opportunities.
• Collaborate with technical and non-technical teams to promote a data-driven culture.

Skills

Power BI

SQL & Data Analysis

Excel

Tools

Databricks

dbt

Azure

Git/GitHub

Job description

Lockton in the United Kingdom is seeking a data professional to join our analytics team. You will design, develop, and maintain Power BI reports and semantic models, and write scalable SQL to support reporting and decision-making.

You will collaborate with business stakeholders to translate requirements, analyse large datasets, and deliver insights that drive data-driven decisions across the organisation. This role also involves working with modern data platforms to enable strategic actions