Technical Assistant for Harmonize Common MIS Master Data Across Health Programs
Position Circumstances
- Career Category: Computer - General, Computer - Networking, Computer - Programming, Advisor / Individual Consultant
- Schedule:Short-term
- Salary: N/A
Total Duration 70 working days
Note: Payment shall only be made after submission of a report and relevant deliverables for each milestone, to be reviewed and approved by the National Malaria Program.
Objective and Justification
The primary objective of hiring a Technical Assistant (TA) is to support the establishment of harmonized common master data across the MIS, TB, HIV, laboratory, logistics, and other relevant health program systems.
The specific objectives are to:
- Assess existing master data structures, reference data, identifiers, and coding systems used across relevant programs and platforms.
- Harmonize common master data for health facilities, administrative divisions, population, laboratory, and stock/commodities.
- Support validation and quality assurance of harmonized master data.
- Establish practical mechanisms for updating, maintaining, and exchanging common master data across systems.
- Provide technical recommendations to support secure and sustainable interoperability.
Scope of Work
The selected TA will work closely with the Head of the MIS Unit and relevant CNM teams, program focal points, and designated technical counterparts from TB, HIV, laboratory, logistics, and other relevant programs. The TA will review existing systems and data structures, identify common master data requirements, harmonize datasets, and support validation and integration.
Duties & Responsibilities:
- Assessment and Planning
- Review the existing MIS architecture, database structure, relevant modules, master data, and current data exchange mechanisms.
- Identify relevant systems and databases used by TB, HIV, laboratory, stock/logistics, and other health programs.
- Assess data availability, structures, standards, identifiers, update mechanisms, access requirements, and technical readiness.
- Identify duplication, inconsistencies, gaps, data quality issues, and interoperability challenges.
- Develop a proposed methodology and implementation plan for master data harmonization.
- Master Data Harmonization and Standardization
- Review and harmonize health facility names, codes, types, locations, and other relevant attributes.
- Review and harmonize province, district, commune, village, and other relevant administrative references.
- Review population reference data and geographic relationships required for program planning and reporting.
- Review laboratory facility, service, test, specimen, and other relevant reference data.
- Review and harmonize stock and commodity information, including RDTs, ACTs, LLINs, laboratory commodities, and other relevant commodities.
- Define common identifiers, codes, naming conventions, field definitions, and data standards.
- Data Mapping and Interoperability
- Develop mapping/crosswalk tables between common master data and program-specific codes and identifiers.
- Define data elements, formats, relationships, and standards required for exchange.
- Develop procedures for matching and maintaining consistency between datasets.
- Provide technical specifications for using common master data through APIs or other data exchange mechanisms.
- Data Quality Assurance and Validation
- Establish validation and quality assurance rules for common master data.
- Identify and address duplication, inconsistent naming, missing values, invalid codes, and other data quality issues.
- Conduct technical testing and stakeholder validation of harmonized datasets.
- Refine master data based on validation results and agreed stakeholder feedback.
- Maintenance, Governance and Documentation
- Define procedures for creating, updating, deactivating, and maintaining master data.
- Develop technical and user guidance for maintaining common master data.
- Provide knowledge transfer to relevant CNM and technical staff.
- Expected Outputs
- Harmonized master data framework covering facility, administrative and population information.
- Master data mapping/crosswalk tables between common and program-specific datasets.
- Harmonized and validated datasets prepared for appropriate use within the MIS and integrated systems.
- Technical specifications and recommendations for API/data exchange and master data maintenance.
- Documentation, governance recommendations, and knowledge transfer provided to relevant CNM staff.
Expected Profile of Candidates
Qualifications:
- Bachelor's Degree in Computer Science, Information Technology, Information Systems, Software Engineering, Health Informatics, Data Management, or another related field
Work History:
- Database management, information system development, data integration, or system interoperability for 5 years as a minimum
Skills & Knowledge:
General & Technical Skills
- Demonstrated experience in master data management, data mapping, data harmonization, data validation, and data quality assurance.
- Strong knowledge of database technologies, data standards, APIs, and information system interoperability.
- Knowledge of cybersecurity principles, including secure data exchange, access control, and protection of sensitive information.
- Experience with health information systems or government information systems is an advantage.
- Ability to work and coordinate effectively with multiple government institutions and technical stakeholders.
- Familiarity with the health system in Cambodia is desired.
- Experience in malaria, TB, HIV, laboratory, logistics, or public health information systems is desired.
Technical Assistant for Develop and Expand Common MIS Modules
Position Circumstances
- Career Category: Computer - General, Computer - Networking, Computer - Programming, Health/Medical, Advisor / Individual Consultant
- Schedule:Short-term
- Salary: N/A
Total Duration 50 working days
Note: Payment shall only be made after submission of a report and relevant deliverables for each milestone, to be reviewed and approved by the National Malaria Program.
Objective and Justification
The primary objective of hiring a Technical Assistant (TA) is to develop and expand common MIS modules that can be reused across malaria, TB, HIV, and other relevant health programs.
The specific objectives are to:
- Assess and refine requirements for common MIS functions.
- Develop or expand e-training and certification functionality.
- Develop or expand administrative division management functionality.
- Develop or expand alert and notification functionality.
- Develop or expand stock management functionality for RDTs, ACTs, LLINs, laboratory commodities, and other relevant commodities.
- Ensure the modules are integrated with common master data, existing MIS components, and approved external systems as appropriate.
Scope of Work
The selected TA will work closely with the Head of the MIS Unit, relevant CNM teams, program focal points, developers, and technical counterparts. The TA will assess existing functionality, develop or expand common modules, integrate them with the MIS, conduct testing, and support implementation and handover.
Duties & Responsibilities:
- Assessment and Functional Planning
- Review existing MIS modules and identify functionality that can be reused or expanded across programs.
- Consult relevant users and program focal points to identify common requirements.
- Define functional requirements, workflows, user roles, data requirements, and integration needs.
- Develop a detailed technical development and implementation plan.
- E-Training and Certification
- Develop or enhance course and training management functionality.
- Support user enrollment, learning content, assessments, completion tracking, and training history.
- Support pre-test/post-test and scoring functionality where required.
- Develop certification and certificate management functionality.
- Provide training and certification reporting by user, program, administrative area, and other relevant dimensions.
- Alert and Notification
- Develop configurable system alerts based on defined business rules and conditions.
- Support alerts related to stock levels, expiry, reporting, training, certification, and other program events.
- Support user- and role-specific notifications.
- Support in-system notifications and, where technically approved
- Provide configuration options for authorized administrators to manage alert rules.
- Stock Management
- Develop or enhance commodity master data and stock management functions.
- Support stock receipt, issue/distribution, transfer, adjustment, and balance management.
- Support batch/lot and expiry-date tracking where required.
- Support minimum and maximum stock levels and stock alerts.
- Cover RDTs, ACTs, LLINs, laboratory commodities, and other relevant program commodities.
- Provide facility-level and program-level stock visibility and reporting.
- Integrate stock management with common facility and commodity master data and relevant external systems where appropriate.
- Testing, Documentation and Handover
- Conduct unit, integration, functional, and user acceptance testing as appropriate.
- Address identified bugs, data issues, and performance problems.
- Apply role-based access control, audit trails, secure development practices, and cybersecurity requirements.
- Develop user manuals, administrator guidance, technical documentation, and API documentation where applicable.
- Provide deployment support, knowledge transfer, and handover to the MIS/IT team.
- Expected Outputs
- Functional and technical specifications for the common MIS modules.
- Enhanced e-training and certification module.
- Enhanced alert and notification module.
- Enhanced stock management module covering RDTs, ACTs, LLINs, laboratory commodities, and other relevant commodities.
- APIs or other integration components required for approved system integration.
- Testing, user acceptance, bug fixing, documentation, deployment support, and knowledge transfer completed.
Expected Profile of Candidates
Qualifications:
- Bachelor's Degree in Computer Science, Information Technology, Information Systems, Software Engineering, Health Informatics, or another related field
Work History:
- Software development, information system implementation, or system integration for 5 years as a minimum
Skills & Knowledge:
General & Technical Skills
- Demonstrated experience developing web-based information systems, modular applications, databases, APIs, and integration solutions.
- Experience with e-learning, workflow, notification, logistics, stock management, or similar systems is desirable.
- Strong knowledge of database technologies, APIs, role-based access control, and secure application development.
- Experience with health information systems or government information systems is an advantage.
- Ability to work and coordinate effectively with multiple technical and program stakeholders.
- Familiarity with the health system in Cambodia is desired.
- Experience in malaria, TB, HIV, logistics, or public health is desired.
Technical Assistant for Develop Role-Based MIS Dashboards
Position Circumstances
- Career Category: Computer - General, Computer - Networking, Computer - Programming, Advisor / Individual Consultant
- Schedule:Short-term
- Salary: N/A
Total Duration 27 working days
Note: Payment shall only be made after submission of a report and relevant deliverables for each milestone, to be reviewed and approved by the National Malaria Program.
Objective and Justification
The primary objective of hiring a Technical Assistant (TA) is to develop and implement role-based MIS dashboards that provide relevant, timely, and actionable information to authorized users across different health programs and management levels.
The specific objectives are to:
- Assess dashboard and information requirements for different user roles and management levels.
- Define priority indicators, data sources, calculations, and visualization requirements.
- Design and develop user-friendly, interactive, role-based dashboards.
- Integrate dashboards with harmonized common master data and relevant MIS modules.
- Implement appropriate role-, program-, administrative-, and facility-based access controls.
- Support data quality validation, dashboard performance, testing, and user acceptance.
Scope of Work
The selected TA will work closely with the Head of the MIS Unit, relevant CNM teams, program managers, data users, developers, and technical counterparts. The TA will assess information needs, design dashboard prototypes, develop and integrate dashboards, validate indicators and data, and support implementation.
Duties & Responsibilities:
- Assessment and Dashboard Planning
- Review existing MIS reports, dashboards, indicators, and analytical requirements.
- Identify major user groups and their information needs.
- Define priority indicators, data sources, calculation rules, and reporting dimensions.
- Develop a dashboard requirements matrix covering user roles, programs, administrative levels, and access requirements.
- Develop a detailed dashboard implementation plan.
- Dashboard Design and Prototyping
- Develop dashboard layouts and prototypes for relevant user groups.
- Design appropriate charts, tables, maps, trends, comparisons, and status indicators.
- Design navigation and drill-down from summary information to relevant detailed information.
- Ensure dashboards are clear, intuitive, responsive, and suitable for management decision-making.
- Validate prototypes with relevant users before final development.
- Role-Based Dashboard Development and Integration
- Develop dashboards for national, program, provincial/subnational, district, and facility/operational users as required.
- Implement role-based, program-based, geographic, and facility-based data access.
- Integrate dashboard indicators with common MIS master data and relevant modules.
- Integrate information from e-training, alerts, stock management, and other approved data sources where appropriate.
- Support filtering by period, program, administrative area, facility, and other relevant dimensions.
- Implement drill-down and export functionality where required.
- Data Validation, Testing and Performance
- Validate indicator definitions, calculations, and dashboard outputs against source data.
- Identify and address data quality issues affecting dashboard results.
- Conduct functional, data accuracy, access control, and performance testing.
- Support user acceptance testing and incorporate agreed feedback.
- Optimize queries and dashboard performance for increasing data volumes.
- Documentation and Capacity Building
- Document indicator definitions, data sources, calculation methodologies, and access rules.
- Develop user guidance and technical documentation.
- Provide recommendations for dashboard maintenance and future expansion.
- Provide knowledge transfer to relevant CNM and MIS/IT staff.
- Expected Outputs
- Dashboard requirements matrix covering users, indicators, data sources, and access requirements.
- Dashboard designs and prototypes validated with relevant stakeholders.
- Role-based dashboards developed and integrated with common MIS data and relevant modules.
- Role-based access controls and appropriate filtering implemented.
- Dashboard indicators and calculations validated against source data.
- Tested and refined dashboards deployed or prepared for deployment.
- Technical and user documentation and knowledge transfer provided.
Expected Profile of Candidates
Qualifications:
- Bachelor's Degree in Computer Science, Information Technology, Information Systems, Data Science, Health Informatics, or another related field
Work History:
- Data visualization, dashboard development, business intelligence, data analysis, or information systems for 7 years as a minimum
Skills & Knowledge:
General & Technical Skills
- Demonstrated experience developing interactive dashboards and analytical reporting systems.
- Strong knowledge of databases, SQL, data integration, data visualization, and KPI development.
- Experience with role-based access control and secure information systems.
- Knowledge of cybersecurity principles and protection of sensitive information.
- Experience with health information systems or government information systems is an advantage.
- Ability to work and coordinate effectively with program managers, data users, and technical teams.
- Familiarity with the health system in Cambodia is desired.
- Experience in malaria, TB, HIV, or public health information systems is desired.
