Recruitment Room Team
SQL Data Engineer (12 Month Contract) (Centurion Hybrid)
Job Description
ENVIRONMENT:
PLAY a pivotal role in building and optimising robust data solutions that support the investment operations and analytics of a dynamic Financial Services provider seeking a technically skilled and business-savvy SQL Data Engineer who thrives in a fast-paced, collaborative environment. The successful candidate will be filling a 12-month contract role where you will develop and maintain ETL/ELT data pipelines using SSIS and AWS Glue for large-scale data ingestion and transformation, elicit and document business requirements directly from data clients while delivering consistent, high-quality service while managing expectations. Applicants must have a BSc. IT or similar tertiary qualification with at least 5 years hands-on SQL development experience. (Experience in warehouse, data lake, or data vault development using SSIS and SQL Transact will be considered here – not just fluency in SQL for 10 years). You will also need proficiency with Python, SSIS, SSRS, GitLab, AWS, Visual Studio, MDS & Power BI.
DUTIES:
- 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.
REQUIREMENTS:
Qualifications –
- Relevant tertiary qualification (e.g., BSc IT or similar).
Experience –
- Minimum 5 years of hands-on SQL development experience. (Experience in warehouse, data lake, or data vault development using SSIS and SQL Transact will be considered here – not just fluency in SQL for 10 years).
- 5 Years+ of Python for data processing, automation, and ETL/ELT pipeline development.
- Strong problem-solving skills with a focus on Backend SQL development.
- Ability to work independently and in teams to deliver robust data solutions.
- Able to translate a documented specification into a robust implemented solution.
Technical –
- 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.
Financial Industry Expertise –
- 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.
Methodologies –
- 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.
ATTRIBUTES:
- Strong ability to gather and document requirements directly from stakeholders.
- Exceptional collaboration and relationship-building skills.
- Agility in problem-solving and adapting to changing priorities.
