Junior - Intermediate Data Engineer

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

Job summary

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

Responsibilities include designing and optimizing SSRS reports, writing advanced T-SQL queries, building report datasets, and assisting with transitioning to modern BI platforms such as Power BI, while collaborating with IT and business users.

Qualifications

• Diploma or Degree in IT, CS, IS, or Data Science.
• 2–4 years' experience in Data Engineering, SQL Development, or BI.
• Strong hands-on experience with Microsoft SQL Server and SSRS.

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 views.
• Develop report datasets, parameters, subscriptions, and deployment configurations.
• Troubleshoot report performance and data issues while ensuring data integrity.
• Collaborate with technical teams to deliver high-quality reporting and transition to Power BI.

Skills

SQL Server

SSRS

T-SQL

Power BI

Data Transformation

Excel

Python

Pandas

Grafana

Splunk

Education

Diploma or Degree in IT / CS / IS / Data Science

Tools

SQL Server Management Studio

SSRS deployment

Power BI Desktop

Job description

Job Description

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.

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.

Minimum Requirements

• 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.
• Practical experience developing reports using SSRS.
• 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
• Pandas
• Power BI
• Grafana
• Splunk

Key Competencies

• Strong analytical and problem-solving skills
• Excellent attention to detail
• Effective communication skills
• Ability to work independently and collaboratively
• Strong time management and organisational skills