BI Developer

iOCO Pty Ltd; Johannesburg; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A technology solutions company in Johannesburg seeks a Business Intelligence Developer to manage and optimize data environments for HR and Payroll. Responsibilities include designing SQL-based BI solutions, building Power BI dashboards, and ensuring data integrity. Ideal candidates have proven experience with SQL Server and Power BI, and a degree in Computer Science is preferred. The role demands strong communication skills and experience with large-scale databases.

Qualifications

• Proven experience with SQL Server and related BI stack components.
• Strong knowledge of Power BI development, DAX, and performance tuning.
• Experience with multi-terabyte databases is essential.
• Solid understanding of integration design and ETL pipelines.

Responsibilities

• Design and maintain SQL-based BI solutions for HR and Payroll.
• Build and optimize Power BI dashboards and visualizations.
• Manage and maintain multi-terabyte databases ensuring performance.
• Collaborate with stakeholders to translate requirements into solutions.

Skills

SQL Server

Power BI

DAX

Data modeling

ETL processes

Automation

Communication skills

Education

Degree in Computer Science, Information Systems, or related field

Tools

SSRS

SSIS

SSAS

Job description

We are looking for a skilled Business Intelligence Developer to join our internal team supporting a key client in the Mining and Construction sector. This role focuses on managing and optimizing large-scale data environments within the Human Capital Management (HR and Payroll) domain, ensuring data integrity, insightful reporting, and seamless integration across multiple systems.

What You’ll Do

• Design, develop, and maintain SQL-based BI solutions to support business decision-making within the HR and Payroll landscape.
• Build and optimize Power BI dashboards and visualizations, ensuring accuracy, clarity, and performance.
• Develop and support SSRS reports and integrations, enabling efficient data flow across enterprise systems.
• Manage and maintain data within multi-terabyte databases, ensuring scalability, performance, and data governance compliance.
• Collaborate with business and technical stakeholders to gather requirements, translate them into technical solutions, and deliver actionable insights.
• Oversee and maintain 80+ data integrations across third-party applications and client line-of-business (LOB) systems.
• Contribute to continuous improvement initiatives across BI architecture, ETL processes, and reporting frameworks.

What We’re Looking For

Experience

• Proven experience with SQL Server and related BI stack components (SSRS, SSIS, SSAS).
• Strong knowledge of Power BI development, including DAX, data modeling, and performance tuning.
• Experience working with large-scale databases (multi-terabyte environments).
• Solid understanding of integration design, ETL pipelines, and automation within complex data ecosystems.
• Experience supporting Human Capital Management systems (HR and Payroll) is highly advantageous.
• Excellent communication skills and stakeholder engagement capability.

Preferred Qualifications

• Degree in Computer Science, Information Systems, or related field.
• Experience in the Mining or Construction industry will be an advantage.
• Familiarity with data warehousing concepts, performance optimization, and data security best practices.