Intermediate BI Engineer

BETSoftware; Cape Town; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A prominent software company in Cape Town is looking for an Intermediate BI Engineer to design and develop Business Intelligence solutions using the Microsoft BI stack. The successful candidate will have 2-3 years of experience and will play a key role in analyzing and sharing data to improve business results. This is a rewarding opportunity in a dynamic environment that values collaboration and problem-solving.

Qualifications

• Minimum 2-3 years proven experience in Microsoft BI Stack.
• Ability to support and update existing products.
• Communicate with various departmental team members to understand business requirements.

Responsibilities

• Design, develop and maintain Business Intelligence solutions using Microsoft BI stack.
• Collect, analyze, and share data to drive improvement in key business metrics.
• Troubleshoot BI tools, systems, and software.

Skills

Experience in Microsoft BI Stack (SSIS, SSAS, SSRS, SQL)

End-user report development

ETL components

T-SQL query optimization

Database management systems

Education

Degree or diploma in IT or related technical discipline

Tools

Microsoft SQL

Job description

Job title

Intermediate BI Engineer

Job Location

Western Cape, Cape Town

Deadline

November 30, 2025

Quick Recommended Links

• Jobs by Location
• Job by industries

Responsibilities

Design, Development and Reporting :

• Ensures the Design, development and maintenance of Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.
• Responsible for the Creation of Stored procedures, dashboards, reports and ETL processes.
• Learn, use and maintain an established set of tools and technologies, as necessary.
• Follow project Specifications and corporate coding standards and policies.
• Must be able to provide support on the report offerings.
• Participates in workstream planning process including inception, technical design, development, testing and delivery of BI solutions.
• May participate in project management estimation process.
• Responsible for Developing demand forecasts.
• Collaborates with BI Analysts to understand customer needs.
• Analyses business and functional requirements and translates these requirements.
• Ensure all BI related incidents or service requests are resolved effectively.

Develop and Implement

• Responsible for Collecting, analysing and sharing data to help business teams drive improvement in key business metrics, customer experience, and business results.
• Ensures the Utilization of database and web application technologies to design, develop, and evaluate innovative business intelligence tools and automated reports.
• Designs, develops and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards.
• Performs data conversions, imports, and exports of data within and between internal and external software systems.
• Merges BI platforms with enterprise systems and applications.
• Enhances the performance of business intelligence tools by defining data to filter and indexes.
• Documents new and existing models, solutions, and implementations.

Production Support

• Troubleshoots BI tools, systems, and software.
• Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and / or reports.
• Tracks, monitors and analyses performance and production issues, and implements improvements.
• Supports and helps manage external resources, such as service providers and vendor support.

Quality Assurance

• Responsible for ensuring the collected data is within required quality standards.
• Maintains the quality of Metadata Repository by adding, modifying, and deleting data.
• Provides input to the development of data / information quality metrics.

Coaching / Mentoring

• Provides guidance, training, and problem-solving assistance to other team members.
• Designs and delivers end-user training and training materials.

Living our Spirit :

• Engages in cross-functional collaboration and problem solving whilst encourages a culture of inclusivity.
• Actively drives a culture of versatility and adaptability by modelling and encouraging team members to support each other not only within the department, but within BET Software as a whole.
• Shows up in an authentic manner and leverages off the team’s diversity to achieve deliverables.
• Views challenges as opportunities to expand on their knowledge base as well as encourages junior team members to do the same, and takes a creative approach to overcoming the challenges.

Qualifications

• Degree or diploma in IT or related technical discipline.
• Minimum 2-3 years proven experience in Microsoft BI Stack (SSIS, SSAS, SSRS, SQL).
• Experience in end-user report development.
• Experience with data staging (ETL) components.
• Ability to support and update existing products. Debugging, monitoring and troubleshooting BI solutions.
• Identify and resolve data reporting issues.
• Ability to create efficient T-SQL objects and processes according to spec (databases, tables, stored procedures, business rules and functions).
• Experience in T-SQL query optimization, troubleshooting and debugging.
• Understanding of database management systems, online analytical processing and ETL framework.
• Communicate with various departmental team members to understand the business requirements.
• Knowledge of the Kimball data warehouse lifecycle.
• Relevant Microsoft SQL certifications.
• Ability to work unsupervised.

Apply Before 10 / 16 / 2025

• Research / Data Analysis jobs