Data Analyst

Arthur J. Gallagher & Co.

Holly Springs (NC)

On-site

USD 65,000 - 85,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive compensation
Comprehensive benefits
Career development
Collaborative culture

Job summary

Gallagher Benefit Services is seeking a Data Analyst to support data-centric projects and act as a Billing Concierge for client payroll and carrier invoicing. The role centers on reconciliation, data handling in Excel, and delivering timely analyses to assist leadership.

The position requires a university degree and several years in benefits data management, with a focus on accuracy, collaboration, and scalable SOPs. Travel up to 30% may be involved.

Qualifications

  • Typically requires a University Degree and minimum 3 years of prior relevant or equivalent experience.
  • Advanced MS Excel and MS Office Suite skills preferred.
  • 2+ years of experience managing data related to group benefits and open enrollments.

Responsibilities

  • Monthly billing reconciliations for clients.
  • Assistance with data collection, scrubbing and modeling.
  • Data manipulation, refinement, and analysis across projects.
  • Development and tracking of SOPs and KPIs.
  • Communicate insights to non-technical stakeholders.

Skills

Data analysis
Excel
MS Office
Statistical methods
Communication
Payroll data

Education

Bachelor’s degree

Tools

BenSelect
Employee Navigator
Bswift
Ease
Harmony

Job description

Introduction

At Gallagher Benefit Services, you’re a trusted partner to organizations navigating some of their most important people decisions. We help clients build better workplaces, where people feel supported, empowered, and inspired to thrive. Whether it’s shaping benefit strategies, designing wellbeing programs, or advising on workforce challenges, the work you do here creates meaningful change for businesses and the people who power them. We’re a community of bold explorers, trusted experts, and compassionate partners; working side by side to solve problems, and shape the future of work. Here, curiosity is encouraged, collaboration is second nature, and your ideas have room to grow. If you’re looking for a place where your contribution matters and where you can help build a better world of work; think of Gallagher.

How you'll make an impact

The Data Analyst utilizes their experience in data analysis and benefits management to contribute to data-centric projects. The day-to-day duties would include reporting and analysis in various data centric initiatives and serving as a Billing Concierge to clients to assist with reconciliation of monthly payroll and carrier invoicing, as well as providing expedited resolution for discrepancies. They would utilize the MS Office Suite of products regularly, working primarily with data in MS Excel.

Essential Duties Include:

  • Monthly billing reconciliations for clients
  • Assistance with data collection, scrubbing and modeling
  • Special projects or assignments as designated by Leadership
  • Research as assigned/applicable to team initiatives
  • Work with the team to assist with documentation creation and maintenance, establishment of SOPs
  • Data manipulation, refinement, and analysis
  • Play an active role in development of new SOPs related to projects
  • Assist with creation and tracking of KPIs related to company operations and special projects
  • Strong statistical and data management background
  • Ability to communicate effectively with non-technical stakeholders
  • Familiarity with enrollment data (payroll, benefits, demographics)
  • Has a high capacity and ability to work on multiple projects concurrently
  • Is a self-starter capable of working in fast paced environments
  • Has strong attention to detail
  • Travel 30%
  • Other duties as assigned
About You

Required:

  • Typically requires a University Degree and minimum 3 years of prior relevant or equivalent experience

Preferred:

  • Advanced MS Excel and MS Office Suite skills
  • 2+ years of relatable or transferrable experience managing data related to group benefits and open enrollments
  • Experience working with insurance enrollment platforms (BenSelect, Employee Navigator, Bswift, Ease, Harmony, etc.) is a plus
  • Previous experience providing reporting and/or working with statistics
  • Previous experience working with demographic and payroll data
  • Experience auditing/reconciling data

#LI-TL1

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. At times, we will consider transferable skills from previous roles.

Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Consultative Analyst
Senior Consultative Analyst

Gallagher • Chicago (IL)

Hybrid
Confidential
Competitive compensation
Comprehensive benefits
Career development opportunities
+2
Consultant, Health & Benefits Consulting
Consultant, Health & Benefits Consulting

Gallagher • Berwyn (PA)

On-site
USD 90,000 - 130,000
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+2
Senior Consultative Analyst
Senior Consultative Analyst

Gallagher Bassett • Rolling Meadows (IL)

On-site
USD 90,000 - 130,000
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+1
Business Analyst, Client Operations
Business Analyst, Client Operations

Gallagher • Austin (TX)

On-site
USD 70,000 - 95,000
Competitive compensation
Comprehensive benefits
Career development
+2
Data Science Engineer
Data Science Engineer

Gallagher • Rolling Meadows (IL)

Remote
USD 110,000 - 150,000
Medical/dental/vision plans
Life and accident insurance
401(K) and Roth options
+8
Underwriter 1
Underwriter 1

Gallagher • Cockeysville (MD)

Remote
USD 54,000 - 66,000
Benefits start day 1
Hybrid work arrangement
Underwriter 1
Underwriter 1

Arthur J. Gallagher group • Maryland

Hybrid
USD 54,000 - 66,000
Competitive compensation
Comprehensive benefits
Career development opportunities
+1
Senior Consultative Analyst
Senior Consultative Analyst

Gallagher • Rolling Meadows (IL)

On-site
USD 90,000 - 120,000
Sr. Client Associate
Sr. Client Associate

Arthur J. Gallagher & Co. • Brentwood (TN)

On-site
USD 52,000 - 78,000
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+1
Accounts Payable Specialist
Accounts Payable Specialist

Arthur J. Gallagher & Co. (AJG) • Fairfax (VA)

On-site
USD 42,000 - 54,000
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+2