Business Intelligence (BI) / SQL Developer

iDbase Software; Sandton; Híbrido; ZAR 650.000 - 900.000; Jornada completa

Descripción de la vacante

iDbase Software is seeking a skilled BI/SQL Developer to design, build, and maintain enterprise data pipelines and data warehouses. You will transform transactional data into insights using the SQL data platform and Power BI ecosystem.

Responsibilities include ETL/ELT development, data modeling, and creating visual dashboards. Collaboration with cross-functional teams and governance of data accuracy are key success factors.

Formación

• 5–7+ years in SQL development and BI solutions.
• Experience with enterprise-scale data transformations.
• Degree or Diploma in IT/CS or related discipline.
• Microsoft Certifications (PL-300/DP-203) are advantageous.

Responsabilidades

• Design, build, and maintain enterprise data warehouses and star schemas.
• Develop and optimize ETL/ELT pipelines and data flows.
• Create complex Power BI dashboards and KPIs for stakeholders.
• Tune SQL Server performance and manage security, roles, and access.

Conocimientos

SQL Development

Power BI

ETL/ELT

Azure Data Factory

Data Modeling

Educación

Bachelor's Degree in IT/CS

Microsoft Certifications (PL-300 / DP-203)

Herramientas

SSIS

Azure Data Factory

Azure Synapse

Power BI Service

Descripción del empleo

Job Title: Business Intelligence (BI) / SQL Developer

Location: Benmore, Sandton (Hybrid – 3 days onsite)

Position Type: Contract

Industry: Education / Enterprise Services

Position Overview

We are looking for a skilled BI / SQL Developer to join Idbase’s central data team. In this role, you will design, develop, and maintain enterprise data pipelines, relational warehouse structures, and analytical reporting models. You will collaborate closely with cross-functional business stakeholders to transform complex transactional data into actionable insights using the Microsoft SQL Data Platform and Power BI ecosystem.

Key Responsibilities

• Data Warehouse & Database Engineering:

• Design, build, and optimize relational data models, star schemas, and data warehouse structures.

• Write high-performance T-SQL queries, Stored Procedures, Views, and User-Defined Functions.

• Perform query optimization, index management, and performance tuning across SQL Server environments.

• ETL & Data Pipeline Development:

• Build and maintain scalable ETL/ELT pipelines integrating disparate source systems into central warehouses.

• Migrate, transform, and orchestrate automated data workflows using Azure Data Factory / Synapse pipelines and SSIS.

• Analytics & Reporting (Power BI):

• Develop complex tabular data models and implement advanced DAX measures for business KPIs.

• Build interactive, highly visual Power BI dashboards aligned with governance standards.

• Manage workspace administrative access, Row-Level Security (RLS), and scheduled dataset refreshes.

• Governance & Operational Support:

• Support Master Data Management (MDM) initiatives and maintain data lineage across environments.

• Troubleshoot operational pipeline failures, data anomalies, and reporting defects.

Required Technical Stack & Qualifications

Core Tech Stack:

• Database & Querying: Microsoft SQL Server, T-SQL (Stored Procedures, CTEs, Window Functions).

• BI & Visualization: Microsoft Power BI Desktop & Service, DAX, Power Query (M).

• Integration & Cloud Data: Azure Synapse Analytics / Azure SQL, Azure Data Factory (ADF), or SSIS.

• Data Modeling: Dimensional modeling (Kimball methodology), Star/Snowflake Schemas.

Experience & Education:

• 5–7+ years of hands-on experience in SQL development and Business Intelligence solutions.

• Demonstrated experience handling enterprise-scale data transformations.

• Degree or Diploma in Information Technology, Computer Science, Data Engineering, or a related discipline.

• Relevant Microsoft Certifications (e.g., PL-300: Power BI Data Analyst or DP-203: Data Engineering on Azure) are highly advantageous.

Competencies & Behavioral Attributes

• Analytical Problem Solving: Ability to translate unstructured business requirements into technical schema designs.

• Communication: Strong communication skills to liaise with non-technical business partners.

• Attention to Detail: Deep commitment to data accuracy, consistency, and security protocols.