Pension Systems Data Analyst

Arthur J. Gallagher & Co.; Bristol; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading benefits services provider in the UK is seeking a Pension System Data Analyst to join their team. You will take the lead in onboarding clients onto pension applications and managing data with SQL. Ideal candidates should have strong data manipulation skills, intermediate to advanced SQL capabilities, and familiarity with UK pension legislation. This role offers a competitive salary and a comprehensive benefits package.

Benefits

Minimum of 25 days holiday

Defined contribution pension scheme

Life insurance

Income protection

Health cash plan or private medical insurance

Employee Stock Purchase plan

Discounted gym membership

Emergency back-up family care

Qualifications

• Demonstrated expertise in handling complex data manipulation.
• Intermediate to advanced SQL capabilities.
• High-level proficiency in MS Office applications, including Word, Excel, and Access.
• Experience in implementing or supporting pension systems is preferred.
• Familiarity with UK pension legislation and benefit administration systems is advantageous.
• Strong verbal and written communication skills in English.
• Confirmed ability to work effectively within a team.

Responsibilities

• Lead in onboarding new clients onto Gallagher Pension applications.
• Map and modify data using SQL for pension administration systems.
• Maintain service standards including test systems and live release procedures.
• Acquire understanding of legislation and system functionality in UK pension sectors.

Skills

Complex data manipulation

Intermediate to advanced SQL

MS Office proficiency

Experience with pension systems

Familiarity with UK pension legislation

Strong communication skills

Team collaboration

Job description

Introduction

Discover a world of endless possibilities at Gallagher Benefit Services, where you'll have the power to shape the future of workplaces across industries. As a member of our team, you become the driving force behind positive change, helping clients build environments where employees thrive. Embrace the opportunity to impact lives, unlock potential, and create a legacy of remarkable transformation.

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

Are you a high-reaching Data Analyst with a drive for excellence and a keen curiosity about problem-solving? Arthur J. Gallagher is looking for a Pension System Data Analyst to become a part of our committed team. This is an outstanding opportunity to collaborate with world-class professionals and make a meaningful contribution by providing outstanding data solutions for our clients. You will play a crucial role in our mission to offer outstanding service and innovative solutions in the pension systems industry.

How you'll make an impact

Within this role, you will take the lead in onboarding new clients onto Gallagher Pension applications, as well as mapping and modifying data using SQL for our pension administration systems.

It's vital to maintain Gallagher's service standards, including test systems, live release procedures, mentorship in project work, and data support tasks. Additionally, you will acquire a high-level understanding of legislation and system functionality within the UK pension and payroll sectors. This position offers an excellent opportunity to develop leadership attributes for career progression.

About you

• Demonstrated expertise in handling complex data manipulation.
• Intermediate to advanced SQL capabilities.
• High-level proficiency in MS Office applications, including Word, Excel, and Access.
• Experience in implementing or supporting pension systems is preferred.
• Familiarity with UK pension legislation and benefit administration systems is advantageous.
• Strong verbal and written communication skills in English.
• Confirmed ability to work effectively within a team and experience collaborating in project teams.

#LI-TM2

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.