Consultant, Campaign Information Management System (CIMS)

This is a fully remote position, open to applicants in Maine.

📋 Description

• Evaluate Databricks in relation to PALU’s current and anticipated data warehouse requirements while comparing it to MCD’s AWS PostgreSQL setup.

• Set up a representative Databricks data model and establish connections to key external data sources.

• Conduct a cost-benefit analysis, develop future project plans, and document configurations, testing procedures, and findings.

• Establish GitLab CI/CD pipelines, schedules, and associated files for PALU automations, reporting, dbt builds, and external data extraction.

• Set up CI/CD for the new CIMS codebase, which includes builds, version control, release tagging, and testing stages.

• Configure application logging, pipeline alerts, reporting mechanisms, and access controls.

• Manage CIMS releases and ODK Central upgrades to ensure smooth field data collection.

• Analyze AWS account structure, services, and costs; identify idle, oversized, or redundant resources.

• Execute approved AWS cost-saving measures and configure GitLab runners on AWS as necessary.

• Enhance application deployment through the use of containers and infrastructure as code.

• Review documentation, write necessary configuration code, and provide guidance, training, and handover sessions.

• Implement security patches and dependency updates, monitor pipelines and infrastructure, troubleshoot failures, verify backups, and test restoration processes.

• Review AWS and Databricks expenses on a monthly basis, maintain documentation and runbooks, and manage Jira maintenance tickets.

• Track tasks using Jira and conduct weekly meetings with the Digital Health Tools and Systems Lead.

• Achieve pilot milestones starting from onboarding in the first week of November through to the final pilot report on December 31.

⛳️ Requirements

• A degree in computer science, software engineering, information systems, or a related discipline, or equivalent professional experience.

• A minimum of five years' experience in DevOps, cloud infrastructure, or data engineering.

• Practical experience in configuring GitLab CI/CD, including runners, pipeline schedules, and protected variables.

• Proficiency in managing AWS environments, including identity and access management, EC2, RDS, S3, networking, and cost management.

• Strong SQL and PostgreSQL expertise along with a working knowledge of Python.

• Experience with dbt and building data pipelines from APIs.

• Knowledge of security practices in cloud environments, encompassing access control, secrets management, backup, and recovery.

• Proficient technical writing skills in English.

• Familiarity with Databricks or similar platforms such as Snowflake or BigQuery, including cost modeling.

• Experience with ODK Central, DHIS2, or other health information systems.

• Familiarity with containers and infrastructure as code tools like Docker and Terraform.

• Previous experience supporting health programs in Africa.

• Working knowledge of Spanish.

• Availability from November 1 to December 31, 2026.

• Submission of a technical proposal, financial proposal, CV, and relevant work references is required.

• Candidates selected for the position must complete thorough reference and background checks.

• Compliance with MCD security, data protection, confidentiality, and data ownership policies is mandatory; use of MCD-issued accounts and approved systems is required.

🏝️ Benefits

• MCD will directly cover cloud and software license costs in MCD accounts, including Databricks usage during the pilot.

• We are an equal opportunity and affirmative action employer.

• Reasonable accommodations are available for qualified individuals with disabilities and disabled veterans.