Junior Business Intelligence Analyst

Reporting to: Head of Data

Location: Nairobi, Kenya

Role type: Full Time

About SunCulture:

Founded in 2012, SunCulture’s Vision is to build a world where people take control of their environment in rewarding and sustainable ways. SunCulture does this by developing and commercializing life changing technology that solves the biggest daily challenges for the world’s 570 million smallholder farming households. We are the largest distributor of solar water pumps / solar irrigation for smallholder farmers in Africa and were selected by Fast Company as one of the World’s Most Innovative Companies in 2021. Here is a good explainer video recently made by CNBC. Over the last 5 years the company has grown significantly and now employs 400+ people around the world.

About the role

The Junior Business Intelligence (BI) Analyst will join our growing analytics team and will work closely with the data team to ensure the accuracy, reliability, and timeliness of our business KPIs through analytics and reporting. The junior BI Analyst will assist in integrating data assets from various systems and sources (external and internal) into the company’s systems, ensuring high-quality data flows and contributing to the development of insightful dashboards and reports. This role involves supporting multiple teams, systems, and products by providing actionable insights and maintaining high data quality standards.

Key Responsibilities

• KPI Analytics & Reporting: Develop, maintain, and enhance dashboards and reports that track and visualize key business KPIs.
• Data Quality Oversight: Investigate, troubleshoot, and document data issues from various sources, ensuring data integrity across all business processes.
• Data Integration: Assist in integrating and monitoring data from various sources, ensuring it meets the required standards for reporting and analytics.
• Automation: Drive automation of current reporting processes using tools such as PowerBI, MS Excel & VBA, and Data Studio.
• Stakeholder Engagement: Partner with internal clients and key stakeholders to understand their reporting and analytical needs, translating them into actionable dashboards and reports.
• Documentation Management: Manage and maintain documentation related to data quality, including data standards, definitions, checklists, guidelines, manuals, templates, and forms.
• Continuous Improvement: Proactively work to improve BI Service SLAs, enhance data quality, and ensure on-time, on-budget delivery of projects and enhancements.

Qualifications

• Knowledge of research methods, statistical or data analysis, and strong analytical/problem-solving and decision-making skills
• Bachelor’s Degree in Information, Communication and Technology, Mathematics, Statistics, or equivalent and at least a Diploma in Analytics
• Experience with data modeling, data warehousing, and ETL processes is a plus
• Ability to analyze large datasets and provide valuable insights based on data analysis
• Basic working knowledge of SQL and NoSQL databases, including Postgres, MongoDB, and Cassandra
• Advanced knowledge of Excel, Power Query, and Dax is a plus.
• A minimum of 1 year of work experience is required.
• Strong verbal and written communication
• Detail oriented with ability to make proper assumptions and recommendations.
• The ability to work both as a team and independently