Deadline: 27 September 2023.

About the organization:

Zim-TTECH is seeking highly qualified and experienced applicants to fill the position of Database Modeller for the Impilo EHR/CBS program. Zim-TTECH’s activities occur primarily in the technical areas of health system strengthening; epidemiology and strategic information strengthening, health workforce development; operations research and evaluation; prevention, care, and treatment of infectious diseases. Zim-TTECH is funded by PEPFAR through the Center for Disease Control (CDC) to implement Strengthening Epidemiology and Strategic Information in the 44 districts of the Republic of Zimbabwe. Zim-TTECH also implements HIV & TB treatment and care services in five Zimbabwean provinces in support of the Ministry of Health and Child Care (MoHCC) under the Zim-PAAC (Zimbabwe Partnership to Accelerate AIDS Control) Program. Additionally, the ZimPAAC DREAMS consortium comprising of three local partners implements DREAMS activities in four districts in Matabeleland North Province (Bubi, Nkayi, Tsholotsho and Lupane).

Position Summary

• The position is responsible for designing the structure of the database system. It creates a conceptual data model that defines the relationships between different data entities and how they will be stored in the database.

Responsibilities

• Analysing business requirements and translating them into database designs.
• Creating conceptual, logical, and physical data models.
• Developing database schemas and defining relationships between tables.
• Ensuring data integrity by implementing constraints, triggers, and other mechanisms.
• Optimizing database performance by tuning queries and indexes.
• Collaborating with software developers to integrate the database with Impilo E.H.R.
• Testing and debugging the database to ensure accuracy and reliability.
• Identifying the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.

Qualification

• Computer Science/ IT / Business Information Systems or Equivalent degree
• 5+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, MySQL, Postgres, data platform technologies, and ETL and data ingestion protocols)
• Fluent with Python, SQL, and other programming languages.

Desired Experience

• Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Excellent presentation skills.

Commitment to Diversity

Zim-TTECH recognizes that disparities in health around the globe stem from inequity. Therefore, the organization encourages and supports the multiple identities of staff including, but not limited to, socio-economic status, age, race, ethnicity, language, nationality, sex, gender identity and expression, culture, spiritual practice, geography, mental and physical disability. Zim-TTECH strives to become a local, national, and international leader in developing and maintaining increased representation and recognition of each of these dimensions of diversity among its staff.

Interested candidates should submit their application letter, detailed Curriculum Vitae, and certified copies of certificates to: ehrprogram@zimttech.org

Only shortlisted candidates will be contacted.