BI Engineer I: Power BI & SQL Analytics

BETSoftware; Johannesburg; On-site; ZAR 420,000 - 720,000; Full time

Job summary

BET Software in Johannesburg seeks a data-driven BI professional with 1+ year of experience in the Microsoft BI stack (SSIS, SSAS, SSRS, SQL) and Power BI to design and deliver end-to-end BI solutions. You will create stored procedures, dashboards and reports, develop ETL processes, and maintain a set of tools and technologies, ensuring alignment with project specifications and coding standards.

Collaborating with Business Analysts, you’ll translate customer needs into actionable insights,

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.

Responsibilities

• Implement BI solutions using Microsoft BI stack (SSIS/SSAS/SSRS/Power BI).
• Create stored procedures, dashboards, reports and ETL processes.
• Learn, use and maintain established tools and technologies as necessary.
• Follow project specifications and coding standards.
• Provide support on BI reports.
• Collaborate with Business Analysts to understand customer needs.
• Keep customers informed about BI tool issues and resolutions.

Skills

Power BI

SQL/T-SQL

ETL

Data analysis

Education

Degree or diploma in IT or related technical discipline

Tools

SSIS

SSAS

SSRS

SQL Server

Power BI

Job description

BET Software in Johannesburg seeks a data-driven BI professional with 1+ year of experience in the Microsoft BI stack (SSIS, SSAS, SSRS, SQL) and Power BI to design and deliver end-to-end BI solutions. You will create stored procedures, dashboards and reports, develop ETL processes, and maintain a set of tools and technologies, ensuring alignment with project specifications and coding standards.

Collaborating with Business Analysts, you’ll translate customer needs into actionable insights,