Data and Business Intelligence Analyst

APPLICATION PROCESSPlease submit your application using the below link: note, any applications not submitted via the above form cannot be considered. Applications are reviewed on a rolling basis.POSITION SUMMARYThe Data and Business Intelligence Analyst will play a key role in building and maintaining EduFinance’s data infrastructure while delivering insightful analysis through Power BI and Excel. The role is a hybrid between data engineering and analytics, requiring strong technical skills in SQL, Python, and data pipelines, as well as the ability to translate data into actionable insights.RESPONSIBILITIES include the following. Other duties may be assigned.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 areasBusiness 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- NoneQUALIFICATIONS- 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 complianceLANGUAGE SKILLS- Written and verbal fluency in English required, fluency in French or Spanish desirable but not requiredTRAVEL REQUIREMENTS- NoneABOUT OPPORTUNITY INTERNATIONALOpportunity 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 COMMITMENTOpportunity 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.