Developer: SQL and Reporting

SupportFinity™; Cape Town; Hybrid; ZAR 360,000 - 480,000; Full time

Job summary

BDO South Africa is seeking a skilled data professional for a hybrid role combining SQL development, reporting, and data engineering. You will design and optimize SQL queries, build and maintain data pipelines, and develop dashboards to deliver actionable business insights from diverse sources.

The role requires 3–5 years of experience, strong MS SQL Server BI stack knowledge, and experience with Power BI. A Cape Town hybrid work setup is offered along with collaboration with cross-functional

Qualifications

• 3–5 years of relevant experience
• Proven experience in developing reports and databases
• Ability to design and optimize SQL queries
• Strong data governance and security awareness

Responsibilities

• Design, develop, and optimize SQL queries and scripts
• Maintain data pipelines and data warehousing
• Create and restore databases
• Monitor database performance and apply patches
• Develop reports and dashboards (Power BI, SSRS)
• Ensure data accuracy in reports

Skills

SQL Development

Data Engineering

Report Writing

Data Warehousing

ETL

Education

Grade 12

Degree or Diploma in Computer Science or related field

Tools

SSRS

SSIS

T-SQL

Power BI

Power Query

DAX

Python

Excel Macros

Azure

Crystal Reports

Job description

Primary Purpose Of The Job

We are seeking a skilled and detail-oriented professional to fill a hybrid role that encompasses SQL development, report writing, and data engineering. The ideal candidate will be responsible for managing data pipelines, developing and optimizing SQL queries, building reports and dashboards, and supporting the business with actionable data insights.

Primary Purpose Of The Job

We are seeking a skilled and detail-oriented professional to fill a hybrid role that encompasses SQL development, report writing, and data engineering. The ideal candidate will be responsible for managing data pipelines, developing and optimizing SQL queries, building reports and dashboards, and supporting the business with actionable data insights.

Main Duties And Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, functions, and scripts.
• Ensure that all database systems are maintained and enhanced to meet the organisation's requirements for data integrity, security, and availability.
• Create and restore databases
• Monitor database performance, implement changes, apply new patches and versions when required
• Create Server agent jobs
• Build, manage and support data warehousing solution and contribute to the development of data models.
• Ability to establish ODBC connections between different types of databases and platforms
• Develop and maintain operational, financial, and ad-hoc reports using SQL-based reporting tools (e.g., SSRS, Power BI)
• Ensure data accuracy and consistency in all reports and dashboards.
• Design and implement data pipelines and ETL processes for integrating data from various sources.
• Work with large datasets, ensuring data reliability, consistency, and scalability.
• Create and maintain documentation on database design, ETL processes, and report development.
• Work closely with the developers on projects to assistance with the database structure and relationships

Qualifications

Qualifications, Work Experience, and Knowledge

• Grade 12
• Degree or Diploma in Computer Science or related field

Work Experience

• Minimum 3- 5 years' relevant experience
• Proven experience in developing reports and databases

Knowledge

• Advanced in MS SQL Server BI Stack tools and technologies (SSRS, SSIS, TSQL, Power Query, Power Bi, Dax)
• Strong knowledge of Python.
• Strong Microsoft Excel skills including Macros
• Familiarity with cloud platforms (e.g., Azure)

Competencies: Technical & Behavioural

Technical Competencies

• Excellent knowledge of data backup, recovery, security, integrity, and SQL.
• Experience in Crystal reports or similar business intelligence tools.
• Solid understanding of ETL processes, data warehousing concepts, and data modelling.

Behavioural Competencies

• Ability to work independently and as part of a team
• Proactive, self-starter with initiative to find ways to improve solutions, systems and processes
• Excellent analytical and problem-solving skills
• Ability to learn new software and technologies quickly.
• Ability to follow instructions
• Strong attention to detail
• Excellent communication and documentation abilities.

BDO Core Competencies

• Relationships and Collaboration
• Exceptional Client Service
• Business Growth
• Engaging people
• Leadership
• Quality, Risk management and Operational performance

#RDW

About the company

BDO South Africa