Zobhira
Sign up
Posted today · be early

Consultant for the Development of the Campaign Information Management System (CI

MCD Global Health

WorldwideremotePosted today
MCD Global Health logo

Skill Required

Data-EngineerDevOps-EngineerCloud-Infrastructure-ConsultantData-Warehouse-EngineerSolutions-ArchitectCMS-ConsultantDeveloperCICI/CDDatabricksPostgreSQLanalyticalGitHub ActionswrittenGitSassdbtAWSandCDContract

Key highlights

  • At least five years of experience in DevOps, cloud infrastructure or data engineering required.
  • Technical and Financial proposals are mandatory for application consideration.
  • Degree in computer science or related field (or equivalent experience) required.
  • Strong SQL/PostgreSQL and working knowledge of Python required.
  • Two-month pilot (Nov-Dec 2026) with potential extension into 2027.
  • Clear technical writing in English is a requirement.

Role overview

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. MCD Global Health serves as the implementing partner and operational coordinator for the project, which is expanding its activities from Bioko Island to mainland Equatorial Guinea and Annobón Island. MCD seeks a consultant to consolidate its analytical systems—including the Campaign Information Management System (CIMS) and PALU analytical processes—onto a smaller, documented architecture built on GitLab for CI/CD, AWS for hosting, and potentially Databricks as a unified data warehouse. This consultancy is a two-month pilot running from November to December 2026, aligned with MCD's budget year. The role involves carrying out technical consolidation across three deliverable areas and providing maintenance and support. If the pilot is successful, MCD expects to extend the engagement into 2027 for further development and continued maintenance. The consultant will work under the technical direction of the Digital Health Tools and Systems Lead with the goal of leaving MCD staff able to operate and extend these systems independently.

Responsibilities

  • 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 access.
  • Document all configuration, test results and findings.
  • Configure pipelines, pipeline schedules and related files to automate PALU processes, including automated reports, dbt model builds, data extraction from external sources, and other automations agreed with PALU.
  • Configure a CIMS repository to handle CI/CD for the new CIMS codebase, including automated builds, version control conventions, release tagging and test stages.
  • Assist with configuring application logging for CIMS and PALU processes.
  • Address deployment dependencies with ODK Central versioning, so that CIMS releases and ODK Central upgrades can be tested and deployed together without disrupting field data collection.
  • Define and configure pipeline notifications and reporting, so that failures reach the person responsible.
  • Manage access control, including user roles, protected branches, and storage of credentials in GitLab CI/CD variables or an approved secrets manager.
  • Review the current AWS account structure, services and monthly costs, and identify resources that are idle, oversized or duplicated.
  • Explore cost saving opportunities, including reserved instances or savings plans, unifying the architecture, and moving to more appropriate technologies where they cost less to run.
  • Configure GitLab runners on AWS if required by Deliverable Area 2.
  • Modernize and streamline the deployment of MCD applications across PALU and IT, for example through containers and infrastructure as code, so that each application can be rebuilt from its repository.
  • Review and provide written feedback on draft documentation for new systems, standards and processes prepared by the MCD team.
  • Write the code required to configure the systems covered by this TOR, where this falls outside Deliverable Areas 1 to 3.
  • Provide guidance and training to relevant team members, including a handover session for each completed deliverable area.
  • Apply security patches and dependency updates, including GitLab runners and ODK Central in coordination with the CIMS team.
  • Monitor pipelines, scheduled jobs and infrastructure, and fix failures.
  • Confirm that backups run and test a restore at least once during the pilot.
  • Review AWS and, if adopted, Databricks costs each month and flag unexpected changes.
  • Keep documentation and runbooks current as systems change.
  • Triage and resolve maintenance tickets in Jira.
  • Follow MCD security and data protection requirements, including working through MCD-issued accounts, using approved systems for credentials and data, protecting confidential information, and complying with MCD’s confidentiality and data ownership requirements.
  • Track tasks and provide regular updates through Jira, meet weekly with the Digital Health Tools and Systems Lead, maintain appropriate technical documentation, and complete handover sessions so that MCD staff can maintain the systems independently.
  • Work toward the pilot milestones: onboarding and work planning in the first week of November; Databricks pilot data model and cost estimates by November 20; key outputs for all three deliverable areas by December 18; and handover sessions and the end-of-pilot report by December 31.
  • Deliver outputs on schedule and without major rework, ensure PALU automations operate as expected, identify and implement approved AWS savings, resolve maintenance requests within agreed response times, and maintain appropriate security standards throughout the engagement.

Requirements

  • Submission of a Technical Proposal and a Financial Proposal as specified in the “How to Apply” section.
  • Degree in computer science, software engineering, information systems or a related field, or equivalent professional experience.
  • At least five years of experience in DevOps, cloud infrastructure or data engineering.
  • Hands on experience configuring GitLab CI/CD, including runners, pipeline schedules and protected variables.
  • Experience administering AWS environments, including identity and access management, EC2, RDS, S3, networking and cost management.
  • Strong SQL and PostgreSQL skills and working knowledge of Python.
  • Experience with dbt and with building data pipelines from APIs.
  • Experience applying security practice in cloud environments: access control, secrets management, backup and recovery.
  • Clear technical writing in English.
  • Firms that apply must name the individual who will carry out the work.

Nice to have

  • Experience with Databricks or a comparable platform such as Snowflake or BigQuery, including cost modelling.
  • Experience with ODK Central, DHIS2 or other health information systems.
  • Experience with containers and infrastructure as code (for example Docker and Terraform).
  • Previous work supporting health programs in Africa.
  • Working knowledge of Spanish.

Benefits

  • Cloud and software license costs in MCD accounts, including Databricks usage during the pilot, are paid directly by MCD and are not part of the consultant's fees.

Additional details

  • Our Vision: 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.
  • Our Mission: To improve the health and well-being of people worldwide through enduring, high-quality, cost-effective, and universally accessible public health solutions.
  • 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.
  • CIMS Technical Context: A proprietary MCD platform holding programmatic data for BIMEP field interventions (IRS, MILD distribution, larval source management, and malaria indicator surveys); serves as the data backbone of the spatial decision support system.
  • PALU Technical Context: Processes include automated reports, data models built with dbt, and scheduled extraction of data from external sources such as DHIS2.
  • Technical Proposal Requirements (max 5 pages excluding CV): Brief approach for each deliverable area; Availability between 1 November and 31 December 2026 (days per week); Programming languages, platforms and tools used and experience level; CV; Two or three examples of comparable work with reference contacts.
  • Financial Proposal Requirements: All inclusive hourly rate in US dollars; Any other expected costs.
  • Applications submitted without both required proposals may not be considered.
  • The pilot tests the working arrangement and fit between the consultant, tools, and team.
  • Originally posted on Himalayas.
Apply now