Consultant Development Campaign Information Management System; CIMS

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.

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 DHIS
2. 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 Git Lab 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 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.

• Databricks Assessment and Pilot Assess 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