Job Title: Data Warehouse Architect
Management Sciences for Health (MSH) is an international non-profit, public health organisation with headquarters in USA, whose purpose is to strengthen health programs worldwide. MSH Uganda is currently running a number of USAID and other donor funded projects including SURE, both in Kampala and other parts of the country.
SURE (Securing Ugandans’ Right to Essential Medicines) will ensure that the population of Uganda has access to adequate quantities of good quality essential medicines and health supplies (EMHS) by strengthening the national essential medicines and health commodities supply system.
MSH now invites applications from suitably qualified candidates for the position of Data Warehouse Architect based in Kampala.
Reports To: Technical Advisor, PIP
Overall Responsibilities
The Data Warehouse Architect is responsible for the design and coordination of the implementation of the distict supervision data system. The system is built on data warehousing and business intelligence technology to support analysis and reporting on performance of healthcare facilities in medicines management in SURE’s forty five districts. In addition the job holder will: Be involved in the development of a data mart and business intelligence application to provide self service analytics of medicines management supervision data routinely collected from districts. Works in collaboration with an external contractor to develop a conformed data mart for the district data and is involved in the development of Extract-Transfomn-Load procedures for the data.
Works with internal and external partners to proactively identify the business intelligence and reporting needs of systems users and works extensively with the system contractor to accommodate these reporting requirements into the system’s business intelligence interface. Actively coordinate and participate in Ihe design, development, testing and deployment of the district supervision data system and oversee Ihe contractor’s development team to ensure limely completion of the system development Project.
Educate internal and external users on the analytical processing capabilities of the system. Design, implement and document system maintenance plans in line with best practices including hardware maintenance, system backup, disaster recovery, fail safe and optimization.
Oversee the project management of the system development project and ensures that it is delivered on schedule and that the finished system meets the expected quality.
Requirement:
Qualifications
Masters degree in computer science or related discipline
Proven experience in the development of data warehousing and business intelligence solutions using SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
Advanced level development skills on the Visual Studio. NET stack including C#.NET and ASP.NET.
Experience implementing SharePoint applications an added advantage.
Knowledge of Windows Server administration.
In-depth knowledge of the Ugandan healthcare system including health management information systems.
Excellent communication and technical documentation skills.
Knowledge of statistical analysis a plus
Ability to work independently and creatively in a fast paced environment to meet project deadlines and expectations.
How to apply:
AH applications should be addressed to: The Human Resources Partner – MSH, Plot 15 Princess Ann Drive Bugolobi, P 0 Box 71419, Kampala Email:
HRUG@msh.org.
Deadline for submission: July 5, 2012. We thank all applicants for their interest, but can only acknowledge shortlisted candidates.
