Senior SQL Developer

Mindworx Consulting and Academy; Johannesburg; On-site; ZAR 650 000 - 850 000; Full time

Job summary

A leading consulting firm in Johannesburg is seeking a Database Developer with extensive experience in SQL and ETL solutions. The ideal candidate will have a strong understanding of data warehousing and experience using Power BI and SSIS. A Bachelor's degree in IT or a related field is required. This role offers the opportunity to work within an Agile team, contribute to data solutions, and interact with key business stakeholders.

Qualifications

• 5–7 years of experience in database development with extensive use of T-SQL.
• Experience in ETL design and development using SSIS.
• Hands-on with data warehouse design and dimensional modelling.

Responsibilities

• Collaborate with stakeholders to analyze requirements and design data solutions.
• Translate business needs into technical specifications including data models.
• Develop, optimize, and maintain complex SQL code.

Skills

T-SQL

ETL design using SSIS

Data warehouse design

Power BI

Git

API integration

Agile methodology

Education

Bachelor’s degree in Information Technology or related field

IT or Data Analytics diploma

Microsoft certifications in SQL Server or Power BI

Azure Data Engineer Associate certification

Tools

SQL Server

SSIS

Power BI

Azure Synapse

IBM Cloud Pak for Data

Job description

Key Responsibilities :

• Collaborate with business stakeholders, product owners, operations, and IT teams to analyze requirements and design optimal data solutions
• Translate business needs into technical specifications, including data models, ETL logic, and reporting structures
• Develop, optimize, and maintain complex SQL code, stored procedures, and functions
• Design and implement ETL solutions using SSIS or equivalent tools, ensuring accuracy, performance, and maintainability
• Build and maintain enterprise data warehouse solutions, including dimensional modelling and performance optimization
• Develop and maintain interactive dashboards and reports using Power BI, SSRS, and other BI tools
• Implement version control and collaborative development practices using Git (branching strategies, pull requests, code reviews)
• Integrate data from multiple sources, ensuring data quality, integrity, and security
• Work with internal APIs to retrieve, transform, and load data into SQL Server environments, and integrate API‑driven processes into SSIS packages where required
• Monitor and troubleshoot production data processes, providing timely resolution of issues
• Contribute to architectural design decisions and participate in peer code reviews
• Implement best practices for database performance tuning, security, and optimization
• Support Agile delivery processes, participating in sprint planning, daily stand‑ups, and retrospectives
• Document technical solutions, processes, and data flows for operational continuity and knowledge sharing

Experience :

• Minimum 5–7 years’ experience in database development, with extensive use of T‑SQL (SQL Server)
• Proven experience in ETL design and development using SSIS (or similar tools)
• Hands‑on experience with data warehouse design, dimensional modelling, and large‑scale database solutions
• Experience in BI development using Power BI, SSRS, and other reporting tools
• Solid understanding of source control systems (Git) and CI / CD practices for data solutions
• Strong problem‑solving skills, with a track record of troubleshooting and optimizing SQL queries and ETL processes
• Experience in consuming and integrating APIs (REST / SOAP) into SQL and SSIS processes is considered highly advantageous
• Exposure to cloud‑based data solutions (Azure Synapse, Azure Data Factory, or similar) is beneficial
• Knowledge or hands‑on experience with Snowflake or IBM Cloud Pak for Data is considered a strong advantage
• Experience working in Agile / Scrum environments
• Financial services or investment platform experience is advantageous

Minimum Qualifications Required :

• Bachelor’s degree in Information Technology, Computer Science, Information Systems, or a related field
• A relevant diploma in IT, Data Analytics, or a related field will also be considered if accompanied by hands‑on experience in SQL development, ETL processes, and data warehousing
• Microsoft certifications in SQL Server, Data Engineering, or Power BI (preferred but not mandatory)
• Azure Data Engineer Associate or similar cloud data certification is advantageous