Business Intelligence Developer – SSBID

Armstrong Appointments; Durban; On-site; ZAR 600 000 - 900 000; Full time

Job summary

A leading recruitment agency in Durban is seeking a skilled professional to manage SQL development, data pipelines, and reporting. The ideal candidate will possess a strong foundation in data architecture and BI tools. Responsibilities include designing scalable data models, optimizing database performance, and building ETL processes. Required skills include proficiency in SQL Server and experience with Power BI. This opportunity offers growth within a dynamic environment.

Qualifications

• Proven experience designing and developing data warehouse solutions.
• Deep understanding of database technologies, OLAP concepts, and ETL frameworks.
• Excellent problem-solving and critical-thinking abilities.

Responsibilities

• Design and implement scalable data models and BI solutions.
• Build and maintain ETL processes to consolidate data.
• Monitor and optimize database performance.

Skills

SQL development

Data architecture

Business intelligence tools

Analytical thinking

Data visualization

Tools

SQL Server

Power BI

Microsoft Fabric

SSIS

SSAS

SSRS

Job description

We are seeking a skilled and detail-oriented professional to fill a role that encompasses SQL development, report writing, and data engineering. The ideal candidate will be responsible for managing data pipelines, developing and optimizing SQL queries, building reports and dashboards, and supporting the business with actionable data insights. This opportunity is ideal for a technically strong professional with a solid foundation in SQL, data architecture, and BI tools.

Key Responsibilities

• Design and implement scalable data models, data warehouses, and BI solutions including reports and dashboards.
• Build and maintain ETL processes to consolidate data from a variety of structured and unstructured sources.
• Monitor and optimize database performance through indexing, query tuning, and regular maintenance.
• Develop and execute complex SQL queries to support analytics and reporting requirements.
• Collaborate with stakeholders across departments to deliver integrated data solutions.
• Continuously improve reporting frameworks and ensure data reliability and accessibility.
• Oversee database administration tasks, maintaining high standards of data quality, availability, and security.
• Implement and manage disaster recovery and high-availability solutions such as replication, clustering, and failover systems.

Core Requirements

• Proven experience designing and developing data warehouse solutions.
• Strong analytical background with the ability to interpret business needs through data.
• Deep understanding of database technologies, OLAP concepts, and ETL frameworks.
• Ability to present insights effectively using data visualization techniques.
• Experience working with diverse data sources including flat files and APIs.
• Capable of operating independently within established processes and guidelines.
• Excellent problem-solving and critical-thinking abilities.

Technical Skills

• Proficient in SQL Server
• Expertise with Power BI, Microsoft Fabric, DAX, T-SQL
• Experience with SSIS, SSAS, and SSRS
• Solid understanding of database administration practices
• Exposure to cloud-based platforms such as Azure SQL or AWS RDS is a plus
• Familiarity with data environments in the retail or FMCG sectors is an advantage
• Deep understanding of data structures, algorithms, and system design for performance, scalability, and availability

A Consultant will be in touch if you are shortlisted for the position. Please consider your application unsuccessful should you not have been contacted within 2 weeks. We will keep your CV on our database and contact you should you match the criteria of any other vacancies.