FP&A Analyst

Arthur J. Gallagher & Co. (AJG); Bogotá; Presencial; COP 42.000.000 - 66.000.000; Jornada completa

Descripción de la vacante

Arthur J. Gallagher & Co. is seeking a finance professional to coordinate forecast submissions, reconcile data from broker and operational systems, and support the monthly forecasting cycle.

You will review variances, prepare commentary for leadership, assist SOX controls and audit evidence collection, and maintain revenue details for internal reports across MGA, Programs, GP&P, and G-21 business lines.

Formación

• Bachelor’s degree in finance, accounting, or related field.
• Advanced English is required.
• 2–5 years of experience in financial services or insurance operations.
• Background includes revenue management, accounting operations, budgeting, forecasting, or financial analysis.
• Experience with OneStream, Excel forecasts, and revenue reporting tools.
• Ability to review data, spot issues, and explain variances clearly in English.
• Comfortable supporting controls, audit requests, and detailed reporting tasks.

Responsabilidades

• Coordinate revenue updates, reconciling projections and validating data from operational and broker systems.
• Prepare forecasts and maintain uploads in OneStream and Excel.
• Monitor revenue performance, review variances, and recommend corrective actions.
• Prepare variance analysis and commentary for leadership.
• Support SOX controls, exception monitoring, and audit evidence collection.
• Maintain revenue information for internal reports and ad hoc analysis.
• Support the calculation and proper allocation of revenue share across different business lines.

Conocimientos

Forecasting

Data reconciliation

Variance analysis

Financial analysis

English proficiency

SOX controls

Educación

Bachelor's degree in finance

Herramientas

OneStream

Excel

Descripción del empleo

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

You’ll help keep revenue updates on track by coordinating forecast submissions, reconciling data from broker and operational systems, and supporting the monthly and ongoing forecasting cycle. You’ll also review variances, investigate forecast issues, and prepare commentary that helps leaders understand performance and next steps.

Alongside forecasting, you’ll support SOX controls, exception monitoring, and audit evidence collection. You’ll also help maintain revenue details for shadow reporting across MGA, Programs, GP&P, and G-21 business lines, along with revenue share calculations and ad hoc analytics that support the wider finance team.

How you'll make an impact

• Coordinate revenue updates, reconciling projections and validating data from operational and broker systems.


• Prepare forecasts and maintain uploads in OneStream and Excel.


• Monitor revenue performance, review variances, and recommend corrective actions.


• Prepare variance analysis and commentary for leadership.


• Support SOX controls, exception monitoring, and audit evidence collection.


• Maintain revenue information for internal reports and ad hoc analysis.


• Support the calculation and proper allocation of revenue share across different business lines.

About you

• You have a bachelor’s degree in finance, accounting, or a related field.


• Advanced English is required.


• You have 2 to 5 years of experience in financial services or insurance operations.


• Your background includes revenue management, accounting operations, budgeting, forecasting, or financial analysis.


• You can work with OneStream, Excel forecasts, and revenue reporting tools.


• You can review data, spot issues, and explain variances clearly in English.


• You are comfortable supporting controls, audit requests, and detailed reporting tasks.