Employee Benefits Analytics Consultant

Arthur J. Gallagher & Co. (AJG); Bogotá; On-site; COP 191,969,000 - 287,954,000; Full time

Job summary

Gallagher is seeking an Employee Benefits Analytics Consultant to transform benefits plan data into actionable insights and support plan design decisions. You will help clients understand plan performance through clear reporting and predictive modeling tools.

In this role you will analyze population risk, financial trends, and utilization patterns, support Large Group Practice sales, and travel up to 10% for client meetings, planning, and training as needed.

Qualifications

• Bachelor's degree required and 5+ years of related experience.
• Advanced English level.
• Understanding of challenges in employee benefit plans and health care trends.
• Experience building client relationships and presenting information clearly.
• Experience with analytics tools, predictive modeling, databases or data collection systems.
• Ability to manage several projects at once while keeping work accurate and timely.
• 2–3 years of brokerage or agency experience preferred.

Responsibilities

• Analyze benefits plan data to identify population risk, financial trends, and utilization patterns; use predictive modeling to forecast outcomes and build analytics processes.
• Support sales and prospecting efforts in the Large Group Practice; present plan performance reports to clients and review product results.
• Collaborate with clients and colleagues to set timelines and manage travel up to 10% for meetings and training; operate from office for planning and preparation as needed.

Skills

Predictive modeling

Databases

Data collection

Client relationships

Project management

Problem solving

English proficiency

Education

Bachelor's degree

Tools

Analytics software

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

As an Employee Benefits Analytics Consultant, you'll use data and technology to help shape risk management strategies for clients and prospects. You'll turn benefits plan data into useful insight, support plan design decisions, and help clients understand plan performance through clear reporting.

How you'll make an impact

• You'll analyze benefits plan data to identify population risk, financial trends, and utilization patterns. Using predictive modeling tools, you'll help prepare financial forecasts and build databases, data collection systems, and analytics processes that improve efficiency and quality.
• You'll also support sales and prospecting efforts in the Large Group Practice. That includes presenting plan performance reports to clients on a scheduled basis, reviewing current product results, looking at market options, and sharing customer experience insights.
• You'll work with clients and colleagues to set clear timelines and keep work moving. The role includes travel of up to 10%, with client and prospect meetings, plus time in the office for planning, preparation, and training as needed.

About you

You'll need:

• A bachelor's degree and 5 years of related experience.
• Advanced English level.
• An understanding of the main challenges in employee benefit plans and current health care trends
• Experience building client relationships and presenting information clearly in meetings or presentations
• Experience with analytics tools, predictive modeling, databases, or data collection systems
• The ability to manage several projects at once while keeping work accurate and on time
• Problem solving skills that help you find and fix issues quickly
• 2 to 3 years of brokerage or agency experience, which is preferred