Benefits Systems Analyst

Arthur J. Gallagher & Co. (AJG); Bogotá; On-site; COP 40,000,000 - 70,000,000; Full time

Job summary

Gallagher is seeking a detail-oriented professional to support and optimize employee benefits systems. You will help with system setup, testing, and ongoing updates to ensure plans operate smoothly for clients and their people.

The role emphasizes data quality, timely renewals, and collaboration across teams to deliver reliable service. You will work in a fast-paced environment, using Excel (VLOOKUP, pivot tables) and benefit platforms like bswift.

Qualifications

• Bachelor’s degree required.
• Experience with benefit administration systems (bswift or similar) preferred.
• Solid understanding of employee benefits (health, life, disability, voluntary).
• Familiarity with insurance carrier billing and COBRA administration is a plus.
• Proficient in Excel, including VLOOKUP and pivot tables.
• Ability to review data carefully, identify patterns, and translate findings into actions.
• Strong written and verbal communication with both technical and non-technical partners.
• Organized and steady in a fast-moving environment.
• Works well independently and in a team.
• Committed to accuracy and meeting deadlines.
• Open to learning new systems and improving processes.
• Values teamwork, client service, and delivering a better experience.

Responsibilities

• Help clients launch and renew benefit sites with accuracy and care.
• Ensure system setup reflects plan rules, rates, eligibility, and client needs.
• Support a smooth experience for employees using the benefits platform.
• Identify, research, and resolve system issues before they affect service.
• Test system changes and verify data before go-live.
• Use data checks to protect quality and reduce errors.
• Collaborate with internal teams to maintain momentum and meet deadlines.
• Provide clear updates to clients and teammates throughout projects.
• Spot process gaps and help improve team efficiency.
• Support carrier and payroll feed setup to ensure data accuracy.

Skills

Attention to detail

Communication

Teamwork

Education

Bachelor’s degree

Tools

Excel

bswift

Job description

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way.

Overview

This role helps keep employee benefits systems accurate, reliable, and ready for clients and their people. You will support system setup, testing, and ongoing updates so benefit plans work as intended and clients get a smooth experience. Your work will help protect data quality, support timely renewals, and improve how teams deliver service.

How you'll make an impact

• Help clients launch and renew benefit sites with accuracy and care.
• Make sure system setup reflects plan rules, rates, eligibility, and client needs.
• Support a smooth experience for employees using the benefits platform.
• Find, research, and resolve system issues before they affect service.
• Test system changes and confirm data is correct before go-live.
• Use data checks and audits to protect quality and reduce errors.
• Partner with internal teams to keep work moving and meet deadlines.
• Share clear updates with clients and teammates throughout each project.
• Spot process gaps and help improve how the team works.
• Support carrier and payroll feed setup so data flows correctly.
• Contribute to special projects that improve service and client outcomes.
• Share ideas, coach teammates, and help build a strong, collaborative team.

About you

• You have a bachelor’s degree.
• You bring experience with benefit administration systems, such as bswift or a similar platform. (This is preferred, not required).
• You understand employee benefits, including health, life, disability, and voluntary plans.
• You are comfortable working with insurance carrier billing and Consolidated Omnibus Budget Reconciliation Act administration. (Preferred).
• You use Microsoft Excel with confidence, including VLOOKUP and pivot tables.
• You can review data carefully, spot patterns, and use findings to guide action.
• You communicate clearly in writing and in conversation with both technical and non-technical partners.
• You stay organized and steady in a fast-moving environment.
• You work well on your own and as part of a team.
• You take pride in doing accurate work and meeting deadlines.
• You are open to learning new systems and improving how things are done.
• You value teamwork, client service, and creating a better experience for others.