Financial & Data Analyst
Pavago View all jobs
- Kenya
- Permanent
- Full-time
- Build and maintain 3-statement models (P&L, balance sheet, cash flow).
- Create scenario and sensitivity analyses to evaluate risks and opportunities.
- Model ROI, IRR, break-even, and valuation scenarios for projects or investments.
- Query SQL databases and work with large datasets.
- Clean and transform data using Python, R, or Excel advanced functions.
- Conduct variance analyses to compare actuals vs. budgets/forecasts.
- Prepare monthly management reporting packages and board decks.
- Build KPI dashboards using Tableau, Power BI, or Looker.
- Ensure consistent reporting definitions across finance and operations.
- Collaborate with FP&A teams to refine budgets and forecasts.
- Incorporate real-time business performance into rolling forecasts.
- Validate data sources for accuracy and consistency.
- Document methodologies for transparency and repeatability.
- Partner with finance, sales, operations, and leadership to align metrics with goals.
- Translate data into clear, actionable insights for non-technical stakeholders.
- Analytical thinker who can turn complex data into simple insights.
- Detail-oriented, with high standards for accuracy.
- Strong communicator — equally comfortable with spreadsheets and executive presentations.
- Proactive in identifying trends, risks, and improvement opportunities.
- 2+ years in financial analysis, FP&A, or data analytics.
- Advanced Excel/Google Sheets (pivot tables, INDEX/MATCH, macros).
- Proficiency in SQL for querying and joining datasets.
- Experience preparing variance analyses and management reports.
- Python or R for advanced analytics and data modeling.
- Experience with BI tools (Tableau, Power BI, Looker).
- Industry background in SaaS, finance, healthcare, or professional services.
- Familiarity with ERP systems (NetSuite, SAP, Oracle) for data extraction.
- Pull and clean data from ERP or SQL sources to prepare daily/weekly reports.
- Update financial models with the latest actuals and run scenario analyses.
- Prepare variance analyses to explain deviations from budget or forecast.
- Build dashboards in BI tools to give leadership real-time visibility into KPIs.
- Collaborate with stakeholders, presenting findings in clear, actionable terms.
- Document assumptions and methodologies so models and analyses are transparent and repeatable.
- Accuracy of forecasts and financial models (variance within ±5–10%).
- Timeliness of monthly/quarterly reporting.
- Reliability and clarity of dashboards delivered to stakeholders.
- Positive feedback from leadership on insights and recommendations.
- Reduced errors and improved data quality across reports.
- Video Interview with Pavago Recruiter
- Practical Task (e.g., build a simple financial model or create a sample dashboard from dataset)
- Client Interview with Finance/Operations Leadership
- Offer & Background Verification