Company:
Nimble Group
Industry: Banking / Financial Services
Deadline: Not specified
Job Type: Full Time
Experience: 5 – 6 years
Location: Western Cape
Province: Cape Town
Field: ICT / Computer
Key Performance Areas:
- Under the management / direction of the Systems Lead, 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.
What You Need:
Required Skills and Experience:
- Matric
- BSc In Information technology, BComm Information Systems or similar qualification.
- Minimum of 5 to 6 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.
Working Hours:
- 45 hours per week, scheduled between 07:00 am and 20:30pm, Monday to Friday.
