iqbusiness is seeking to employ a Data Engineer 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).

The Data Engineer is responsible for designing, building, and maintaining robust data pipelines that enable seamless integration across APIs, files, and cloud platforms. They will serve as the backbone of the integration ecosystem, ensuring data flows into a single, trusted source of truth. This role requires strong solution design capabilities, proactive troubleshooting, and a commitment to maintaining data quality. The Data Engineer will also be responsible for documenting solutions, orchestrating workflows, and delivering scalable, resilient data solutions that support business needs.

Key responsibilities:

• Design & Architecture: Shape robust, scalable integration patterns that consider data volume, latency, cost, and reliability. 
• Data Extraction, Mapping & Transformation: Build and maintain ELT/ETL mappings from multiple sources into target models; create/alter Snowflake tables and views. 
• API Integration: Securely integrate with multiple internal and external APIs (e.g., Salesforce APIs) to enable seamless data flow
• Batch File Ingestion: Automate secure SFTP ingest (file discovery, PGP encryption/decryption if needed, schema validation).
• Data Quality Management: Put in place validation, error handling, and reconciliation checks; instrument data health metrics. 
• Orchestrate & Operate: Schedule jobs, set SLAs, monitor, and alert; participate in on-call/rapid troubleshooting when required.
• Release Testing & Documentation: Coordinate release testing for integration changes; produce design specs, mappings, and workflow diagrams/runbooks. 

Skills required:

• 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