Senior Data Analyst — AI-Driven Analytics & BI Partner

AEGIS; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

AEGIS London is seeking a Senior Data Analyst to help evolve analytics from pure reporting to value-added insights that inform underwriting, claims and exposure decisions. You will work hands-on to embed analytics in day-to-day business and partner with stakeholders across functions.

You will champion governance and development standards for BI, mentor analysts, deliver end-to-end analytics projects in an Agile setting, and explore AI-enabled tooling to surface actionable insights for

Qualifications

• Well developed experience in a data analytics or BI role, preferably in an insurance or finance environment.
• Advanced SQL, including query optimisation and working with the Azure data stack (Data Factory, Synapse / Fabric, SQL-based semantic layers).
• Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query / M, performance tuning, RLS, and deployment via pipelines.
• Understanding of Power BI engineering discipline: PBIP / TMDL source format, Git-based version control, pull-request review, structured release and rollback process; demonstrable experience of these practices in a team.
• Proven ability to carry out peer review and QA of analytics work – spotting model errors, DAX issues, performance problems and UX weaknesses, and giving constructive feedback.
• Excellent written and verbal communication skills, including presenting to underwriting and internal stakeholders.
• Strong stakeholder engagement, with a track record of turning ambiguous business problems into delivered analytical outcomes.

Responsibilities

• Act as the senior analytics business partner to one or more underwriting classes, proactively identifying where analytics can improve pricing, portfolio steering, renewal decisions and exposure management.
• Translate open-ended commercial questions into well-scoped analyses and dashboard requirements.
• Closely collaborate with the wider business to identify areas of automation and acceleration to improve operational efficiency.
• Identify practical opportunities to enhance the analytics workflow with AI tooling -for example, using LLMs and agentic tools for data exploration, code generation, documentation, and surfacing insight to underwriters.
• Support the Data Analytics Manager in shaping external data analytical propositions -from discovery and prototyping through to packaging and delivery.
• Deliver complex analytics workstreams end-to-end – scoping, estimation, delivery, hand-over and post-implementation review.
• Work within an Agile framework: break down requirements into epics and user stories, contribute to backlog prioritisation with the Data Analytics Manager, and provide realistic estimates.

Skills

Advanced SQL

Power BI development

Power BI data modelling

Git-based version control

Code review and QA

Stakeholder engagement

Communication skills

Tools

PBIP / TMDL

GitHub Actions / Azure DevOps

Microsoft Fabric

dbt

Data quality tooling

Job description

AEGIS London is seeking a Senior Data Analyst to help evolve analytics from pure reporting to value-added insights that inform underwriting, claims and exposure decisions. You will work hands-on to embed analytics in day-to-day business and partner with stakeholders across functions.

You will champion governance and development standards for BI, mentor analysts, deliver end-to-end analytics projects in an Agile setting, and explore AI-enabled tooling to surface actionable insights for