Benefits Systems Analyst – Data Quality & Renewal Specialist

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

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.