Analytics Data Analyst/Engineer

Arthur J. Gallagher & Co. (AJG); City Of London; Hybrid; GBP 65,000 - 85,000; Full time

Job summary

A leading insurance firm seeks an experienced Analytics Data Engineer for its London office. This role involves supporting insurance and reinsurance decisions through advanced data analysis and visualization. Candidates should have strong skills in SQL, Python, and Azure tools, alongside excellent communication abilities. The position includes a competitive salary, extensive benefits, and an inclusive workplace environment.

Benefits

25 days holiday plus bank holidays

Defined contribution pension scheme

Employee Stock Purchase plan

Health cash plan or Private medical insurance

Discounted gym membership

Qualifications

• Proven experience in a Senior Analytics or Data Analyst/Engineering role within the insurance or reinsurance industry.
• Advanced proficiency in data analysis and visualization tools such as Power BI, SQL, and Python.
• Excellent problem-solving skills and attention to detail.

Responsibilities

• Collaborate with brokers and clients to understand data requirements and provide insights.
• Utilize advanced data analysis techniques to analyze large datasets.
• Develop and optimize data pipelines using Microsoft Azure tools.

Skills

Data analysis

Azure Data Factory

Power BI

SQL

Python

Tools

Microsoft Azure toolkit

Azure Data Lake

Azure Analysis Service

Job description

Overview

Gallagher Re are looking to hire an experienced insurance Analytics Data Engineer to join our growing analytics team. This opportunity will play a critical role in delivering sophisticated data analysis to support the placement of insurance and reinsurance programs for our clients across various lines of business and territories. Gallagher Re's Data and Analytics team is instrumental in driving innovation and delivering strategic value through data. This role will be based from our London office with an expectation of being on site two days per week.

We encourage you to apply even if you feel you’re close to the match.

How you\'ll make an impact

• Collaborate with brokers and external clients to understand data requirements and provide advanced data-driven insights to support insurance and 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.
• Previous experience working with Underwriting Workbenches is essential and required for this role.
• Develop and optimise data pipelines using Microsoft Azure Data Factory and other Azure tools to ensure efficient data processing and analysis.
• Design and implement analytical tools and dashboards to support strategic data-driven decision-making across the organisation.
• Lead the development and implementation of robust data quality checks and controls to ensure data accuracy and completeness.
• Stay at the forefront of industry trends and emerging technologies in data analysis, visualisation, and data pipelining.
• Contribute to the development of bespoke client data models.

About You

• Proven experience gained in a Senior Analytics or Data Analyst/Engineering role, with a focus on technical data pipelining and analysis in the insurance or reinsurance industry.
• Advanced proficiency in data analysis and visualisation tools such as Power BI, SQL, Python, and Microsoft Excel.
• Extensive experience with Microsoft Azure toolkit, including data storage and analytics services such as Azure Data Lake, Azure Data Factory, and Azure Analysis Service would be an advantage.
• Excellent problem-solving skills and meticulous attention to detail.
• Excellent communication and presentation skills with the ability to convey complex technical concepts to non-technical audiences.
• Ability to work independently and manage multiple priorities in a fast-paced, deadline-driven environment.

Compensation and benefits

On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.

Below are the minimum core benefits you’ll get, depending on your job level these benefits may improve:

• Minimum of 25 days holiday, plus bank holidays, and the option to ‘buy’ extra days
• Defined contribution pension scheme, which Gallagher will also contribute to
• Life insurance, which will pay 4x your basic annual salary, which you can top-up to 10x
• Income protection, we’ll cover up to 50% of your annual income, with options to top up
• Health cash plan or Private medical insurance

Other benefits include:

• Three fully paid volunteering days per year
• Employee Stock Purchase plan, offering company shares at a discount
• Share incentive plan, HMRC approved, tax effective, stock purchase plan
• Critical illness cover
• Discounted gym membership, with over 3,000 gyms nationally
• Season ticket loan
• Access to a discounted voucher portal to save money on your weekly shop or next big purchase
• Emergency back-up family care
• And many more…

We value inclusion and diversity. Inclusion and diversity (I&D) is a core part of our business, and it’s embedded into the fabric of our organisation. Gallagher embraces our employees’ diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength.

Gallagher is Disability Confident Committed. We have pledged to make sure our recruitment process is inclusive and accessible, in addition to supporting our existing employees with any long-term health conditions or disabilities. Should you require reasonable adjustments to your application, please contact [e-mail] or request a callback with details so we can get in touch.

Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation. We are committed to diversity and opportunity for all and strongly oppose discrimination on grounds of gender, race, disability, age, or any other protected characteristic.

Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers. Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.