The MEL Data Science Officer is part of the Global MEL team and strengthens Orbis’s Monitoring, Evaluation and Learning (MEL) systems through data engineering, analytics, automation, and data governance. The Officer supports the integration of MEL data across systems and countries, enabling accurate, timely and actionable program performance information. The role enhances Orbis’s global data infrastructure and strengthens the organization’s ability to use data for decision-making, accountability and learning.
JOB SUMMARY
The MEL Data Science Officer supports Orbis’s global MEL function by designing and maintaining data pipelines, automated reporting systems, and analytical solutions that enhance MEL data quality, accessibility, and interoperability. This role builds standardized data models, maintains Dataverse structures, implements ETL processes, and develops Power BI dashboards that support monitoring, reporting and performance analysis across Orbis’s global programs.
This is a hands-on technical role requiring expertise in Power BI, Dataverse, SQL, Python, Azure Synapse, Power Automate, and data engineering. The Officer collaborates with MEL teams, program teams and the IS/IT unit to ensure that MEL data systems are reliable, efficient, and aligned with global reporting requirements. This role does not supervise staff but provides high-level technical support, training and troubleshooting to MEL stakeholders globally.
REPORTING & WORKING RELATIONSHIPS
The MEL Data Science Officer reports to the Advisor, Data Insights and Solutions (Global MEL) and collaborates closely with:
• Global MEL Team
• IS/IT Team
• Country MEL Officers and Program Teams
• Other data users across Global Programs
ESSENTIAL JOB FUNCTIONS / KEY AREAS OF RESPONSIBILITY
1. Data Architecture, Engineering & Integration
- Design, document and maintain scalable data pipelines connecting MEL datasets across Spectrum, Dataverse, Azure Synapse and other systems.
- Develop standardized MEL data models and schema aligned with Orbis’s global indicators and results frameworks.
- Implement ETL/ELT processes using SQL, Python, Azure Synapse, Databricks and Data Lake.
- Maintain Dataverse tables, relationships, business rules and security structures for MEL data.
- Apply data governance practices including version control, documentation, validation scripts and audit trails.
- Collaborate with IT/IS teams to ensure secure, reliable data architecture and interoperability between systems.
2. Data Automation, Quality Assurance & Optimization
- Conduct routine data validation, completeness checks and integrity assessments within MEL systems.
- Develop automated scripts and routines (SQL, Python, DAX, VBA) to support MEL reporting and anomaly detection.
- Build Power Automate workflows, AI Builder models and automation pipelines that streamline MEL processes.
- Maintain metadata documentation, data dictionaries and SOPs to enhance data transparency and traceability.
- Monitor and optimize data refresh cycles in Dataverse and Power BI.
- Support predictive analytics or AI-assisted MEL use cases where appropriate.
3. Data Visualization, Dashboards & Reporting
- Design, build and maintain Power BI dashboards for monitoring program performance, indicators and outcomes.
- Implement advanced dashboard features including role-level security, drill-through functionality, advanced DAX, and optimized data models.
- Develop standardized visualization templates for quarterly and annual MEL reporting.
- Ensure accuracy, consistency and usability of dashboard outputs through rigorous validation.
- Troubleshoot dashboard performance and refresh issues across multiple countries and teams.
4. Stakeholder Collaboration, Technical Support & Capacity Building
- Provide hands-on technical support to MEL and country teams on data extraction, dashboard use, indicator mapping and system navigation.
- Conduct training sessions on Power BI, Dataverse, SQL, and MEL data workflows for MEL officers and program teams.
- Troubleshoot user issues and provide timely technical assistance to ensure smooth tool adoption.
- Collaborate with program and MEL teams to co-create tailored analytical solutions.
- Support MEL learning initiatives by preparing data-driven insights, visualizations and performance summaries.
QUALIFICATIONS & EXPERIENCE
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, Statistics, or related technical field.
- 4–7 years of experience in data engineering, analytics, automation or enterprise systems integration.
- Proven hands-on experience with Power BI, Power Automate, Dataverse, Power Apps and the Microsoft Power Platform.
- Strong expertise in SQL, Python, ETL design, data modeling and data warehousing.
- Experience with Azure ecosystem (Azure Synapse, Data Lake, Azure Functions, Azure Storage).
- Familiarity with data governance, data validation, metadata management and API integrations.
- Experience developing automated reporting systems and dashboards supporting program monitoring.
- Experience working with global health, development or multi-country program data is an advantage.
- Strong communication skills in English.
SKILLS & ABILITIES
- Strong foundation in data engineering, ETL pipelines and cloud integration.
- Advanced proficiency in Power BI, DAX, and interactive dashboard development.
- Ability to translate complex technical concepts into easy-to-use dashboards and tools.
- High attention to detail, accuracy and data integrity.
- Strong analytical and diagnostic problem-solving skills.
- Ability to work collaboratively with technical and non-technical teams across regions.
- Proactive and solutions-focused, with the ability to manage multiple priorities.
- Enthusiasm for emerging technologies, automation and continuous improvement.
- Ability to support and train global teams with varying levels of data literacy.
To learn more about Orbis, go to http://www.orbis.org
Orbis is an Equal Opportunity Employer.
As a global organization, we welcome qualified applicants from diverse backgrounds, cultures, and marginalized communities who are underrepresented in the international NGO sector who reflect the five Orbis values of Accountability, Commitment, Innovation, Integrity and Equity.
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
