FP&A Manager

About the role

Addi is looking for an FP&A Manager to spearhead the financial planning and analysis function for its banking operations within Colombia. This position involves constructing sophisticated forward-looking models covering capital adequacy, liquidity positions, and earnings projections to empower executive decision-making during a period of rapid scaling. The successful candidate will act as a strategic partner to the CFO, translating complex regulatory and accounting dynamics into clear, actionable financial intelligence. You will own the financial architecture that supports the company's expansion into broader financial services, ensuring rigor and accuracy across all planning cycles.

Key facts

What you'll do

• Design, build, and perpetually refine a fully integrated three-statement financial model encompassing the income statement, balance sheet, and cash flow statement across every legal entity within the group structure.
• Embed Colombian regulatory capital frameworks - specifically encaje (reserve requirements), solvencia (solvency margins), and IRL (Liquidity Risk Indicator) - directly into the forecasting infrastructure to guarantee alignment with Superintendencia Financiera de Colombia (SFC) reporting mandates.
• Architect a reconciliation methodology that bridges local NIIF standards, IFRS 9 expected credit loss provisions, and internal management reporting views to precisely track provision variances and their associated tax effects.
• Produce comprehensive monthly base-case and stressed downside scenario analyses that directly inform capital allocation strategies and strategic discussions led by the Chief Financial Officer.
• Drive a targeted 20 percent reduction in the monthly forecasting cycle duration by implementing automation workflows, optimizing model architecture, and eliminating manual data manipulation bottlenecks.
• Consolidate financial results across multiple subsidiaries, managing complex intercompany eliminations, currency translation adjustments, and pro-forma modeling for potential corporate development activities such as mergers, acquisitions, or spin-offs.
• Partner with the Accounting and Treasury teams to validate the integrity of data feeds flowing into the planning models, ensuring that portfolio origination, repayment behavior, and funding costs are reflected with high fidelity.
• Develop dynamic dashboards and narrative reporting packages that articulate key drivers of Net Interest Margin (NIM), Cost of Risk, and Operating Efficiency ratios for the Board and leadership team.
• Lead the annual budgeting process and quarterly re-forecasting cycles, coordinating inputs from commercial, risk, product, and operations stakeholders to ensure bottom-up accuracy meets top-down targets.
• Monitor and model the impact of evolving Colombian tax legislation on the group's effective tax rate, specifically focusing on the deductibility of loan loss provisions and the recoverability of Deferred Tax Assets (DTAs).
• Establish a continuous improvement roadmap for the FP&A toolkit, evaluating and implementing planning software (e.g., Anaplan, Pigment, or advanced Excel/VBA/Python solutions) to replace legacy spreadsheet processes.
• Serve as the primary financial modeling subject matter expert, mentoring junior analysts and upskilling the broader finance team on advanced modeling techniques and regulatory nuance.

Requirements

• Demonstrated expertise constructing dynamic three-statement models where shifts in loan portfolio assumptions - such as origination volume, pricing, prepayment speeds, or credit losses - automatically cascade into correct accounting entries and cash flow movements.
• Deep, practical mastery of Colombian banking regulatory capital mechanics, including the ability to independently forecast Solvencia ratios, IRL liquidity coverage, and CEFEN (Foreign Exchange Position) constraints under varying macroeconomic scenarios.
• Hands-on experience modeling intricate tax dynamics specific to the Colombian financial sector, particularly the interplay between provision deductibility rules, presumptive income vs. ordinary income mechanics, and the strategic optimization of Deferred Tax Asset recognition and recoverability.
• Proven track record managing multi-entity consolidation processes, including complex intercompany eliminations, push-down accounting adjustments, and the construction of pro-forma combined financial statements for M&A due diligence or restructuring scenarios.
• Technical fluency in bridging the gap between local statutory reporting requirements dictated by the SFC (NIIF Colombia) and group-level consolidation under full IFRS, specifically regarding classification, measurement, and impairment differences under IFRS 9.
• Exceptional analytical synthesis skills, capable of distilling dense financial trade-offs - such as the tension between asset growth, capital consumption, and ROE - into crisp, decision-ready recommendations for C-suite leadership.
• Advanced proficiency in Excel (Power Query, Power Pivot, complex array formulas, LAMBDA functions) and experience with at least one modern FP&A platform or programming language (Python/R/SQL) for data wrangling and automation.
• Minimum of 5 to 7 years of progressive experience in FP&A, strategic finance, or equity research within a banking, fintech, or regulated financial services environment, with significant exposure to emerging market regulatory regimes.

Nice to have

• Direct prior experience working within a Colombian entity supervised by the SFC (e.g., a bank, financing company, or large fintech) managing the regulatory reporting calendar (Formularios 100, 408, 504, etc.).
• Familiarity with core banking systems or loan management platforms (such as Mambu, Temenos, or proprietary ledgers) to understand data lineage from transaction level to trial balance.
• Experience designing and implementing driver-based planning models that link commercial KPIs (CAC, LTV, conversion funnels) directly to financial outputs.
• Background in venture-backed or high-growth technology environments where planning horizons shift rapidly and ambiguity is the norm.
• CFA Charterholder designation or active candidacy, or relevant local certifications (e.g., Contador Público with specialization in IFRS/NIIF).
• Fluency in English for communication with regional leadership and international investors, alongside native-level Spanish proficiency.

Skills & tools

• Three-statement financial modeling (P&L, Balance Sheet, Cash Flow) with dynamic circularity handling
• Colombian regulatory reporting & compliance (SFC Forms, NIIF Colombia, Encaje, Solvencia, IRL, CEFEN)
• IFRS 9 / NIIF 9 Expected Credit Loss (ECL) modeling and staging logic
• Capital planning, stress testing (ICAAP-style), and scenario analysis
• Multi-entity consolidation, intercompany eliminations, and pro-forma M&A modeling
• Colombian corporate tax modeling (Presumptive Income, Provision Deductibility, DTA/DTL management)
• Advanced Excel (Power Query, LAMBDA, Dynamic Arrays) & Modern FP&A Platforms (Pigment, Anaplan, Adaptive, or equivalent)
• SQL / Python / R for data extraction, transformation, and automation
• Data visualization & executive reporting (Tableau, Power BI, Looker)

Practical notes

The selection process is structured across four distinct stages: an initial 30-minute screening conversation with a Talent Acquisition specialist to assess cultural alignment and baseline qualifications; a 60-minute technical deep-dive with the Accounting Manager focusing on modeling proficiency, regulatory knowledge, and consolidation mechanics; a comprehensive 3-to-5 day take-home case study requiring the candidate to build a mini three-statement model incorporating Colombian regulatory constraints and present findings; and a final strategic discussion with a Co-Founder to evaluate long-term vision and lead