Junior - Intermediate Data Engineer

Blue Pearl PTY; Johannesburg; On-site; ZAR 350,000 - 550,000; Full time

Job summary

Blue Pearl PTY in Johannesburg, South Africa, seeks a Junior/Intermediate Data Engineer with BI experience to develop, maintain, and support SQL Server reporting solutions, ensuring accurate data delivery across the business.

The role emphasizes Microsoft Data Stack, MS SQL Server, T-SQL, and SSRS, with responsibilities from design through deployment, reporting, and transitioning to modern BI platforms such as Power BI.

Qualifications

• Diploma or Degree in IT, CS, IS, Data Science or related field.
• 2–4 years' experience in Data Engineering, SQL Development, or BI.
• Solid experience with Microsoft SQL Server (MS SQL).
• Experience writing advanced T-SQL queries for reporting and data transformation.

Responsibilities

• Develop, maintain, and optimize SQL Server databases, queries, and reporting solutions.
• Design, build, and maintain SSRS reports from requirements to deployment.
• Create and optimize advanced T-SQL queries, stored procedures, and database views.
• Develop report datasets, parameters, subscriptions, and deployment configurations.
• Troubleshoot and resolve report performance and data-related issues.
• Ensure accuracy, integrity and consistency of reporting data.
• Support business users with reporting requests and enhancements.
• Extract, transform, and prepare data for reporting and analysis.
• Collaborate with technical teams to deliver high-quality reporting solutions.
• Assist with transition toward modern BI platforms, including Power BI.

Skills

Microsoft SQL Server

T-SQL Development

SSRS

SQL Query Optimisation

Stored Procedures

Database Views

Data Transformation

Report Development

Relational Databases

Microsoft Excel

Education

Diploma/Degree in Information Technology, Computer Science, Information Systems, Data Science, or related field

Job description

Johannesburg, South Africa | Posted on 07/03/2026

Our client, a leading technology services company based in Bryanston, is looking for a strong Junior / Intermediate Data Engineer with Business Intelligence experience to join their team on a rolling contract. The successful candidate will be responsible for developing, maintaining, and supporting SQL Server reporting solutions while ensuring accurate, reliable, and efficient data delivery across the business.

The ideal candidate will have solid experience working with the Microsoft Data Stack, particularly MS SQL Server, T‑SQL, and SSRS, with the ability to manage report development from design through deployment and ongoing support.

Key Responsibilities

• Develop, maintain, and optimize SQL Server databases, queries, and reporting solutions.
• Design, build, and maintain SSRS reports from requirements through deployment.
• Create and optimize advanced T‑SQL queries, stored procedures, and database views.
• Develop report datasets, parameters, subscriptions, and deployment configurations.
• Troubleshoot and resolve report performance and data‑related issues.
• Ensure the accuracy, integrity, and consistency of reporting data.
• Support business users with reporting requests and enhancements.
• Extract, transform, and prepare data for reporting and analysis.
• Collaborate with technical teams to deliver high‑quality reporting solutions.
• Assist with the transition toward modern BI platforms, including Power BI.
• Diploma or Degree in Information Technology, Computer Science, Information Systems, Data Science, or a related field.
• 2–4 years' experience in Data Engineering, SQL Development, or Business Intelligence.
• Strong hands‑on experience with Microsoft SQL Server.
• Experience writing advanced T‑SQL queries for reporting and data transformation.

Technical Skills

• Microsoft SQL Server
• T‑SQL Development
• SQL Server Reporting Services (SSRS)
• SQL Query Optimisation
• Stored Procedures
• Database Views
• Data Transformation
• Report Development & Deployment
• Relational Databases
• Microsoft Excel

Advantageous Skills

• Python
• Power BI
• Grafana
• Splunk
• Strong analytical and problem-solving skills
• Excellent attention to detail
• Ability to work independently and collaboratively
• Strong time management and organisational skills