Revenue Forecasting & Analytics 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

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.