Johannesburg: Federated SQL Engineers posted by Africonology

About the Role

The Federated SQL Engineer is responsible for designing, developing, and maintaining federated SQL solutions that enable seamless data integration across multiple database systems within the banking and finance environment. The role involves collaborating with technical teams to ensure data accessibility, consistency, and performance optimisation in a secure and compliant manner.

Key Responsibilities

• Develop, implement, and maintain federated SQL queries and views that integrate data from diverse database systems.
• Optimise SQL code to ensure high performance, scalability, and reliability within a federated environment.
• Collaborate with database administrators, data architects, and business analysts to understand data requirements and translate them into effective SQL solutions.
• Conduct thorough testing and validation of federated queries to ensure accuracy and consistency of data outputs.
• Monitor and troubleshoot performance issues related to federated SQL queries and data retrieval.
• Ensure compliance with data security policies, regulatory requirements, and internal governance standards.
• Document SQL development processes, query designs, and system configurations in accordance with organisational standards.
• Provide technical support and guidance on federated SQL best practises to relevant stakeholders.
• Stay informed of emerging trends and technologies in SQL development and federated database management.

Requirements

• Cross-source validation, profiling, reconciliation at scale.
• Proven experience in SQL development, specifically within federated database environments.
• Strong understanding of relational database management systems and data integration techniques.
• Experience working within the banking and finance sector or a similarly regulated industry.
• Proficiency in performance tuning and query optimisation for complex SQL queries.
• Familiarity with data governance, security standards, and compliance requirements applicable to financial institutions.

Qualifications

A Bachelor’s degree in Computer Science, Information Technology, Software Engineering or a related discipline is desirable. Relevant professional certifications in SQL, database management, or data engineering are advantageous.

Salary & Benefits

Salary details not specified.

Working Conditions

• This role is based in Johannesburg, within Gauteng province, and requires full-time commitment for the duration of the contract.
• Work is primarily office-based with the possibility of some remote work depending on project requirements and organisational policies.
• Standard working hours apply, although flexibility may be necessary to meet project deadlines or support critical systems outside normal hours.
• The role involves working within a regulated environment, requiring adherence to strict data protection and security protocols.