Revenue Forecasting & Analytics Analyst

Arthur J. Gallagher & Co. (AJG); Medellín; On-site; COP 89,280,000 - 133,920,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Advanced English

OneStream

Excel

Education

Bachelor's degree in Finance/Accounting

Tools

OneStream

Excel

Job description

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.