ZAMBIA: Financial & Data Analyst (Lusaka)

Position Title:

Financial & Data Analyst

Reports To:

Chief Financial Officer

Direct Reports:

None

Department:

Finance

The Company

Solar Panda is a Canadian high-growth, clean-tech company providing innovative solar power systems for lighting and TV to rural communities in Kenya, Zambia, Senegal and Benin. Our loan-to-own model allows homes to have electricity for less than the daily cost of kerosene and mobile phone charging.

Job Overview

The Financial & Data Analyst is a hybrid role that bridges the Finance and Operations functions of the organization. Sitting within the Finance team and reporting directly to the CFO, this position combines the rigour of financial planning and 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.

Duties and responsibilities

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.

Qualifications & Experience

• 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

More about Solar Panda

The company places a high priority on personal integrity, hard work, and respect for customers and co-workers.

Solar Panda is an equal opportunity employer. All qualified applicants will be considered without regard to race, religion, ethnicity, sex, disability, or any other characteristic protected by applicable laws and regulations. Applications from women are strongly encouraged.

Solar Panda does not charge any recruitment fees.