BI Analyst

Position: BI 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
A BI Analyst serves as the central point of expertise for business intelligence within our organization, acting as the go-to resource for PowerBI-driven reporting and analytics. This role leverages deep PowerBI proficiency to accelerate dashboard development, ensure data integrity, and drive actionable insights with a mastery of PowerBI, ready to deliver immediate value through expert-level dashboard development and analytics. Fueled by curiosity, innovation, and a strong sense of ownership, the BI Analyst proactively seeks opportunities to simplify processes, uncover insights through self-discovery, and take full responsibility for delivering high-impact solutions that exceed expectations. The BI Analyst collaborates across teams to align data visualizations with business needs, optimizes existing dashboards, performs root cause analyses, and maintains a trusted, efficient reporting ecosystem.

Responsibilities

• Business Collaboration and Requirements Gathering: Partner with department heads, business users, and other teams to identify reporting needs, challenges, and opportunities. Translate stakeholder requirements into impactful PowerBI dashboards or enhancements that track key metrics and KPIs, ensuring alignment with business goals. Provide clear timelines, prioritize deliverables, and foster trust through effective communication and polished solutions that enable real-time, data-driven decisions.
• Data Visualization and Reporting: Design and develop intuitive, high-impact visualizations and reports using PowerBI, ensuring they communicate insights clearly and support strategic initiatives.
• Data Engineering Collaboration: Coordinate with data engineers to specify required data points, formats, and structures for the data warehouse, ensuring 99.99% accuracy and availability for dashboard consumption.
• Dashboard Optimization and Maintenance: Analyze usage patterns of existing dashboards to identify underutilized ones for retirement, maintaining an optimal portfolio (not too many, not too few). Simplify layouts, optimize backend DAX queries to reduce latency, and proactively enhance dashboards to anticipate future business needs and improve efficiency.
• Dashboard Access Management: Implement and manage role-based access control (RBAC) for dashboards, ensuring appropriate permissions for relevant stakeholders without over-provisioning. Monitor usage patterns and streamline access as needed to maintain security, compliance, and operational efficiency.
• Ad Hoc Analytics and Root Cause Analysis: Address one-off requests beyond standard dashboards, including deep dives into data trends, hypothesis testing, anomaly investigations, or explaining underlying factors behind descriptive metrics. Support quick analyses, minor dashboard tweaks, lightweight reports for MVPs/projects, and raw data extractions (e.g., CSV/Excel) or historical backfills from available source systems, ensuring the highest standards of data accuracy.
• Continuous Improvement: Stay abreast of emerging trends, tools, and best practices in business intelligence. Driven by curiosity and innovation, proactively identify and implement process enhancements—such as streamlined data extraction or optimized analytics workflows—to reduce manual efforts and enhance efficiency. Take ownership of initiatives, ensuring follow-through to completion and delivering solutions that foster a culture of data trust.

Qualifications

• Bachelor's degree in Mathematics, Statistics, Computer Science, Economics, or a related field.
• Minimum of 5 years of experience as a BI Analyst, BI Developer, or Data Analyst, with a proven track record in dashboard development and analytics.
• Demonstrated expertise in designing and implementing PowerBI dashboards, including complex visualizations and interactive elements.
• Strong interpersonal and communication skills, with the ability to engage, influence, and build trust with both technical and non-technical stakeholders.
• Exceptional presentation abilities, capable of distilling complex data into accessible narratives for diverse audiences.
• Strategic thinker with an innovative mindset, skilled at transforming business challenges into practical, data-backed solutions.
• Creative problem-solver who thrives in dynamic environments and prioritizes accuracy and efficiency.

Required Skills

• Business Intelligence & Analytics: Proven expertise in data visualization and BI tools, with a strong focus on Microsoft PowerBI for creating dashboards that inform real-time strategic decisions.
• PowerBI Stack Proficiency: Hands-on experience with Power Query, DAX, MDX, and PowerBI Desktop, including writing and optimizing DAX queries.
• Data Handling: Technical skills in mining, cleaning, and analyzing data using databases and analytics tools.
• SQL Expertise: Strong working knowledge of SQL in relational databases and ClickHouse data warehouses, including advanced techniques like joins, window functions, CTEs, aggregations, and query optimization for large datasets.
• Programming: Solid experience with Python for data analysis, automation, and scripting is preferred.
• Collaboration and Communication: A team player who builds professional relationships across departments, with excellent skills in presenting complex findings to non-technical stakeholders.

Preferred Skills

• Experience in credit, lending, or financial services industries.
• Familiarity with machine learning concepts and their applications in analytics.

Success Measures (KPIs)

• Timely resolution of ad hoc requests, with demonstrated business impact (e.g., cost savings or process improvements).
• Positive stakeholder feedback on the relevance, clarity, accuracy, and usefulness of dashboards and insights.
• Increased user adoption of dashboards, measured by reduced use of offline tools like Google Sheets.
• Decrease in repetitive ad hoc requests through enhanced self-service features and proactive dashboard optimizations.
• High satisfaction scores from business teams on data usability, support quality, and overall collaboration.
• Direct contributions to key business outcomes, such as improved sales conversions or reduced loan arrears, linked to adopted insights.

Interested?

Please apply online via this job portal. We respond to all candidates; however only shortlisted candidates will be interviewed.

Please Note

SunCulture is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable laws, regulations, and ordinances.