Опис вакансії
We are looking for an experienced ETL developer/ System Integration specialist to work with the team of experts studying the business processes of the Public Health Center of the Ministry of Health of Ukraine regarding the collection, exchange, processing, analysis, and use of data related to HIV, conduct a comprehensive analysis of existing information systems and data related to HIV in Ukraine.
The purpose is to design and implement ETL processes for efficient data integration, transformation, and loading to support business analytics and reporting.
Objectives
- Develop ETL workflows to extract data from source systems.
- Transform data to meet business and technical requirements.
- Load transformed data into the target data warehouse or database.
- Ensure data quality, consistency, and security throughout the ETL process.
- Provide documentation and training for ETL operations.
Scope of Work
- Collect and document business, technical, and data requirements for ETL.
- Identify and analyze data sources, formats, and access protocols.
- Architect ETL workflows, including extraction, data cleansing, transformation logic, and loading strategies.
- Build ETL pipelines using agreed-upon tools and technologies.
- Perform unit, integration, and user acceptance testing to validate ETL functionality and data accuracy.
- Migrate ETL processes to production environment and execute initial loads.
- Prepare technical documentation and user guides for ETL processes.
- Conduct training sessions for relevant stakeholders and provide post-deployment support.
Deliverables
- ETL requirements documentation
- ETL workflow and architecture diagrams
- Developed ETL scripts and jobs
- Testing reports and data validation results
- Deployment plan and execution report
- Technical and user documentation
- Training materials and session records
Candidate Requirements
- Minimum of 5 years’ experience as an ETL developer, preferably within healthcare, public health, or international projects
- Degree in Information Technology, Computer Science, or related field
- Strong understanding of data management principles, system analysis, and data quality assessment methodologies
- Experience with healthcare or social sector information systems is highly desirable
- Proficiency in visualizing and presenting complex information through reports, diagrams, and maps
- Experience in systems integration
- Proficiency in database management systems, data warehousing, ETL processes, and data governance
- Strong analytical and problem-solving skills
- Deep understanding of data architecture principles, APIs, interoperability, security, and personal data protection
Advantages:
- Experience with eHealth systems, DHIS2, OpenMRS, or similar platforms
- Knowledge of the Ukrainian context in the field of digital health