Data Analyst/Engineer - Casualty Analytics

Introduction At Gallagher Re, we bring clarity to complexity by helping clients around the world make confident, data-driven decisions in a rapidly evolving risk landscape. Here, you’ll be part of a team that leverages world-class analytics and deep reinsurance expertise to deliver strategic advisory services and transactional excellence. Together, we transform advanced insights and market intelligence into strategies that protect businesses, drive performance, and shape the future of reinsurance. We’re a community of decision makers, future shapers, and trusted experts working side by side to deliver meaningful impact through innovative thinking and practical solutions. At Gallagher Re, your curiosity is welcomed, your growth is championed, and your work truly matters. This is a place where you'll have the freedom to explore new ideas, take ownership of your career, and collaborate with people who are as driven and inquisitive as you are. Overview We are seeking a talented Data Analyst/Engineer to join our Casualty Analytics team at Gallagher Re. This is a unique opportunity to become the team's dedicated data specialist, working closely with actuaries to deliver high-quality data solutions that support complex reinsurance placements for clients worldwide. As a standalone role, you will be responsible for managing and responding to a wide range of data requests while also driving the evolution of the team's data capabilities, helping to develop scalable processes, improve data quality, and unlock deeper analytical insights. The role will be based in London and we offer hybrid working with an expectation of being in the office three days a week. How you'll make an impact Collaborate with brokers and clients to understand data requirements and provide data-driven insights to support reinsurance placements. Utilise advanced data analysis techniques and visualisation tools to analyse large and complex datasets, providing insights on market trends, claims experience, loss ratios and other key performance indicators. Design, build and optimise Python data pipelines to ingest, cleanse, transform and standardise datasets from multiple external sources, leveraging VS Code, GitHub version control and modern development practices to deliver efficient, repeatable and auditable data processing and analysis. Develop and implement robust data quality checks and controls to ensure data accuracy and completeness. Lead the development of a central casualty exposure and claims database, including schema design. Design and implement analytical tools, dashboards and benchmarking datasets that compare portfolios consistently across clients, classes and time periods. Stay at the forefront of industry trends and emerging technologies in data analysis, visualisation, data engineering and AI. Identify and deliver opportunities to automate and streamline existing manual processes. About You Bachelor’s degree in data science, computer science, statistics, mathematics or a similarly quantitative, technical subject. Proven experience in a data analyst/engineering role, with a focus on technical data pipelining and analysis in the insurance industry. Exposure to reinsurance, in particular casualty lines, would be a distinct advantage. Excellent Python skills, with demonstrable, production-quality experience using pandas and related libraries for data cleansing, transformation and automation. Experience with Git and collaborative development workflows. Strong SQL, with practical experience of designing relational database schemas and building and maintaining data stores. A proven track record of working with large, messy, inconsistently structured datasets and making them analysis-ready. Experience designing and implementing automated data quality checks and controls. Advanced Excel and Power Query skills, with data visualisation experience in Power BI. Excellent problem-solving and critical-thinking skills. Strong communication skills with the ability to present complex data insights to non-technical stakeholders. Knowledge of data governance frameworks and regulatory compliance, including GDPR. Must have the right to work in the UK. Compensation and benefits At Gallagher, we believe supporting our colleagues goes far beyond the role itself. For more information, visit our Benefits page. Competitive compensation Comprehensive benefits programs designed to support your well-being Career development opportunities and ongoing learning A collaborative, people-first culture with accessible leadership The opportunity to do meaningful work with global reach and local impact At Gallagher, we are dedicated to building an inclusive and authentic workplace. If your past experience doesn’t align perfectly, we encourage you to join our Talent Community to stay connected to additional career opportunities. Although this role is listed as full-time, if you’re in a job-share partnership, work reduced hours, or have any other flexible arrangement, please still get in touch. We will also offer reasonable adjustments to the recruitment process if required, so please let us know. Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)