MCD Global Health

Consultant

• Assess Databricks against PALU’s current and expected data warehouse needs and compare it with MCD’s AWS PostgreSQL environment
• Configure a representative Databricks data model and connectors to priority external data sources
• Prepare cost-benefit analysis, future project plans, and document configurations, tests and findings
• Configure GitLab CI/CD pipelines, schedules and related files for PALU automations, reports, dbt builds and external data extraction
• Configure CI/CD for the new CIMS codebase, including builds, version control, release tagging and test stages
• Configure application logging, pipeline notifications, reporting and access controls
• Coordinate CIMS releases and ODK Central upgrades to avoid disruption to field data collection
• Review AWS account structure, services and costs; identify idle, oversized or duplicated resources
• Implement approved AWS cost-saving opportunities and configure GitLab runners on AWS as needed
• Modernize application deployment using containers and infrastructure as code
• Review documentation, write required configuration code, and provide guidance, training and handover sessions
• Apply security patches and dependency updates, monitor pipelines and infrastructure, fix failures, verify backups and test a restore
• Review AWS and Databricks costs monthly, maintain documentation and runbooks, and resolve Jira maintenance tickets
• Track tasks through Jira and meet weekly with the Digital Health Tools and Systems Lead
• Deliver pilot milestones from onboarding in the first week of November through the end-of-pilot report on December 31

Consultant, Campaign Information Management System (CIMS)