Junior Business Intelligence Support

BETSoftware; Gauteng; On-site; ZAR 300,000 - 600,000; Full time

Job summary

A leading software provider in South Africa seeks a BI Developer to design, implement, and support Business Intelligence solutions using the Microsoft BI stack. The ideal candidate will have experience in MS SQL, SSIS, SSAS, SSRS, and Power BI, ensuring production support and development of ETL processes. This role offers a dynamic work environment focused on collaboration and growth.

Qualifications

• Minimum 1+ years proven experience in Microsoft BI Stack.
• Experience in end-user report development.
• Experience with data staging ETL components.

Responsibilities

• Develop and test BI solutions including databases, queries, views, and dashboards.
• Troubleshoot BI tools and systems in production.
• Monitor scheduled ETL and cube refresh jobs.

Skills

Microsoft BI Stack experience

T-SQL expertise

ETL processes

Database management

Data validation skills

Education

Degree or diploma in IT or related technical discipline

Tools

MS SQL Server

SSIS

SSAS

SSRS

Power BI

Job description

Job Description

• BI Stack – MS SQL, SSIS, SSAS, SSRS and PowerBI
• T-SQL objects
• PowerBI Dashboards
• ETL components
• Requirements analysis
• Development and testing of BI solutions (Databases, queries, views, reports and Dashboards)
• Data import and export
• Job monitoring
• Data validation
  
  

Responsibilities

Production Support

• Ensures troubleshooting of BI tools, systems and software.
• Ability to track performance and production issues.
• Escalates production issues as appropriate.
• Monitors and supports scheduled ETL and cube refresh jobs, ensuring successful completion and accurate data loads into reporting systems.
• Takes ownership of job validation, proactively identifying and resolving failures or delays that may impact data availability or quality.
• Participates in a rotational working shift schedule, which may include early mornings, evenings, weekends, and public holidays, to support critical business operations and ensure continuous system availability.
• Documents production incidents, escalates issues as appropriate, and provides clear communication to stakeholders regarding the status and resolution of job-related issues.
• Tracks and reports on system performance and production issues; may assist in performance tuning of BI applications for optimal efficiency.
  
  

Reporting And Implementation

• Ability to implement 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.
• Must be able to follow project Specifications, incorporate coding standards and policies.
• Must be able to provide support on the report offerings.
• Participates in or supports workstream planning processes.
• Collaborates with the Business Analysts to understand customer needs.
• Keeps customers informed about business intelligence tool problems and resolutions, timeously.
  
  

Develop and Implement

• Responsible for collecting, analysing and sharing of data to help business teams drive improvement in key business metrics, customer experience and business results.
• Utilizes database and web application technologies to investigate and evaluate processes and can suggest innovative ways of identifying errors.
• Develops and tests BI solutions such as databases, queries, views, reports, and dashboards.
• Assists in data conversions, imports, and exports of data within and between internal and external software systems.
• Documents new and existing models, solutions and implementations.
• Design and build reporting and analysis tools that help streamline the business and make reporting, analysing, planning and forecasting more efficient.
• Supports and assists with the integration of BI platforms with enterprise systems and applications.
  
  

Quality Assurance

• Responsible for Performing Quality checks on all work before giving approval to the stakeholder.
• Ensures the collected data is within required quality standards.
• May maintain the quality of Metadata Repository by adding, modifying, and deleting data.
  
  

Qualifications

• Degree or diploma in IT or related technical discipline.
• Minimum 1+ 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, and debugging, monitoring, and troubleshooting BI solutions.
• 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.
  
  

About Us

We Don't Just Recruit Talent... We Cultivate It

BET Software is one of the most diverse betting software providers in Sub-Saharan Africa, with a rapidly growing international footprint. Our multiskilled Team is responsible for providing advanced software solutions, while supporting incredibly high transactional volumes in a fast-paced industry, making BET Software a lively and engaging place to be.

Our progressive use of technology enables our talented Team to work with the tech stack of their choice and we encourage an environment and culture that supports collaboration, learning, and growth. We believe that our strength lies in our diversity and that Teamwork makes the dream work, a place where you can flourish amongst like-minded individuals.

We are a dynamic group of people that stem from a variety of cultures, backgrounds, and locations. While our head office is based in Umhlanga, South Africa we recruit talent throughout South Africa and Internationally.