Job Title: Data Warehouse Architect
Organisation: Ministry of
Health
Health
Funding Source: Global Fund
Reports to: Assistant
Commissioner Health Services/Resource Centre (ACHS/RC)
Commissioner Health Services/Resource Centre (ACHS/RC)
About US:
The Government
of the Republic of Uganda under the Ministry of Health has received funding
from the Global Fund to Fight HIV/AIDS, Tuberculosis and Malaria, to support
among other things recruitment of key staff to assist in improvement of the
Health Systems Strengthening (HSS) grant performance. The goals of the Health
Systems Strengthening grant are to:
of the Republic of Uganda under the Ministry of Health has received funding
from the Global Fund to Fight HIV/AIDS, Tuberculosis and Malaria, to support
among other things recruitment of key staff to assist in improvement of the
Health Systems Strengthening (HSS) grant performance. The goals of the Health
Systems Strengthening grant are to:
·
Strengthen the Procurement and Supply Management
(PSM) system
Strengthen the Procurement and Supply Management
(PSM) system
·
Support improvements in the Management Information
Systems and Monitoring and
Support improvements in the Management Information
Systems and Monitoring and
·
Support community involvement in the delivery of
health services
Support community involvement in the delivery of
health services
Additionally,
the National TB and Leprosy Program (NTLP) is under the department of the
National Disease Control (NDC) in the Ministry of Health. NTLP’s overall
functions are to establish country wide quality diagnosis and treatment
services for TB and Leprosy and to coordinate the implementation of TB and
Leprosy control activities. Under the National Program is a National TB Reference
Laboratory whose functions are; to provide technical guidance to all TB
diagnostic facilities and standardization of Laboratory TB and Leprosy provide
technical supervision and training of laboratory staff on TB and Leprosy
Diagnosis Techniques, Confirmation of drug resistant TB and provide follow up
culture and drug susceptible tests as a national referral facility. It also
supports coordinated drug resistant TB surveillance and technical support roll
out of new laboratory technologies and support their uptake and utilization. It
also carries out operational research activities.
the National TB and Leprosy Program (NTLP) is under the department of the
National Disease Control (NDC) in the Ministry of Health. NTLP’s overall
functions are to establish country wide quality diagnosis and treatment
services for TB and Leprosy and to coordinate the implementation of TB and
Leprosy control activities. Under the National Program is a National TB Reference
Laboratory whose functions are; to provide technical guidance to all TB
diagnostic facilities and standardization of Laboratory TB and Leprosy provide
technical supervision and training of laboratory staff on TB and Leprosy
Diagnosis Techniques, Confirmation of drug resistant TB and provide follow up
culture and drug susceptible tests as a national referral facility. It also
supports coordinated drug resistant TB surveillance and technical support roll
out of new laboratory technologies and support their uptake and utilization. It
also carries out operational research activities.
Job Summary: The Data Warehouse Architect will be responsible
for providing day-to-day technical assistance to the RC division designs,
develops and optimizes data warehouses, with flexible and scalable data and ETL
architecture, to support business users and business intelligence (Bl)
applications. Data warehouse architect will build specialized information
systems that will make Ministry of Health data readily available for analysis
and retrieval.
for providing day-to-day technical assistance to the RC division designs,
develops and optimizes data warehouses, with flexible and scalable data and ETL
architecture, to support business users and business intelligence (Bl)
applications. Data warehouse architect will build specialized information
systems that will make Ministry of Health data readily available for analysis
and retrieval.
Furthermore,
the Data Warehouse Architect will play a pivotal role in ensuring that the
Resource Centre data warehouse activities are well documented and signed off.
The Data Warehouse Architect will work closely with other Departments/Technical
Programs to provide functional, technical or process leadership in designing
and developing a national information portal with appropriate dashboards. In
addition, the Data Warehouse Architect will provide support for the capacity
building of staff and Dartners in relation to Enterprise architecture, to
support business users and facilitate knowledge building, knowledge sharing,
mentorship and guidance.
the Data Warehouse Architect will play a pivotal role in ensuring that the
Resource Centre data warehouse activities are well documented and signed off.
The Data Warehouse Architect will work closely with other Departments/Technical
Programs to provide functional, technical or process leadership in designing
and developing a national information portal with appropriate dashboards. In
addition, the Data Warehouse Architect will provide support for the capacity
building of staff and Dartners in relation to Enterprise architecture, to
support business users and facilitate knowledge building, knowledge sharing,
mentorship and guidance.
Key Duties and Responsibilities:
1.
Support the Resource Centre Division:
Support the Resource Centre Division:
·
Provide strategic and tactical guidance with respect
to data warehousing best practices and attention to quality documentation.
Provide strategic and tactical guidance with respect
to data warehousing best practices and attention to quality documentation.
·
The incumbent will manage both internal and external
resources, timelines, and milestones.
The incumbent will manage both internal and external
resources, timelines, and milestones.
·
Provide overall leadership with regards to creative
data profiling and integration recommendations.
Provide overall leadership with regards to creative
data profiling and integration recommendations.
·
Responsible for designing and implementing detailed
data warehouse models and data mappings.
Responsible for designing and implementing detailed
data warehouse models and data mappings.
·
Quickly resolving any and all issues throughout the
development lifecycle.
Quickly resolving any and all issues throughout the
development lifecycle.
·
Carry out performance optimization and tuning on new
and/or existing date warehouse implementations.
Carry out performance optimization and tuning on new
and/or existing date warehouse implementations.
·
Provide detailed documentation, end user training
and knowledge-transfer services to clients (both internal and external).
Provide detailed documentation, end user training
and knowledge-transfer services to clients (both internal and external).
·
Support annually defined sector wide strategic goals
aimed at continued scale up
Support annually defined sector wide strategic goals
aimed at continued scale up
·
Develop and maintain expertise in advanced and/or
emerging date warehouse and analytical information technologies such as Hadoop,
in-memory analytics, date warehouse appliances, and data warehouse
virtualization.
Develop and maintain expertise in advanced and/or
emerging date warehouse and analytical information technologies such as Hadoop,
in-memory analytics, date warehouse appliances, and data warehouse
virtualization.
·
Continue professional and technical growth through
corporate and personnel initiatives.
Continue professional and technical growth through
corporate and personnel initiatives.
2.
Provide the Resource Centre department with technical and strategic oversight
for GF implementation.
Provide the Resource Centre department with technical and strategic oversight
for GF implementation.
·
Work with the FCO, PD and HCSS coordinator to ensure
proper interpretation of
Work with the FCO, PD and HCSS coordinator to ensure
proper interpretation of
·
the grant letters and fund release budgets in coming
up with the in-country grant implementation work plans; this includes proper
interpretation of the GF Budgets through quality assurance of requisitions to
prevent risky consequences, track fund absorption (through monitoring
absorption at the SDAs) and anticipate tides ahead and advise on speed of
implementation.
the grant letters and fund release budgets in coming
up with the in-country grant implementation work plans; this includes proper
interpretation of the GF Budgets through quality assurance of requisitions to
prevent risky consequences, track fund absorption (through monitoring
absorption at the SDAs) and anticipate tides ahead and advise on speed of
implementation.
·
Undertake evaluation of the National Information
Portal implementation on an annual basis
Undertake evaluation of the National Information
Portal implementation on an annual basis
·
Support the reporting to the Global Fund HCSS Grant
implementation activities
Support the reporting to the Global Fund HCSS Grant
implementation activities
3.
Report on progress both qualitatively and quantitatively according to the
annual work plans and log frame focusing on the achievement of the following
results:
Report on progress both qualitatively and quantitatively according to the
annual work plans and log frame focusing on the achievement of the following
results:
·
Work closely with MoH/RC responsible officers in the
preparation of plans at the field level and recommend corrective action, if
any, to streamline the process
Work closely with MoH/RC responsible officers in the
preparation of plans at the field level and recommend corrective action, if
any, to streamline the process
·
Ensure the timely submission of required reports by
Ministry of Health Resource Centre under the overall guidance of the ACHS/RC
Ensure the timely submission of required reports by
Ministry of Health Resource Centre under the overall guidance of the ACHS/RC
·
Support the identification and documentation of
links, synergies, lessons learnt and best practices that can be useful in the
institutional learning process and increasing the results of the project
Support the identification and documentation of
links, synergies, lessons learnt and best practices that can be useful in the
institutional learning process and increasing the results of the project
4.
Support and work with other program Information specialists to conduct National
Health Information Portal Enterprise Architecture review in collaboration with
other partners such as Academia and WHO among others
Support and work with other program Information specialists to conduct National
Health Information Portal Enterprise Architecture review in collaboration with
other partners such as Academia and WHO among others
·
Serve as a key liaison between information
technology and date users.
Serve as a key liaison between information
technology and date users.
·
Develop National eHealth Architecture that supports
the various HMIS platforms in the National Health Date Warehouse within agreed
framework ensuring standards, integration and interoperability
Develop National eHealth Architecture that supports
the various HMIS platforms in the National Health Date Warehouse within agreed
framework ensuring standards, integration and interoperability
5.
Ensures Program knowledge management and
capacity development on results- based management:
Ensures Program knowledge management and
capacity development on results- based management:
·
In charge of the preparation and submission of quarterly
and annual programmatic progress updates on program based on GF requirements
In charge of the preparation and submission of quarterly
and annual programmatic progress updates on program based on GF requirements
·
Ensures training and other capacity development
initiatives to strengthen program and district capacity in results-based management,
monitoring and evaluation
Ensures training and other capacity development
initiatives to strengthen program and district capacity in results-based management,
monitoring and evaluation
·
Actively facilitates strategic information sharing
across departments, sub national levels
Actively facilitates strategic information sharing
across departments, sub national levels
6.
Ensures development and updating of databases with
pertinent program date and reports, evaluations, etc.
Ensures development and updating of databases with
pertinent program date and reports, evaluations, etc.
·
Design, develop and implement a Medicines and
Medical Supply Chain Information Management System to be used across the
country
Design, develop and implement a Medicines and
Medical Supply Chain Information Management System to be used across the
country
7.
Design, develop and implement a National
Health Data Bank:
Design, develop and implement a National
Health Data Bank:
·
To put in place one person one electronic medical
record system accessible anywhere in the country at any point and plan national wide rollout
To put in place one person one electronic medical
record system accessible anywhere in the country at any point and plan national wide rollout
·
Develop Electronic Health Record (HER) Info
structure
Develop Electronic Health Record (HER) Info
structure
8.
Perform other duties assigned by the Assistant
Commissioner Health Services/ RC
Perform other duties assigned by the Assistant
Commissioner Health Services/ RC
Qualifications, Skills and Experience:
·
The Data Ware house Architect should hold a Master’s
degree in information systems, or computer science from a recognized university
The Data Ware house Architect should hold a Master’s
degree in information systems, or computer science from a recognized university
·
Possession of an MBA with a concentration in
management information science is preferred
Possession of an MBA with a concentration in
management information science is preferred
·
A Microsoft Certified IT Professional (MCITP)
credential is preferred.
A Microsoft Certified IT Professional (MCITP)
credential is preferred.
·
Certified Business Intelligence Professional (CBIP).
Certified Business Intelligence Professional (CBIP).
·
A minimum of ten years’ experience in a date
architecture role
A minimum of ten years’ experience in a date
architecture role
·
Significant experience and judgment to plan and
accomplish goals.
Significant experience and judgment to plan and
accomplish goals.
·
Familiar with a variety of the field’s concepts,
practices, and procedures
Familiar with a variety of the field’s concepts,
practices, and procedures
·
Practical experience using ETL tool (Informatica,
Date Stage, Data Manager, SSIS, or other).
Practical experience using ETL tool (Informatica,
Date Stage, Data Manager, SSIS, or other).
·
Working knowledge of modeling tools (Erwin and/or
Rational Rose) in addition to hands-on experience with business intelligence
tools.
Working knowledge of modeling tools (Erwin and/or
Rational Rose) in addition to hands-on experience with business intelligence
tools.
·
Expert knowledge of SQL and related SQL procedure
languages.
Expert knowledge of SQL and related SQL procedure
languages.
·
OLAP experience is a plus
OLAP experience is a plus
·
Experience in managing date warehouse project and
lifecycle initiatives.
Experience in managing date warehouse project and
lifecycle initiatives.
·
Experience working with Teradata, Netezza, DB2 or
Hadoop is desired
Experience working with Teradata, Netezza, DB2 or
Hadoop is desired
How to Apply:
All suitably
qualified and interested candidates are encouraged to send their applications
addressed to the Permanent Secretary, MOH to the address below;
qualified and interested candidates are encouraged to send their applications
addressed to the Permanent Secretary, MOH to the address below;
Ministry of
Health,
Health,
Plot 6 Lourdel
Road, Room D213, Block D, 2nd Floor.
Road, Room D213, Block D, 2nd Floor.
P.O. Box 7272,
Kampala,
Kampala,
Kampala.
Uganda.
Uganda.
Deadline: 11th September 2015.
For more of the
latest jobs, please visit https://www.theugandanjobline.com
or find us on our facebook page https://www.facebook.com/UgandanJobline
latest jobs, please visit https://www.theugandanjobline.com
or find us on our facebook page https://www.facebook.com/UgandanJobline
Duty Station: Kampala, Uganda