Data and Business Intelligence Analyst

APPLICATION PROCESS

Please submit your application using the below link:

https://forms.gle/oXrB5FazcomNgDt29

Please note, any applications not submitted via the above form cannot be considered. Applications are reviewed on a rolling basis.

POSITION SUMMARY

Data and Business Intelligence Analyst

RESPONSIBILITIES

Data

• Supervise management and maintenance of 

  data collection

   tools that are used by all EduFinance departments (EFP, Education Quality, MERL)
• E.g., Fulcrum, Google Forms, Titus, Salesforce
• Design, build and maintain 

  robust ETL pipelines

   (e.g., Azure Data Factory, Logic Apps, APIs).

• Administration

   and 

  optimization

   of the EduFinance SQL database on Microsoft Azure
• Ensure 

  high-quality

  , clean, and well-documented data pipelines and dataflows
• Implement and maintain data quality controls.
• Manage special data projects as EduFinance expands into new areas

Business Intelligence & Analytics

• Develop and maintain 

  interactive PBI

   

  dashboards and automated reporting

   tools for EFP, Education Quality, MERL

• Conduct in-depth analysis

   using SQL, Power BI, Python, and Excel to provide actionable insights to support decision-making
• Use Excel (including Power Query, PivotTables, advanced formulas, and macros where applicable) for 

  ad hoc analyses

• Present findings

   and insights to internal teams, financial institution partners, and other stakeholders in a clear and actionable manner.
• Ensure dashboards and data collection tools are accurately reflecting the status of the program
• Special projects that require data analysis for the purposes of making stronger business decisions. 

SUPERVISORY RESPONSIBILITY

• None

QUALIFICATIONS

• Undergraduate degree in data science, computer engineering, statistics, or another quantitative field required
• Minimum 3 years’ experience in 

  SQL

   development and database administration experience (Azure SQL preferred).
• Minimum 3 years’ experience building and maintaining 

  ETL

   pipelines (Azure Data Factory, Logic Apps, or similar tools).
• Proficiency with APIs and data integration methods.
• Advanced 

  Excel

   skills (Power Query, PivotTables, advanced formulas, macros a plus).
• Expertise in 

  Power BI

   (DAX, data modeling, dashboard/report design).
• Proficiency in 

  Python

   for data transformation, automation, and analysis.
• Passionate about Opportunity’s mission. Able to promote and communicate the organization’s goals and objectives to external and internal stakeholders.

Desirable skills:

• Experience with Salesforce or similar CRMs.
• Knowledge of R for advanced analysis.
• Experience with version control (Git/GitHub/Azure DevOps) and collaborative coding practices.
• Familiarity with data governance frameworks, such as GDPR compliance

LANGUAGE SKILLS

• Written and verbal fluency in English required, fluency in French or Spanish desirable but not required 

TRAVEL REQUIREMENTS

• None

ABOUT OPPORTUNITY INTERNATIONAL

Opportunity International is a global non-profit that has been empowering people to work their way out of poverty since 1971. Opportunity provides 18.7 million people with innovative financial resources, training, and support to grow their small businesses and send their children to school. In 2023, Opportunity International and its partners served 20 million clients, helped fund 7,000 schools that reached 1.9 million children, and they released more than $1.85 billion in capital across 31 countries. We respond to Jesus Christ's call to love and serve people living in poverty. We seek to emulate the Good Samaritan, whose compassion crossed ethnic groups and religions. We serve all people regardless of religion, race, ethnicity, or gender. Discover more at opportunity.org or join the conversation on Facebook, LinkedIn, and Instagram.

CHILD PROTECTION COMMITMENT

Opportunity believes that all children have a right to protection from any form of abuse regardless of gender, culture, ethnicity, age, religion, sexual orientation, or ability. Opportunity operates in line with international best practices for child protection and recognizes its responsibility to ensure that all employees. This policy applies to anyone acting on behalf of Opportunity or is involved in its programs in any capacity. All employees are subject to background checks, which include criminal checks and sex offender list checks, as allowed by local law.