The Regional Business Intelligence Analyst will be responsible for the collection, review, and analysis of agriculture finance portfolio and client data from financial institution partners. The role will involve managing a process of data collection and vetting, database management, and the development and presentation of the data in PowerBI.

RESPONSIBILITIES include the following. Other duties may be assigned.

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.

  ABOUT OPPORTUNITY INTERNATIONAL

  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.

  Learn more about our company by visiting our website: https://opportunity.org/

  ABOUT AGFINANCE

  Opportunity’s AgFinance model is structured to bring scalable and high-impact loans and training to rural families living in poverty to build thriving rural communities. AgFinance accomplishes this by building relationships with financial institutions to support the provision of tailored agricultural credit products and services to smallholders and agribusinesses while providing technology-enabled training and services directly to farmers.