Generate relevant market intelligence:

• Perform market research on the agreed number of vaccine markets. The research should look into vaccine manufacturers, prices, pipeline, approval, and development status through media monitoring, desk research, internal sources etc. The exact vaccines markets for research are to be defined by SD, SMC, and other centers.
• Create and connect data sources, import, and transform data for market intelligence. Translate data into informative visuals and reports.
• Document, maintain and regularly update the collected information on vaccine markets and data sources
• Perform ad-hoc data analysis. Given the request, this will include identifying the best way forward and methodology, collecting the information from identified sources (which may include ERP systems, existing dashboards, and external sources), organizing the information, performing the analysis, and presenting it in the most suitable format and platform.
• With the ability to properly understand the business requirements, the consultant will conceptualize, develop, and implement business process and solutions that can result in relevant market intelligence, and improved data monitoring and/or reporting.

Maintenance, administration, and development of MS Power BI dashboards:

• Maintenance and administration of the Vaccine Markets Dashboard and other dashboards when needed. It includes ensuring daily operation of the dashboard, spotting technical / data errors and ensuring corrective actions are taken, and ensuring underlying data is refreshed as planned.
• Improvement of data infrastructure for existing MS Power BI dashboard
• Respond to queries (data extracts and reports) for Vaccine Market Dashboards and other dashboards managed by SMC
• Development of new Power BI dashboard as necessary. It includes connecting to data sources, creating tables and data connections, creation of frames and visualizations, and overall administration of the Power BI dashboard (including operation and maintenance).
• Update and maintain the dashboards traffic report when needed.

  Reliable master data quality:

• Ensure master data is reliable and quality assured.
• Regularly perform benchmarks of information to ensure data is as comprehensive as possible.
• Monitor the dashboards, and if/when needed, reach out to relevant stakeholders to implement preventive and corrective actions to ensure data quality.
• Perform and automate a rigorous data quality assurance processes to ensure data quality and completeness.

  Provide documentation and training:

• Ensure relevant documentation is in place, and provide a final report with all relevant data/materials/outputs produced during the assignment
• The consultant shall provide all needed documentation related to reports/dashboards and design development as needed such as: data model diagrams, main query logic, etc. The consultant is expected to provide colleagues with initial training and documentation on the maintenance of the BI analytics dashboard, including data sources and data models.

The consultant will interact with UNICEF staff to receive any clarifications and guidance that may be needed. The consultant may also engage with external service providers to request inputs needed to develop the required deliverables. On a weekly basis, the consultant’s work will be coordinated with the Market Research Officer. Each deliverable will be delivered in draft for comments and feedback before finalization.

The Consultant will duly inform UNICEF of any problems, issues or delays arising in the course of implementation of assignment and take necessary steps to address them.

All reports and results are to be submitted to the UNICEF in electronic form (*.pbix, *.docx, *.xlsx, *.pptx, and *.pdf or other formats accepted by UNICEF).

Requirements:

• An advanced university degree (Master’s or higher) in Information Systems Management, Data Science, Statistics, Engineering, Economics, or other relevant filed is required.
• A relevant first level university degree in the above areas combined with 5 years of relevant qualifying experience may be accepted in lieu of the advanced university degree.
• A minimum of two (2) years professional work experience with proficiency in use of data processing, data warehouse, data reporting, data visualization, data analysis, business intelligence, and performance monitoring is required.
• Good knowledge of vaccine markets in the development contexts
• Strong skillset in MS Power BI and knowledge of DAX
• Strong skillset in Excel, including complex formulas and pivot tables
• Systems competent, preferable with knowledge of SAP, data warehousing, SQL and able to use the MS standard computer software
• Good presentation skills and experience with communicating analysis results visually and in writing
• Good knowledge of planning and/or project management principles and practices.
• Fluency in English is required. Knowledge of another official UN language (Arabic, Chinese, French, Russian or Spanish) is an asset.

Desired experience/qualifications:

• A high level of attention to detail
• Proven ability to work independently
• Knowledge and experience in market research and/or market data analysis is considered an asset