Senior Data Analyst-Azure Data Lake, Azure Data Factory, and Azure Analysis Services

Arthur J. Gallagher & Co.; London; Hybrid; GBP 45,000 - 75,000; Full time

Job summary

Join a forward-thinking company as a Senior Data Analyst, where your expertise in data analysis and visualization will drive strategic decisions in the insurance sector. This role offers the opportunity to work with advanced tools and technologies, including Microsoft Azure, to develop data pipelines and analytical tools. You'll collaborate with clients and brokers to deliver insights that shape the future of reinsurance. With a commitment to innovation and excellence, this position provides a platform for professional growth and the chance to make a significant impact in a dynamic environment.

Benefits

25 days holiday plus bank holidays

Defined contribution pension scheme

Life insurance up to 10x salary

Income protection

Health cash plan or Private medical insurance

Volunteering days

Employee Stock Purchase plan

Discounted gym membership

Season ticket loan

Emergency back-up family care

Qualifications

• Proven experience in Senior Data Analyst/Engineering role in insurance.
• Advanced proficiency in SQL, Python, and Power BI for data analysis.

Responsibilities

• Collaborate with clients to provide data-driven insights for placements.
• Utilize data analysis techniques to analyze large datasets.

Skills

SQL

Python

Power BI

Microsoft Excel

Data Analysis

Data Visualization

Problem-solving

Education

Degree in Statistics

Degree in Mathematics

Degree in Computer Science

Degree in Engineering

Tools

Microsoft Azure Data Factory

Azure Data Lake

Azure Analysis Services

Job description

Introduction

Join us at Gallagher Re, the trailblazers of the reinsurance world, where every day brings new opportunities to shape the future. We empower our clients with cutting-edge analytics and insights, providing them the confidence to make strategic decisions that transform industries. As a team member, you'll be at the forefront of innovation, translating data into impactful solutions and taking the reins of your career like never before.

We believe that every candidate brings something special to the table, including you! So, even if you feel that you’re close but not an exact match, we encourage you to apply.

Overview

Gallagher Re are looking to hirean experienced insurance Senior Data Analyst 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. Their expertise in analytics and commitment to excellence positions Gallagher Re as a leader in the reinsurance industry.

This role will be based from our London office with an expectation of being on site two days per week.

How you'll make an impact

• Collaborate with brokers and 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.
• 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 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 SQL, Python, Power BI, 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 Services.
• 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.
• A degree in a related field such as statistics, mathematics, computer science, or engineering would be an advantage but is not essential.

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. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.

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. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.

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.

We understand that applicants may have disabilities, if you do, you may find some parts of the recruitment process more challenging than others. Don’t worry, we’re here to help, however, we can only do this if you let us know.

Should you require reasonable adjustments to your application, please get in touch with [e-mail] . If you’d prefer to speak on the phone, please request a call back, leaving details, so we 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 are opposed to any form of less favourable treatment on the grounds of gender or gender identity, marital status, civil partnership status, parental status, race, ethnicity, colour, nationality, disability, sexual orientation, religion/ belief, age and those with caring responsibilities.

Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as “protected characteristics”) by applicable federal, state, or local laws.

Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, 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.