Consultant for the Development of the Campaign Information Management System(CIMS)

MCD Global Health; Augusta (ME); On-site; USD 90,000 - 130,000; Full time

Job summary

MCD Global Health seeks a consultant to consolidate data systems for PALU and the Bioko Island malaria program. The consultant will evaluate Databricks versus existing pipelines, set up a Databricks model using PALU data, and test connectors to external sources as part of a broader modernization effort.

The engagement covers cost-benefit analysis, governance considerations, and localization requirements, with a two-month pilot aligned to MCD's budget year and a plan for potential extension.

Qualifications

• Experience with data warehouses and analytics platforms.
• Ability to assess and compare data stack options for consolidation.
• Experience drafting cost-benefit analyses for data platforms.

Responsibilities

• Databricks assessment and pilot using PALU data and existing AWS environment.
• Set up a small Databricks data model with sample PALU data to estimate compute, storage, and licensing costs.
• Configure connectors to external data sources to test population of a data warehouse.
• Prepare a cost-benefit analysis covering direct costs, staffing, skills, and risks of adoption or non-adoption.
• Draft future plans addressing data interoperability, governance, and localization requirements.

Skills

Databricks

AWS hosting

Data modeling

CI/CD

PostgreSQL

Data governance

Tools

GitLab

Databricks

PostgreSQL

Job description

Our Vision & Mission

We envision a world in which all people have access to high quality and enduring solutions to improve and maintain their health and well-being. MCD aspires to be a premier partner of choice and an internationally recognized leader, innovator, and trusted partner in applied, cross-national public health solutions. Our mission is to improve the health and well-being of people worldwide through enduring, high-quality, cost-effective, and universally accessible public health solutions.

About the Position

The Bioko Island Malaria Elimination Project (BIMEP) is a 22 year partnership between the Government of Equatorial Guinea, oil sector partners and MCD Global Health, working toward malaria elimination under the Vice President's Vision 2030 strategy. The Ministry of Health leads the effort through the National Malaria Control Program, and MCD Global Health serves as implementing partner and operational coordinator. The 2026 to 2030 phase extends program activities from Bioko Island to mainland Equatorial Guinea and Annobón Island. The Campaign Information Management System (CIMS) is a proprietary MCD platform that holds the programmatic data for BIMEP field interventions, including indoor residual spraying (IRS), MILD distribution, larval source management and malaria indicator surveys. It is the data backbone of the spatial decision support system that plans and directs field interventions in Equatorial Guinea, combining geographic information with field data reported during each campaign so that managers can monitor coverage and redirect teams while activities are under way. PALU carries out MCD's analytical work across MCD’s international program. Its processes include automated reports, data models built with dbt, and scheduled extraction of data from external sources such as DHIS2. These processes developed over several years on different servers and tools. With fewer systems now in use, MCD intends to consolidate them on a smaller, documented and less costly architecture built on GitLab for version control and continuous integration and deployment (CI/CD), AWS for hosting, and possibly Databricks as a unified data warehouse.

MCD seeks a consultant

MCD seeks a consultant to carry out this consolidation through three deliverable areas, and to provide maintenance and technical support for the systems as they are put in place. The consultant will work within the existing team under the technical direction of the Digital Health Tools and Systems Lead. The work should leave PALU and digital health staff able to operate, modify and extend these systems without outside help. This consultancy is a two-month pilot running from November to December 2026, aligned with MCD's budget year. It tests the working arrangement and the fit between the consultant, the tools and the team. If the pilot goes well, MCD expects to extend the engagement in 2027 for further CIMS development and continued maintenance.

Key Responsibilities

• Databricks Assessment and PilotAssess Databricks against PALU's current and expected data warehouse needs and against the requirements of active projects, including comparison with the PostgreSQL environment MCD already runs on AWS.
• Set up and configure a small data model in Databricks, using a representative subset of PALU data, to estimate compute, storage and licensing costs under realistic use.
• Configure connectors to the priority external data sources agreed with PALU, to test how a data warehouse would be populated and kept current.
• Prepare a cost benefit analysis for MCD PALU covering direct costs, staff time, skills required, and the risks of adopting and of not adopting the platform.
• Draft plans for future projects, addressing complex data interoperability and data governance and localization requirements, including where data must be stored and who controls