Job Title: IT Infra Engineer Organisation: De Heus Animal Nutrition (Koudijs)…
Data Warehouse Developers (GHSA) US Non-profit Careers – Jhpiego
Job Title: Data Warehouse Developers (GHSA)
Organisation: Jhpiego
Duty Station: Kampala, Uganda
About US:
Jhpiego is an international non-profit health organization affiliated with Johns Hopkins University. The group was founded in 1973 and initially called the Johns Hopkins Program for International Education in Gynaecology and Obstetrics, but is now referred to simply as Jhpiego.
About CDC GHSA Project:
Through funding from the Centers for Disease Control and Prevention (CDC), Jhpiego is implementing the project, ‘Enhancing Global Health Security: Expanding Efforts and Strategies to Protect and Improve Public Health Globally’. This award builds on ongoing CDC funded investments to support the Global Health Security Agenda (GHSA) through implementation of programs focused on protecting and improving health globally. Through this grant, Jhpiego will support Uganda to strengthen surveillance data management by creating a centralized data warehousing, conducting analysis and visualization at designated national and sub-national levels, developing policies, procedures and relevant MoUs for surveillance systems integration, and implementing targeted capacity building to data end-users on how to think about data.
Job Summary: The Data Warehouse Developers will lead the development of data pipelines and scripts to feed into the Data Warehouse. The data sources will include data from surveillance teams, regional referrals and other health information systems. This is a contract position and is renewable annually based on availability of funding and scope of work.
Key Duties and Responsibilities:
- Design, develop and modify relational and multidimensional database structures, relationships, data pipelines and data interfaces within the data warehouse as needed.
- Analyze and modify the data structures within the data warehouse to adapt them to the project’s needs and add enhanced functionality.
- Implement ETL processes to extract, transform, and load data from various sources into the data warehouse.
- Create and maintain database structures to ensure data integrity and quality.
- Troubleshoot and resolve any issues related to data infrastructure.
- Develop and maintain data models that support the reporting and analysis needs of the project.
- Optimize data warehouse performance through index creation, query optimization, and database tuning.
- Implement data security measures to ensure data privacy and confidentiality.
- Develop and maintain documentation of the data warehouse and its processes.
- Collaborate with other developers, analysts, and business users to identify data requirements and design solutions to meet those requirements.
(adsbygoogle = window.adsbygoogle || []).push({});
Qualifications, Skills and Experience:
- The applicant must hold a Bachelor’s Degree in computer science, information systems or related field
- Relevant certificates in computer programming and software development
- Three years of experience in data engineering / development
- 3+ years of experience in database warehouse development.
- Experience with big data technologies such as Apache Spark, Kafka, and Hadoop is an added advantage
- Experience with ETL tools such as Pentaho, Talend, Informatica or SSIS
- Experience with database technologies such as Oracle, SQL Server, or PostgreSQL.
- Experience working with large scalable data sets in both structured and non-structured data.
- Strong programming skills in Java, Python, or Scala is an added advantage.
- Development and designs of APIs
- Experience working with JasperReports is an added advantage.
- Excellent communication and interpersonal skills, and the ability to function on a high-performing team.
- Understanding of data warehousing concepts such as dimensional modeling and star schemas.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work in a fast-paced environment and manage multiple priorities.
How to Apply:
All candidates should apply online at the link below.
For more of the latest jobs, please visit https://www.theugandanjobline.com or find us on our facebook page https://www.facebook.com/UgandanJobline