UNDP Dashboard and Analytics Consultant Jobs in Uganda
UNDP Dashboard and Analytics Consultant Jobs in Uganda
BackgroundUNCDF 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.
