Junior Data Engineer: SQL, SSRS & BI Reporting

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

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.