Reporting to: Senior Systems Manager
Job Purpose: The SQL Developer will be responsible for designing, developing, maintaining, and automating robust SQL code to ensure efficient, accurate data retrieval that aligns with business requirements and supports organizational objectives.
Location: Woodstock, Cape Town
Key Performance Areas:
Under the management / direction of the Senior Systems Manager, the SQL Developer will deliver SSIS & SQL solutions which will include, but not limited to:
SQL Query Development
- Write efficient and complex SQL queries to extract, manipulate, and analyze data from multiple relational databases.
- Develop custom views, stored procedures, functions, and scripts to meet business requirements.
- Create ad hoc and routine queries and reports based on business needs.
Data Integration and ETL
- Develop and maintain ETL (Extract, Transform, Load) processes to support data integration from various sources into the SQL Server environment.
- Ensure data is consistently clean, accurate, and readily available for reporting and analysis.
Cross-Functional Collaboration
- Work closely with database administrators to ensure alignment of SQL code with database structures and performance standards.
- Partner with IT, development, and analytics teams to support data-driven projects and initiatives.
Documentation
and Code Management
- Document SQL code, query logic, and data structures to ensure transparency and repeatability.
- Maintain organized and version-controlled SQL scripts for consistency and ease of access.
Required Skills and Experience:
- Matric
- BSc In Information Technology, BCom Information Systems or similar degree.
- Minimum 3 to 4 years in the data environment as a SQL Developer.
- Expertise in Writing Complex SQL Code: Must have demonstrated the ability to develop and optimize advanced SQL code within relational database management systems (RDBMS) such as SQL Server, MySQL, and PostgreSQL.
- Process Automation: Proven experience in automating manual workflows and processes using integration tools like SQL Server Integration Services (SSIS).
- Database Design and Modeling: Strong understanding of data modeling, normalization, and best practices in database design to ensure efficient and scalable solutions.
Remuneration Structure:
- Basic Salary PLUS capped commission
- The following benefits are available to you at the full cost to the Employer (in line with the Company Policy);
- Funeral Cover (at the full cost of the employer)
- Life Cover (at the full cost of the Employer)
- Disability Cover (at the full cost of the Employer)
- Medical Cover (after successful completion of probation period)
- Subsidized School fees towards your child schooling at Nimble Peak Child EduCare (ages: 3 months – 5 years)
- Paid Birthday & Maternity Leave
- WIFI Access
Working Hours:
Monday – Friday: 08:00am until 17:00pm
This appointment will be made in line with the Nimble Group Employment Equity plan.
•
Last updated on Jan 29, 2025