Background
Vital Strategies is an international public health organization. Our programs strengthen public health systems and address the world’s leading causes of illness, injury and death. We currently work in 73 countries, supporting data-driven decision-making in government, advancing evidence-based public health policies, and mounting strategic communication campaigns. Vital Strategies’ priorities are driven by the greatest potential to improve and save lives. They include
non-communicable disease prevention, cardiovascular health promotion, tobacco control, road safety, obesity prevention, epidemic prevention, environmental health, vital statistics systems building, and multi-drug resistant tuberculosis treatment research. Please visit our website at www.vitalstrategies.org to find out more about our work.
This consultancy will support implementation of the Country Health Information Systems and Data Use (CHISU) project, a USAID Bureau for Global Health data and information system project. The project aims at strengthening country capacity and leadership to manage and use high quality health information systems to improve evidence-based decision-making. The project is funded by the U.S. Agency for International Development (USAID). JSI is the prime contractor for the project, with Vital Strategies as a partner organization, along with RTI International, Macro-Eyes, Jembi Health Systems, and the Global Evaluation and Monitoring Network for Health (GEMNet-Health)
The Consultancy
A key area of technical assistance offered through CHISU is to strengthen the development of digital tools at the Institute of Public Health (IPH) of Serbia "Dr Milan Jovanović Batut”, such as reports that make critical data sources more visual, more interactive, and more accessible to public health decision-makers and stakeholders.
The consultant will deliver training to subject matter and data experts and IT staff on foundational skills for using Power BI to design initial versions of specific digital tools and onunderstanding and applying best practices for data fields and data structure needed for optimal use in Power BI. In addition, the consultant will deliver additional training to a select group of staff on how to train additional IPH Batut members on foundational Power BI skills (train the trainer program). It is also expected that the consultant will provide general technical support to troubleshoot and clarify specific issues raised by the trained staff as they develop specific digital tools.
Deliverables
The consultant will be responsible for producing the following deliverables:
1. Foundational Training on Power BI skills
Deliver training to IPH Batut staff on the foundational skills for developing reports and data
modeling in Power BI, including but not limited to:
- Data models in Power Query and DAX
- ETL with Power Query
- Editing queries using M
- Date tables
- DAX Measures
- Authoring reports
- Visualizations
- Filters and interactions
- Formatting (dynamic titles, conditional formatting…)
- Advanced visualizations and custom visuals
2. Train selected staff as trainers
- Train a smaller number of staff on additional Power BI management such as deployment and administration as well as delivering tailored programs for building capacity among the selected staff to be able to train new or additional IPH Batut staff on the best use of Power BI.
3. Technical support
- Provide support for trained staff as they use Power BI to develop specific digital tool projects. Support would be offered on ad-hoc requests as well as through dedicated “office hours” where staff could raise any relevant questions on Power BI report creation and data modelling.
Assignment
This is a consultant position with an anticipated level of effort of 50 days. The consultant must be based In Serbia with the ability to meet with IPH Batut staff frequently. The duration of the project is 6 months; work is expected to be completed by December 2022. The following table provides a rough guide for the sequence of activities over the 6-month period.
The work will be overseen by Vital Strategies, a partner organization of CHISU based in New York City, USA. The contractor will also coordinate with CHISU’s country office in Serbia. Note that contracts are executed and paid in the currency of the country where the consultant is based and that payments are tied to deliverables.
Qualities and Qualifications
- Bachelor’s degree required
- Advanced knowledge of Power BI for developing reports
- Advanced knowledge of Power Query for data integration and transformation
- Knowledge of SharePoint and data management tools
- Experience delivering dedicated Power BI trainings
- Experience engaging and working remotely with stakeholders
- Preferred experience working with public health or healthcare data
- Written and oral English and Serbian language proficiency
Application
Submit a CV and cover letter including your daily rate electronically.