career opportunities
We’re excited for new talent!
Our goal is to recruit and build an exceptional cadre of professionals who are passionate about doing work that matters. Successful candidates are placed into a niche practice area that best suits their skill set, interests and personal capability.
Opportunities do not follow a set timeline. Instead, opportunities at this level are advertised when they become available on an ongoing basis.
Your application must consist of:
- A comprehensive CV
- A copy of your identity document or passport
- Copies of all academic certificates obtained.
Process:
- The application is received and screened against required skills, competencies and experience
- The candidate is required to complete a technical case study
- Face-to-face and online psychometric assessments are conducted
- An interview is conducted
- Credential checks and references are completed
- If the candidate is successful, an offer of employment is made.
Job Title
Business Intelligence (BI) / SQL DeveloperEmployment Type
ContractExperience
5 to 7 yearsSalary
NegotiableJob Published
05 October 2026Job Reference No.
342065Job Description
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.
Skills
Industries
We are a remote-first team!
We don’t feel that you need to go to an office every day to have impact, but we do want our team members to have options.
Contact Us
Have a question, need a solution, or want to explore how iDbase Software can support your digital goals? We’re here to help. Reach out to our team – we’ll get back to you promptly.
- +27 (0) 10 085 9503
- info@idbasesoftware.com
- Midrand, Johannesburg, South Africa.
- Hyattsville, Maryland USA
news Room
Real-world lessons in digital transformation – going beyond theory
Copyright © 2026 iDbase Software | All Rights Reserved.
