Sql Developer

Mindworx Consulting And Academy; Gauteng; On-site; ZAR 600 000 - 750 000; Full time

Job summary

A technology consulting firm in South Africa seeks a data solutions developer to design, develop, and optimize data infrastructures. The ideal candidate will possess a Bachelor's degree in Information Technology and at least 5 years of experience in SQL development, ETL processes, and data warehousing. The role includes collaborating with business stakeholders, developing SQL code, and using Power BI for reporting. Candidates with Microsoft certifications and Azure experience are preferred.

Qualifications

• Bachelor's degree in IT, Computer Science, or related field.
• 5-7 years' experience in SQL and database development.
• Expertise in ETL processes and data warehousing.

Responsibilities

• Design and optimize data solutions for customer experiences.
• Collaborate with teams to analyze and define requirements.
• Develop, optimize, and maintain SQL code and ETL solutions.

Skills

T-SQL

ETL design and development

SQL development

Data warehouse design

Power BI

Agile/Scrum experience

API integration

Git

Education

Bachelor's degree in Information Technology or related field

Relevant diploma in IT or Data Analytics

Microsoft SQL Server certification

Tools

SSIS

Power BI

SQL Server

Job description

About the Role

The purpose of the role is to design, develop, and optimize robust data solutions that enable exceptional customer experiences and operational efficiency.

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.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Information Systems, or a related field.
• Relevant diploma in IT, Data Analytics, or a related field 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 advantageous.

Required Skills

• 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 considered highly advantageous.
• Exposure to cloud‑based data solutions (Azure Synapse, Azure Data Factory, or similar) beneficial.
• Knowledge or hands‑on experience with Snowflake or IBM Cloud Pak for Data considered a strong advantage.
• Experience working in Agile/Scrum environments.
• Financial services or investment platform experience advantageous.