Business Intelligence Analyst

Entrepreneurial and independent, with a sound background in business analysis, the successful candidate will be capable of:

  • Investigating business systems, taking a holistic view of the situation, including organisation structure and governance, key stakeholder needs and staffing issues as well as current processes and IT systems.
  • Collecting requirements through standard techniques like document analysis, interviews, focus groups, workshops, customer journey and other process mapping and design thinking.
  • Documenting business requirements using appropriate documentation standards.
  • Working collaboratively internally and with partners to deliver chosen solutions.

Key Responsibilities

  • Working closely with clients, gathering requirements and translating them.
  • Ingesting data from a variety of corporate data sources and performing required transformations in Power BI query editor.
  • Data modelling capabilities including designing effective BI data models in line with the Kimball methodology and CDM.
  • Developing calculations in DAX which are accurate and performant on large datasets.
  • Designing effective layouts using themes and report grids, working closely with our UX design team.
  • Utilising the navigation features in Power BI (e.g. bookmarks, drill-throughs) to guide readers through a compelling data-driven story.
  • Working with different business units to manage User Acceptance Testing (UAT) processes and fixing any defects identified.
  • Publishing reports via the Power BI service, managing them through distribution of apps and monitoring usage/data refreshes/security access.
  • Shaping an approach for governance and deployment of Power BI in mid-size organisations, including advising on licensing, distribution/sharing, training and support.

Key Skills Required


  • 2+ years’ experience as a Business Intelligence developer using the Microsoft BI stack e.g. SQL Server database, SSIS, SSAS, SSRS, Power BI
  • Very strong SQL skills for querying and creation of views/tables, functions and stored procedures.
  • Experience in designing ETL processes including knowledge of data warehousing strategies and theories.
  • Build dashboards, reports and cubes using SQL, MDX, DAX, Power BI or other visualisation tools.
  • Develop new or maintain and improve existing ETL processes.
  • Articulate and document architectural solutions and processes.
  • Attend technical and business meetings and act as a subject matter expert.
  • Establish and maintain collaborative relationships with stakeholders.
  • Understanding dimensional modelling ideally for Financial Services and Public Sector.
  • Knowledge of cloud computing, preferably on AWS.


  • Experience in renewable energy industries.
  • Hands-on experience developing ETL solutions using Python.
WiSolar is a privately owned green digital utility (GDU) on a mission to provide low-cost, low-carbon, and on demand electricity. The company is transforming the way our world is powered with solar electricity for everyone, by making solar electricity accessible, and just as affordable as your home WiFi. WiSolar has been providing solar financing to homeowners in South Africa since June 2020 in an effort to make solar electricity accessible to consumers across the country and reducing reliance on fossil fuels. Through the app platform, low-cost prepaid solar electricity can be purchased per kWh for lifestyle estate communities, affordable housing communities, and retirement communities across Africa.