Consultant -Data Systems & ETL Development

Mercy Corps

10d•Remote

About The Position

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. 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.

Requirements

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.

Responsibilities

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