Business Intelligence Analyst (Data Warehousing Analyst)

Categories Business Analyst
Salary Market Related
Location Western Cape
Job Information

Job Spec:

Our client in Cape Town requires a Business Intelligence Analyst (Data Warehousing Analyst) for a permanent role. The successful candidate will be required to perform all listed functions for Organisation’s SA and Rest of Africa.


  • Relevant Information Technology Degree or Diploma


  • Full BI Development Cycle (End to end implementation of DW and BI projects)
  • In-depth understanding of database management systems, OLAP and ETL framework

SSIS at an advanced level for Data integration

SQL database for table creation and data optimization

SSAS and Tabular services for the presentation layer

Advanced TSQL to write complex queries

DataWarehouse design (dimensional modelling, architecture, data mining)

  • Translate business needs to technical specifications
  • Designing, developing, deploy, documenting and maintaining BI solutions
  • Design and develop data mappings and ETL scripts
  • Dashboarding
  • Evaluate and improve existing BI systems, tools, maintenance and procedures
  • Designing and implementing reporting solutions
  • Aligning Key Performance Indicators, reporting and analytics
  • Develop and Update Business & Technical documentation
  • Writing relational and multidimensional database queries
  • Debugging, monitoring and troubleshooting BI solutions


  • 5+ years of proven experience in Full Microsoft BI Stack Framework as a BI Developer
  • Experience building business reports using Excel or BI tools
  • General user assistance and training as required
  • Collaborate with teams to integrate systems


  • Working knowledge on translating business needs into technical specifications
  • Strong analytical, troubleshooting skills and root-cause analysis
  • Advanced knowledge of Microsoft Excel (pivot tables, formulas)

If you have not heard from us after 2 weeks, please consider your application unsuccessful.

Apply Now ยป