Strategic Revenue FP&A Analyst — Forecasting & Insights

Arthur J. Gallagher & Co. (AJG); Bogotá; On-site; COP 42,000,000 - 66,000,000; Full time

Job summary

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.

Qualifications

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

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

Forecasting

Data reconciliation

Variance analysis

Financial analysis

English proficiency

SOX controls

Education

Bachelor's degree in finance

Tools

OneStream

Excel

Job description

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.