Consultant -Data Systems & ETL Development
Description
Project/Consultancy Title: Data Systems & ETL Development Consultant
Project Location: Remote
Background:
Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, in hardship, in 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, Gaza Sky Geeks has grown to include the West Bank
under its wing.
Purpose / Project Description:
Gaza Sky Geeks has multiple components, i.e., individuals, companies, and community. All these components have their own data based on the work they accomplish, and we need help in working on this data with activities such as data cleaning.
Consultant Objectives:
● 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
Consultant Activities:
The Consultant will:
● 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
Consultant Deliverables:
The Consultant will:
● 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
Jan 27th, 2026– July 17th, 2026
The Consultant will report to:
Leyan Zahdeh – Tech Unit Officer
Optional – E.g. TSU, Program Desk Officers, Program Manager
GSG Director , GSG Sr.Program Manager , GSG Program Manager, GSG Data and 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, Microsoft Azure, Microsoft Excel, etc.
● Ability to run online surveys to collect data, then operate the ETL process to extract, transform, and load into SQL Server databases in the cloud
● Ability to conduct in-depth data analytics and generate actionable insights, with significant experience in quantitative and qualitative data analysis
● Experience in presenting data analysis to senior management and external stakeholders, both written and verbal, as well as areas of learning and improvement
● Ability to ensure efficient, effective, and timely data collection processes
● Strong English communication skills to ensure information flows effectively with international staff and project stakeholders
● Understanding of MEL principles and guidelines, especially those set by Mercy Corps and large government donors.
Achieving our mission begins with how we build our team and work together. Through our commitment to enriching our organization with people of different origins, beliefs, backgrounds, and ways of thinking, we are better able to leverage the collective power of our teams and solve the world’s most complex challenges. We strive for a culture of trust and respect, where everyone
contributes their perspectives and authentic selves, reaches their potential as individuals and teams, and collaborates to do the best work of their lives.
Equal Employment Opportunity
We are committed to providing an environment of respect and psychological safety where equal employment opportunities are available to all. We do not engage in or tolerate discrimination on the basis of race, color, gender identity, gender expression, religion, age, sexual orientation, national or ethnic origin, disability (including HIV/AIDS status), marital status, military veteran status or any other protected group in the locations where we work.
Safeguarding & Ethics
Mercy Corps team members are expected to support all efforts toward accountability, specifically to our stakeholders and to international standards guiding international relief and development work, while actively engaging communities as equal partners in the design, monitoring and evaluation of our field projects. Team members are expected to conduct themselves in a professional manner and respect local laws, customs and MC's policies, procedures, and values at all times and in all in-country venues