FP&A Analyst

Arthur J. Gallagher & Co. (AJG); Medellín; Presencial; COP 89.280.000 - 133.920.000; Jornada completa

Descripción de la vacante

Gallagher is seeking a forecast-focused finance professional in Medellín to coordinate revenue updates and support the monthly forecasting cycle. You will reconcile data from broker and operational systems, prepare commentary for leaders, and assist with SOX controls and audit evidence collection.

You will work across MGA, Programs, GP&P, and G-21 lines, maintaining revenue details and performing ad hoc analytics to support the wider finance team.

Formación

• Bachelor’s degree in finance, accounting, or a related field.
• Advanced English is required.
• 2–5 years of experience in financial services or insurance operations.
• Experience in revenue management, budgeting, forecasting, or financial analysis is preferred.
• Experience with OneStream, Excel forecasts, and revenue reporting tools.
• Ability to review data, explain variances clearly in English.

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

Advanced English

OneStream

Excel

Educación

Bachelor's degree in Finance/Accounting

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.