Consultant -Data Systems & ETL Development

Join to apply for the Consultant - Data Systems & ETL Development role at Mercy Corps.

Project

Title:

Data Systems & ETL Development Consultant

Location:

Remote

Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, hardship, and more than 40 countries around the world we partner to put bold solutions into action – helping people triumph over adversity and build stronger communities from within.

Gaza Sky Geeks is Gaza’s first and only innovation hub and start‑up accelerator, run by Mercy Corps. Mercy Corps founded GSG in partnership with Google.org in 2011 with an aim to transform Gaza’s most talented youth into the Middle East’s technology business leaders and to realize Gaza’s potential as a start‑up hub. In 2017 GSG has grown to include the West Bank under its wing.

Purpose / Project

Description:

Gaza Sky Geeks has multiple components – individuals, companies and community. Each component generates data, and we need support to work on this data through activities such as data cleaning.

• Extract and translate program log frames and budgets into structured data requirements
• Work closely with a third‑party consultant to support the design and implementation of a scalable, integrated database architecture covering all GSG functionalities
• Contribute to discovery sessions, implementation phases, and onboarding to ensure alignment with GSG’s data needs
• Establish a data warehouse and ETL pipelines to support automated and real‑time reporting
• Strengthen GSG’s overall data systems to improve analytics, organizational learning, and reporting

• Extract data requirements from GSG logframes, budgets, and reporting frameworks
• Conduct comprehensive requirements-gathering sessions with all relevant GSG team members and program leads
• Design a robust database architecture that covers all GSG programs, components, and functionalities
• Develop and document a data warehouse structure to consolidate program, MEL, and operational data
• Create and implement ETL (Extract, Transform, Load) pipelines to support the data warehouse and enable real-time or near real-time data updates
• Ensure data quality, integrity, and consistency across systems
• Build and maintain real-time and automated reports and dashboards to support internal management, partners, and donors
• Work closely with program, MEL, and management teams to identify learning opportunities through advanced data analytics and deep dives
• Support system testing, validation, and refinement based on user feedback
• Provide technical documentation, guidance, and knowledge transfer to relevant GSG staff
• Support other related data analysis, system enhancement, and MEL activities as needed
• Provide relevant training, presentations, and manuals as required to the program team to ensure accurate and precise data management protocol
• Support in other related data analysis, quality assurance, and MEL activities as needed

• A documented extraction of data requirements from GSG logframes and budgets
• A comprehensive database design that supports all GSG programs and functionalities
• A fully defined and documented data warehouse structure
• Functional ETL pipelines to populate and maintain the data warehouse
• Real-time or automated dashboards and reports (e.g., Power BI) reflecting GSG program data
• Technical documentation, including system architecture diagrams and data flow descriptions
• An action plan for future enhancements and sustainability of the GSG data system

Timeframe /

Schedule:

Jan 27th, 2026 – July 17th, 2026.

The Consultant will report to:
Leyan Zahdeh – Tech Unit Officer.

The Consultant will work closely with:

• Optional – TSU, Program Desk Officers, Program Manager
• GSG Director, GSG Sr. Program Manager, GSG Program Manager, GSG Data & Learning Coordinator

• Bachelor's degree in a relevant field such as Data Science, Statistics, Mathematics, Science, or Computer Science
• At least five years of work experience in a relevant field. Experience in MEL or a highly organized role in other fields will be of value
• Proficiency in data management and analysis tools such as Power BI,…