Job Title: Financial & Data Analyst

Job Location: Lusaka, Zambia

Company Name: Solar Panda Zambia

Job Overview: The Financial & Data Analyst is a hybrid role that bridges the Finance and Operations functions of the organisation. Sitting within the Finance team and reporting directly to the CFO, this position combines the rigour of financial planning & analysis (FP&A) with the capability of a data analyst to deliver actionable, data-driven insights across the business.

A core element of this role is the development and maintenance of dashboards and reports that serve all Country Managers, enabling regional leadership to monitor both financial performance and operational KPIs in real time. The successful candidate will be a confident communicator who can translate complex data into clear business narratives.

Job Description:

Financial Planning & Analytics

• Lead the preparation of monthly, quarterly, and annual financial reports including variance analysis against budget and forecast.
• Conduct profitability analysis, cost modelling, and scenario planning to support strategic business decisions.
• Monitor financial performance against KPIs and highlight risks and opportunities to the CFO on a regular basis.
• Prepare executive-level financial summaries, board packs, and CFO presentations.

• Develop and manage advanced Excel models for financial forecasting, data manipulation, and scenario analysis.

• Support the business on ad-hoc requests and stakeholder inquiries

Operational Analytics & Country Support

• Partner with Country Managers to understand their reporting needs and develop bespoke dashboards that track operational and financial KPIs relevant to each market.
• Design, build, and maintain Power BI dashboards and reports for finance and commercial use, with a focus on accessibility for Country Managers across all regions.
• Establish standardised reporting frameworks that can be applied consistently across countries and business units.
• Act as a trusted analytics partner to country leadership, providing ad hoc analysis and insights to support local decision-making.
• Facilitate cross-country benchmarking and identify best practices through data comparison.

Qualification & Experience Required:

• Bachelor’s Degree in Accounting, Statistics, Data  Science or a similar field

• Minimum of 5 years’ experience in data analytics, or FP&A roles, preferably within solar industry

• Advanced proficiency in Microsoft Excel (pivot tables, complex formulas, Power Query, financial modelling).
• Demonstrated expertise in Power BI including dashboard development. Experience with DAX, SQL, Python, and other data analysis tools would be a plus

• Attention to detail and data accuracy; Curious and commercially minded