Junior BI Engineer: Power BI & SQL Specialist

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

Job summary

BETSoftware seeks a BI Developer to implement BI solutions using the Microsoft BI stack, including MS SQL Server, SSIS, SSAS, SSRS and Power BI. The role involves creating stored procedures, dashboards and ETL processes while adhering to project specifications and coding standards.

You will collaborate with Business Analysts to understand customer needs, support BI reporting offerings, and participate in workstream planning. Strong data handling and SQL skills are essential for success.

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 (MS SQL, SSIS, SSAS, SSRS, Power BI).
• Create stored procedures, dashboards, reports and ETL processes.
• Follow project specifications, coding standards and policies.
• Provide support on BI report offerings.
• Participate in or support workstream planning.
• Collaborate with Business Analysts to understand customer needs.
• Keep customers informed about BI tool issues and resolutions.

Skills

MS SQL Server

SSIS

SSAS

SSRS

Power BI

Education

Degree or diploma in IT or related technical discipline

Microsoft SQL certifications

Tools

SQL

Job description

BETSoftware seeks a BI Developer to implement BI solutions using the Microsoft BI stack, including MS SQL Server, SSIS, SSAS, SSRS and Power BI. The role involves creating stored procedures, dashboards and ETL processes while adhering to project specifications and coding standards.

You will collaborate with Business Analysts to understand customer needs, support BI reporting offerings, and participate in workstream planning. Strong data handling and SQL skills are essential for success.