Thursday 21 June 2012

Data Warehouse Architect Job Vacancy at Management Sciences for Health (MSH)


Job Title: Data Warehouse Architect

Job Description



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 district 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-Transform-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 the design, development, testing and deployment of the district supervision data system and oversee the contractor’s development team to ensure timely 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.
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

The Human Resources Partner – MSH, Plot 15 Princess Ann Drive Bugolobi, P O 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.