19.05.2022
Business Intelligence Intern at Kyosk Digital Services
Kyosk Digital Services
Nairobi, KE, Kenya
ExcelPostgreSQLSQL
A kiosk is an informal convenience store selling everyday household items. Known locally by their vernacular names e.g. Duka in Kenya, Spaza in South Africa, Kantemba in Zambia. kiosk-type retail outlets are the cornerstone of African retail, accounting for over 60% of all retail trade flows. Despite their importance, kiosk-type retail outlets face significant challenges, including high cost of stock and unreliable delivery. Our digital ordering and delivery platform – Kyosk, ensures that these retail outlets get access to stock at competitive prices and have them delivered directly to them. FMCGs find the traditional distribution chain to be inadequate as well, making it expensive for them to serve kiosk-type retail outlets, leading to high incidences of product stock-outs and lost sales opportunities. By providing FMCGs with good data visibility, we solve this major problem of theirs.
Key Duties:
Work with Product Managers and business stakeholders to collect and document user-data requirements while defining scope and objectives of the desired outcomes.
Construct data workflow charts and dashboard wireframes and formats.
Prepare Data Studio reports and charts based on the user requirements
Support in delivering ad hoc data analysis reports and dashboards.
Explore data sources to better understand the availability and quality of data for some analytics requests
Requirements
Minimum Skills
1+ years exposure to a related field as Business Analyst or Data Scientist;
Solid understanding of reporting platforms including Google, Data Studio and Advanced Microsoft Excel;
Ability to write SQL queries for retrieving data from a relational database like PostgreSQL and Google BigQuery;
Ability to develop proper dashboard and database schema documentation;
Excellent communication and presentation skills;
Collaborate and work closely with Product Managers and Functional Managers in mapping out data requirements;
Python skills and experience are very nice to have;
Ability to handle multiple projects at the same time and prioritize work.
Academic and Professional Qualifications
Bsc Computer Science/Mathematics/Statistics or any other relevant degree.
Desired Competencies
Technical Competence;
Stakeholder Management;
Analytical Thinking;
Problem Solving Skills;
Team Player;
Tech Savvy.
[external_job_redirect_notice]