Senior BI & SQL Developer | Power BI, Azure Data Factory

iDbase Software; Sandton; Hybrid; ZAR 650,000 - 900,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL Development

Power BI

ETL/ELT

Azure Data Factory

Data Modeling

Education

Bachelor's Degree in IT/CS

Microsoft Certifications (PL-300 / DP-203)

Tools

SSIS

Azure Data Factory

Azure Synapse

Power BI Service

Job description

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.