Financial Planning Analyst

Vintti; Bogotá, Distrito Capital; On-site; COP 223,200 - 334,800; Full time

Job summary

A finance consulting firm is seeking an entry-level Financial Planning & Analysis Analyst in Bogotá. This role involves supporting financial reporting processes and maintaining financial models. The ideal candidate is a strong Excel user and a self-starter, thriving in a fast-paced environment. This position offers significant growth opportunities in financial planning and analysis.

Qualifications

• Experience with financial planning and analysis.
• Ability to produce accurate financial reports.
• Familiarity with project management tools is a plus.

Responsibilities

• Update and maintain financial models.
• Prepare weekly and monthly reports.
• Collaborate with finance teams on cash flow forecasting.

Skills

Advanced Excel skills

Attention to detail

Communication skills

Self-starter

Capacity to work independently

Tools

Planful

NetSuite

ERP systems

Asana

Job description

Position: Financial Planning & Analysis (FP&A)

Working Schedule: aligned with US time zone

Overview

We are seeking a detail-oriented and ambitious FP&A Analyst to join the finance team of one of our clients. This role will be critical in supporting weekly, monthly, and quarterly reporting processes, ensuring data accuracy, and maintaining financial models that guide decision-making across the organization. The ideal candidate is a strong Excel user, a self-starter, and someone who thrives in a fast-paced, feedback-driven environment. This position offers significant growth opportunities for individuals looking to expand their expertise in financial planning and analysis.

Responsibilities

• Update and maintain the cash model, ensuring alignment to the correct week.
• Import transaction data and refresh Planful data inflows.
• Prepare weekly Capex reports for project management discussions.
• Refresh overhead reports by class and accounts, ensuring accuracy for departmental and roll-up reporting.
• Adjust Planful templates as required to ensure proper data inflows.
• Update and distribute the project financial performance Excel file for the operations team.
• Update monthly fuel costs Excel and PowerPoint reports for review with the energy team.
• Maintain Planful statistical accounts (mileage, vehicles under management, billings, headcount, debt & leases) and upload to Planful.
• Prepare Capex forecast reports, comparing project-level capex across current and prior forecasts.
• Perform reconciliations and ensure data cleanliness across systems.
• Deliver timely, high-quality reports.
• Collaborate with the FP&A team to support near-term cash flow forecasting, long-term planning, and treasury functions.
• Take ownership of assigned tasks and progressively expand responsibilities from data entry and reporting to analysis and independent report generation.
• Demonstrate Advanced Excel skills (data manipulation, pivot tables, complex formulas, report building).
• Maintain strong attention to detail and accuracy in manual data processes.
• Be a self-starter with an ambitious mindset, capable of working independently.
• Deliver work on time and meet deadlines in a fast-paced environment.
• Exhibit strong communication skills and openness to feedback.
• Experience with Planful (or willingness to learn quickly).
• Familiarity with NetSuite (planning and budgeting).
• Experience with Essbase or Smart View.
• Exposure to ERP or project-based financial systems.
• Experience with project management tools such as Asana or similar platforms.

Details

• Seniority level: Entry level
• Employment type: Full-time
• Job function: Finance
• Industries: Transportation Programs and Services for Renewable Energy