Data Integration Lead | Contract at IQbusiness

Job Description

• iqbusiness is seeking to employ a Data Integration Lead on a 12-month contract to collaborate with an international client from our offices in Welgemoed, Cape Town, Northern Suburbs. This is a hybrid role (3 days on-site; 2 days WFH).
• As a data integration leader, you will shape and guide the design of seamless information flows across our organisation. You’ll architect and oversee integration solutions that not only meet business requirements but consistently exceed expectations, using your deep expertise in SQL and cloud-based tools such as Informatica.
• Working closely with cross-functional teams, you’ll translate complex business needs into elegant technical solutions through clear, effective communication.
• Along the way, you’ll optimise performance, proactively troubleshoot issues, and maintain high-quality documentation others can depend on. If you’re ready to lead a team and become the driving force behind data integration excellence, this is your opportunity to make a lasting impact.

Key Responsibilities:

• Data Integration: Develop and implement comprehensive data integration solutions.
• Design and Architecture: Design robust and scalable data integration solutions, considering factor such as data volume and performance.
• Data Extract, Mapping, and Transformation: Create data mappings to extract, transform, and load data, ensuring accurate and consistent integration across systems.
• Data Quality Management: Implement measures to ensure data quality and integrity throughout the integration process, including error handling and validation.
• Organise Release Testing: Coordinate and manage release testing activities for data integration solutions.
• Collaboration: Work closely with cross-functional teams, including data analysts, developers, and business stakeholders, to understand requirements and deliver integrated solutions.
• Performance Optimisation: Monitor and optimise data integration processes for performance, efficiency, and reliability.
• Documentation: Create and maintain comprehensive documentation for data integration processes, including design specifications, data mappings, and workflow diagrams.
• Troubleshooting and Support: Provide support for data integration-related issues, troubleshoot problems, and implement solutions in a timely manner.
• Lead and develop junior engineers

Skills Required:

• Bachelor's Degree in Computer Science or equivalent
• 5–7 years of experience in data integration, data engineering, or a similar technical role.
• Proven experience designing and implementing ETL/ELT pipelines, including data mapping, transformation, and workflow orchestration.

Demonstrated experience with:

• ETL tools (e.g., Informatica, Talend, Azure Data Factory, SSIS, DBT, etc.)
• SQL and relational databases
• Handling large‑scale, high‑volume data integrations
• Strong background in data quality, validation, and error‑handling processes.
• Experience in troubleshooting complex data integration and performance‑related issues.
• Experience leading or mentoring junior engineers.

Experience in the following tools is essential:

• SQL
• Working with APIs, including data extraction and integration

Experience in the following tools is advantageous:

• Python
• Snowflake
• Salesforce
• Informatica