Data Engineer (Cape Town) at iOCO

What you’ll do:

• Design, develop, and maintain data pipelines and ETL processes to support various business needs.
• Build and optimize data cubes to enable advanced data analysis and reporting.
• Collaborate with data developers and analysts to ensure data quality and integrity.
• Work with cloud platforms to deploy and manage data solutions, ensuring scalability and performance.
• Utilize MS Fabric to integrate and manage data flows across various environments.
• Monitor, troubleshoot, and optimize data systems to ensure efficient operation.

Skills and Experience

Your expertise:

• Must have a relevant 3-year IT experience or related qualification.
• 3+ years of experience in data pipeline design and development.
• Proficiency in SQL.
• Proficiency in Analysis Services (SSAS) as well as Integration Services (SSIS).
• Experience with RDBMS technologies such as SQL Server, MySQL, and PostgreSQL.
• Ability to use common scripting languages such as PowerShell, Bash, or Python for automation.
• Experience using unit and integration tests.
• Experience working with production BI environments and tools such as Tableau and Pyramid Analytics.
• Strong analytical and problem-solving skills.
• Proven experience in data development and data engineering roles.
• Expertise in cube building and data modeling.
• Hands-on experience with MS Fabric or similar tools.
• Solid understanding of data warehousing, ETL processes, and data integration.
• Strong problem-solving skills and attention to detail.
• Excellent communication and teamwork abilities.

Other

Preferred Qualifications:

• Experience with big data technologies (e.g., Hadoop, Spark) is a plus.
• Familiarity with data visualization tools (e.g., Power BI, Tableau) is advantageous