SQL Data Engineer (12 Month Contract)

Job Description

Join a dynamic Financial Services provider as a SQL Data Engineer for a 12-month contract, where you’ll build and optimize robust data pipelines to support investment operations and analytics. Develop ETL/ELT solutions using SSIS and AWS Glue, implement data governance, and collaborate with stakeholders to deliver high-quality, compliant data solutions. This hybrid role in Centurion offers the chance to drive innovation in a fast-paced, collaborative environment.

Requirements

• Relevant tertiary qualification (e.g., BSc IT or similar)
• Minimum 5 years of hands-on SQL development experience in warehouse, data lake, or data vault development using SSIS and SQL Transact
• 5 Years+ of Python for data processing, automation, and ETL/ELT pipeline development
• Advanced proficiency in SQL Transact, SQL Server, SSIS, and SSRS, including performance tuning and query optimization
• Experience in data warehouse, data lake, or data vault development using SSIS and SQL Transact
• Strong knowledge of AWS services related to data management
• Proficiency in GitLab for version control, CI/CD automation, and deployment pipelines
• Experience with Python libraries such as Pandas, NumPy, PySpark, and SQLAlchemy for data manipulation and integration
• Knowledge of Visual Studio, MDS, and Power BI
• Experience in ETL/ELT pipeline development, data integration strategies, and best practices in data engineering
• Database Administration (DBA) experience, including index management, query optimization, and performance tuning
• At least 5 years’ experience working with SQL, preferably in the Investments / Asset Management industry
• Strong understanding of regulatory compliance, data governance, and financial data structures
• Working experience in an Agile environment (Scrum, Kanban) with sprint planning and backlog grooming
• Proficiency in implementing DevOps practices for automated deployments, monitoring, and alerting

Responsibilities

• Expert-level SQL Backend Development (not Application Development)
• Elicit and document business requirements directly from data clients
• Deliver innovative solutions aligned with business needs and strategies
• Develop and maintain ETL/ELT data pipelines using SSIS and AWS Glue for large-scale data ingestion and transformation
• Implement database solutions with partitioning, indexing, and stored procedures to improve query execution times
• Automate deployment pipelines using GitLab CI/CD to streamline development and operational workflows
• Implement data governance frameworks, access controls, and compliance protocols to meet financial industry regulations
• Build and maintain effective relationships with stakeholders
• Deliver consistent, high-quality service while managing expectations
• Promote a feedback-driven and service-oriented culture
• Contribute to a positive and energizing workplace culture
• Align individual performance with team and organizational goals
• Encourage and embrace innovation, agility, and collaboration
• Take ownership of personal development through effective performance planning and feedback