Opportunity International is a global non-profit that has been empowering people to work their way out of poverty for over 50 years. Last year, Opportunity provided 18.7 million families with innovative financial resources, training, and support to grow their small businesses and send their children to school. Opportunity and its partners released $2 billion in capital across 30 countries and helped fund 8,400 schools that reached 2 million children.
RESPONSIBILITIES
Financial Institution Reporting
- Collection and vetting of AgFinance portfolio data from financial institution partners on a monthly basis.
- Validate data and gain contextual understanding through emails and/or video calls as needed with financial partners.
- Uploading partner data to reports in PowerBI, ensuring accurate visualization and dataflows.
Data Warehouse
- Support the Data Systems Analyst with an automated data extraction project for a data warehouse system under development.
- Coordinate with other teams, specifically the Client Services and Impact Measurement teams, to consolidate data for the team reports.
- Assist in mapping financial institution data to Client Services data.
Improve Data Management Systems
- Maintain and improve existing reporting systems. Audit dataflows, implement improvements, and troubleshoot any issues that arise.
- Periodically review and make recommendations for the training
QUALIFICATIONS
- Bachelor’s or Certifications demonstrating quantitative competency (Data Science, Computer Science, Economics, Finance, etc.)
- Microsoft Certification related to Data Analytics or Business Intelligence (e.g., MCSA BI Reporting, PowerBI Data Analyst)
- 3+ years of experience in data analytics and data visualization.
- Strong ability to create and manage data ETL processes in the Microsoft ecosystem, including Azure SQL, Power Query, PowerBI (including DAX), and Power Automate.
- Strong quantitative analysis skills to evaluate reports and develop strong visualization for various stakeholders.
- An understanding of and a commitment to advancing the mission and core values of Opportunity International.
LANGUAGE SKILLS
- Written and verbal fluency in English required fluency in a partner country’s local language desirable.
TRAVEL REQUIREMENTS
- May travel internationally up to 10% of the time within Africa.
Table of Contents
About Author
