Federated SQL Engineer

Location

Gauteng, Johannesburg Metro, Johannesburg

Job Type

Contract – Full-Time hours

Primary Industry

Banking and Finance

Job Description

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. The engineer analyses business requirements, implements complex queries, and supports data governance policies to enhance the organisation’s data infrastructure.

Job Duties

• 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.

Required Qualifications

• 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.

Education

• 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.

Experience

• Minimum of three years’ experience developing and managing federated SQL solutions.
• Experience in designing and implementing data integration strategies in complex database environments.
• Previous contract or permanent experience within financial services is highly regarded.

Knowledge and Skills

• In-depth knowledge of SQL syntax, query structure, and advanced functions.
• Strong analytical and problem-solving abilities.
• Excellent communication skills, capable of explaining technical concepts clearly to non-technical audiences.
• Ability to work independently and manage time effectively within a contract setting.
• Familiarity with database platforms commonly used in financial services, such as Oracle, Microsoft SQL Server, or PostgreSQL.
• Understanding of federated database architectures and their operational considerations.

Preferred Qualifications

• Experience with cloud-based database services and federated solutions.
• Knowledge of scripting languages such as Python or PowerShell for automation tasks.
• Exposure to data visualisation tools and business intelligence platforms.
• Awareness of regulatory frameworks affecting data management in banking, such as Basel III or GDPR.

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.