20th November 2025
Data & Reporting Automation Analyst
Business Analyst
London
£70,000 + benefits + generous bonus opportunities.
Our insurance client are looking for a Data & Reporting Automation Analyst to join the Exposure Management Team and oversee the end-to-end data flow, integration and reporting processes that support exposure management, catastrophe modelling, and business insights. The successful candidate will be responsible for the design, optimisation, and automation of data pipelines and reporting frameworks.
You will collaborate closely with business units, IT, and analytics teams to develop robust data quality metrics, automate submissions, and drive continuous improvement through advanced analytics and AI solutions.
The Role:
– Permanent position with the annual base salary of £70,000 + benefits + generous bonus opportunities.
– Full time on site (5x per week) in their Central London offices.
– Exceptional career progression opportunity paired with frequent salary reviews.
Skills & Experience Required:
– MUST have previous insurance industry experience
– Strong experience with Power BI (or similar visualisation tool).
– Strong SQL and Python programming language proficiency.
– Experience with ETL tools (for example., Azure Data Factory, Alteryx, Talend, SSIS)
– Good understanding of cloud data environments (Azure, AWS or GCP).
– Familiarity with API integrations (REST, JSON).
This is a great opportunity for someone who enjoys coding, working with data, and supporting underwriting decisions through insight and automation.
Consultant - Josh Massey
Telephone: 0207 392 7515
Email: josh.massey@spencer-rose.com
Share This Position