UCSF is hiring a Database/BI Developer this August 2024! Join a leading institution renowned for cutting-edge research and impactful healthcare contributions. Ready to advance your career? For details and to apply, visit ajiratimes.com. Don’t miss out
Location: Dar es Salaam
Application Deadline: August 15, 2024
Start Date: October 1, 2024
The University of California, San Francisco (UCSF) is engaged in a five-year Cooperative Agreement with the U.S. Centers for Disease Control and Prevention-Tanzania (CDC-Tanzania) to provide strategic information and health information systems (HIS) technical assistance to the Ministry of Health, Community Development, Gender, Elderly and Children (MOHCDGEC) as well as the United States’ President’s Emergency Plan for AIDS Relief (PEPFAR) and their implementing partners (IPs). We are recruiting an individual through our affiliated international NGO ‘Global Programs’ to serve as a Database/BI Developer.
This is a full-time position with an initial contract through September 2025 and the possibility of extension subject to continued funding. The position is expected to start on October 1, 2024.
Main Duties and Responsibilities:
Under the supervision of the HIS lead, the Database/BI Developer shall support UCSF with its data needs by developing and maintaining databases, reports, queries, and other software to support its projects and programmes. The Database/BI Developer is expected to design databases to meet the needs for specific projects while maintaining database design standards.
Some projects will require the developer to import data from existing data sources into a UCSF-managed database, sometimes with data transformation. Proficiency in SQL and scripting languages is critical. Another critical task for the BI Developer will be to visualize project data on dashboards, often with data transformation and analysis.
As an integral part of the Global Programs Tanzania office, the Database/BI Developer may be expected to meet with stakeholders, funders, and government officials, and draw up requirements based on their needs.
Specific responsibilities include:
Map out the conceptual design for a planned database that is to contain large health-related datasets. Design, develop, and implement ETL programs to load various databases on a continuous and ongoing basis into a master database for analysis. Develop efficient queries, views, indexed views, and other database objects to facilitate querying, reporting, and analysis.
Recommend where appropriate and subsequently develop a data warehouse. Design and develop dashboards, charts, and reports using PowerBI and SQL Server Reporting Services. Further refine the physical design to meet system storage requirements. Maintain data standards, including adherence to the Data Protection Act.
Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata). Ensure that data storage and archiving procedures are functioning correctly. Communicate regularly with technical, applications, and operational staff to ensure database integrity and security.
Commission and install new applications and customize existing applications in order to make them fit for purpose. Any other duties or tasks within the scope of the role as directed by management.
Experience, Skills, and Minimum Required Qualifications:
An appropriate degree in computer science, information systems, or software engineering with a focus on database development or business intelligence with three years’ experience – or at least six years of demonstrable experience in database development, backend development, or business intelligence. A master’s degree in computer science, software engineering, Health Informatics, or Information Systems Management is an added advantage.
At least three years demonstrable experience in one DBMS, either SQL Server or PostgreSQL. Demonstrable experience in working with databases and SQL, including writing complex SQL queries. Demonstrated experience in business intelligence tools like Power BI and Tableau.
Certification in a popular DBMS is considered a major advantage. Experience with one or more of the following domains is considered advantageous: Software development using Python. Working in the health sector, especially in HIV-related services.
Epidemiology and/or (Bio)statistics. Monitoring and Evaluation. Demonstrable skills in enterprise application integration. Ability to work successfully in a team. Fluent in written and spoken English and Swahili.
Other desired skills/qualities:
- Excellent skills in critical thinking and analysis.
- Excellent organizational and oral/written communication skills.
- Ability to work independently and manage various tasks under tight deadlines.
- Willingness to liaise and collaborate with other staff, and train them in the design, development, and maintenance of databases and dashboards.
How to Apply
All applicants must address each selection criterion detailed in the minimum requirements above with specific and comprehensive information supporting each item. All applications must include the following:
- A current CV with names and telephone numbers of at least 2 referees.
- Copies of academic and professional certificates.
Applications and supporting documents should be sent via e-mail to [email protected] and must be received by August 15, 2024. NOTE: Only short-listed candidates will be contacted.
READ ALSO: Control and Risk Associate Consultant at UNICC August 2024
