UNDP Dashboard and Analytics Consultant Jobs in Uganda

UNDP Dashboard and Analytics Consultant Jobs in Uganda


Background

  • UNCDF is the UN’s capital investment agency for the world’s 47 least developed countries.

  • With its capital mandate and instruments, UNCDF offers “last mile” finance models that unlock public and private resources, especially at the domestic level, to reduce poverty and support local economic development.

  • UNCDF strategy ‘Leaving no one behind in the digital era’ is based on over a decade of experience in digital finance in Africa, Asia and the Pacific.

  • UNCDF recognizes that reaching the full potential of digital financial inclusion in support of the Sustainable Development Goals aligns with the vision of promoting digital economies that leave no one behind.

  • The Consultant will be responsible for designing, developing, testing and deploying robust and scalable big data ETL (Extraction, Transformation, Load) pipelines to support in data analytics and generating key indicators based on simulated and (or) actual telecoms GSM and mobile money data and effectively visualizing UNCDF's qualitative and quantitative data including performance indicators.

    The objective of this assignment is two-fold:

  • Develop PowerBi dashboards that consolidate and visualize data from telecom providers in Uganda.

  • The dashboard will be used by the UNCDF team to better target interventions and monitor results of ongoing activities.

  • Extract, clean and consolidate relevant data from the MTN Management Information System and update the PowerBi dashboard.

    Duties and Responsibilities

    The dashboard has several levels:

  • Ecosystem-level: This dashboard shows information on providers’ total customer base at national, regional, sub-regional and district level.

  • The information is related to mobile phone and mobile money penetration, mobile money usage, mobile money transactions, and agent and merchant coverage, disaggregated by sex and age group (youth, elderly).

  • The list of indicators and level of disaggregation will be finalized during the project inception phase.

  • The objective of this dashboard is to track the digital ecosystem development, identify gaps and use the information to better target UNCDF interventions.

  • UNCDF project-level: These dashboards show the results of UNCDF projects across a set of standard key performance indicators and indicators customized to the digital solution that is developed and tested.

  • UNCDF country-level: This dashboard consolidates the results from the various UNCDF projects across a set of key performance indicators.

    Under the supervision of the the Results Measurement Analyst the Dashboard and Analytics Consultant will be responsible for the following activities and deliverables:

  • Inception: Conduct meetings with UNCDF team, finalize indicators and develop workplan

  • Final list of indicators

  • Workplan

    Develop the PowerBi dashboards

  • Dashboard structure and design for the three levels (Ecosystem, UNCDF projects, UNCDF country)

    Telecoms synthetic data generation and Data extraction,
    transformation and loading pipeline development


  • Synthetic data for initially populating designed dashboards

  • ETL pipelines

    Extract, clean and consolidate MTN data and populate the dashboards (ecosystem and project)

  • Updated MTN dashboards (ecosystem and project)

    Develop data governance document

  • Dashboard governance document

  • Reporting templates

    Train the UNCDF team on using the dashboard

  • Training materials

  • Manual

    Extract, clean and consolidate MTN data and update the dashboards (ecosystem and project)

  • Updated MTN dashboards (ecosystem and project)

    Review the dashboards (Ecosystem, UNCDF projects, UNCDF country)

  • Updated dashboard structure and design

    Competencies

  • The consultant must have demonstrable experience in building software tools to generate synthetic telecoms GSM and mobile money data

  • Hands-on experience in analyzing complex telecoms data

  • Building automated, robust, and scalable big data ETL pipelines to load data from disparate data sources

  • Automated reporting and dashboards development

  • Experience with Apache Spark and Hadoop ecosystem related technologies

  • Ability to scope, design and deliver various Big Data solutions

  • Design and implementation of modern Data APIs for both internal and external data access

  • Collaborate with other development and research teams

    Required Skills and Experience

    Education

  • Master’s degree in Computer Science, Engineering, Mathematics, Data Science or other relevant advanced degree is mandatory

    Experience

  • 5+ years of experience of IT platform implementation in a highly technical and analytical roles is mandatory

  • Expertise in the use of Power BI is mandatory

  • Knowledge of Data Lake/Hadoop platform implementation, including hands-on experience in implementation and performance tuning Hadoop/Spark implementations is preferred
    Understanding of Apache Hadoop and the Hadoop ecosystem.

  • Experience with one or more relevant tools (Sqoop, Flume, Kafka, Oozie, Hue, Zookeeper, HCatalog, Solr, Avro) is preferred

  • Familiarity with one or more SQL-on-Hadoop technology (Hive, Impala, Spark SQL, Presto) is preferred

  • Experience developing software in one or more programming languages (Java, Python, Scala, R)

  • Current hands-on implementation experience in Advanced large scale ETL development

  • Working knowledge of Big Data tools, Python, R, Air Flow, Red Shift, Athena, RabitMQ
    Hands-on experience in building robust enterprise level data APIs

    Language requirements

  • Spoken and written proficiency in English is mandatory.

    How to Apply

    For more information and job application details, see; UNDP Dashboard and Analytics Consultant Jobs in Uganda

    Find jobs in Uganda.Jobs - Uganda jobs. Search our career portal & find the latest Ugandan job positions, career opportunities & jobs in Uganda.

    Jobs in Uganda - banking jobs, IT jobs, accounting jobs, NGO jobs, business administration, ICT, UN jobs, procurement jobs, education jobs, hospital jobs, human resources jobs, engineering, teaching jobs, and other careers in Uganda.

    Find your dream job from 1000s of vacancies in Uganda posted and updated daily - click here!



  • Click here to post comments

    Join in and write your own page! It's easy to do. How? Simply click here to return to NGO Jobs in Africa.

    Scholarship 2021/22

    Current Scholarships 2021/2022 - Fully Funded

    Full Undergraduate Scholarships 2021/2022

    Fully Funded Masters Scholarships 2020/21

    PhD Scholarships for International Students - Fully Funded!


    Funding Opportunities for Journalists 2021/2022


    Funding for NGOs 2021/2022


    Funding for Artists 2021/2022


    Funding for Entrepreneurs 2021/2022