We are seeking a Data Engineer with strong experience in Snowflake and Matillion to join our data team. The ideal candidate will be responsible for designing, building, and optimising scalable data pipelines and architectures to support business intelligence, analytics, and data science initiatives.
Candidate must have ETL, Snowflake and Matillion experience
Responsibilities:
- Design, develop, and maintain robust ETL/ELT pipelines using Matillion to ingest and transform data into Snowflake.
- Optimize Snowflake queries and data models for performance and scalability.
- Collaborate with cross-functional teams to gather requirements and deliver data solutions.
- Ensure data quality, integrity and governance across all data pipelines.
- Monitor and troubleshoot data workflows and resolve performance issues.
- Document data processes, architecture and technical decisions.
Experience:
- 5+ years of experience in data engineering or a similar role.
- Strong hands-on experience with Snowflake (data modelling, performance tuning, SnowSQL).
- Proficiency in Matillion for ETL/ELT orchestration.
- Solid SQL skills and experience with scripting languages like Python.
- Experience with cloud platforms (AWS preferred; Azure or GCP also valuable).
- Familiarity with version control (e.g., Git) and CI/CD practices.
- Strong understanding of data warehousing concepts and best practices.
Qualifications:
- Matric and a tertiary degree
- Experience with data visualization tools (e.g., Power BI, Tableau).
- Exposure to data governance, data quality frameworks or MDM.
- Knowledge of DevOps for data pipelines and infrastructure-as-code.
- Certifications in Snowflake, AWS or Matillion are a plus
Desired Skills:
- data visualization tools
- data governance
- DevOps
- ETL
- Snowflake and Matillion experience