Apply on Employer Site

Mercy Corps · 15 hours ago

Consultant -Data Systems & ETL Development

United States

Full-time

Remote

Senior Level

5+ years exp

Mercy Corps is a leading global organization focused on creating a better world through innovative solutions. The Data Systems & ETL Development Consultant will work on extracting and structuring data requirements, establishing a data warehouse, and developing ETL pipelines to enhance data analytics and reporting for Gaza Sky Geeks.

AssociationNon Profit

Responsibilities

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

Qualification

Data managementETL processesDatabase architecturePower BISQL ServerData analysisMEL principlesCommunication skills

Required

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