Data Engineer (Snowflake) (1 Year Contract)

About the Job

We are looking for a skilled Data Engineer with hands-on experience in Snowflake to design, develop, and maintain scalable data pipelines and data solutions.

In this role, you will work across the data engineering lifecycle, from data ingestion and transformation to data modelling, quality assurance, and platform operations. You will collaborate with technical teams and business stakeholders to deliver reliable, secure, and well-governed datasets that support reporting, analytics, and business applications.

Key Responsibilities

• Design, develop, and maintain scalable data ingestion, transformation, and ETL/ELT pipelines using Snowflake.
• Build and optimise data models, tables, views, and curated datasets across Bronze, Silver, Gold, and Platinum data layers.
• Develop SQL and Python scripts for data processing, validation, and automation, leveraging Snowpark where applicable.
• Implement data quality checks, reconciliation processes, error handling, and monitoring to ensure data accuracy and reliability.
• Monitor data pipelines, troubleshoot failures, resolve data issues, and optimise performance.
• Support user access management, role provisioning, and implementation of security controls, including RBAC, data classification, masking policies, and secure data sharing.
• Support version control, testing, and deployment of Snowflake changes through GitLab CI/CD pipelines.
• Collaborate with business stakeholders to understand data requirements and translate them into effective technical solutions.
• Maintain technical documentation, data definitions, and operational runbooks to support ongoing platform operations.

Requirements

• Minimum 3 years of experience in Data Engineering
• Strong hands-on experience with Snowflake and advanced SQL skills.
• Proven experience designing, developing, and maintaining ETL/ELT pipelines involving structured and semi-structured data.
• Proficiency in Python for data processing, transformation, and automation.
• Good understanding of data modelling, data quality management, reconciliation, and performance optimisation.
• Familiarity with Git, CI/CD pipelines, and Agile software development practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Good written and verbal communication skills, with the ability to collaborate effectively with technical and business stakeholders.
  

Good to Have

• Experience with Azure Data Factory (ADF), Azure Blob Storage, and Power BI.
• Hands-on experience with Snowflake features such as Snowpipe, Streams, Tasks, Dynamic Tables, and secure data sharing.
• Experience using Snowpark for data engineering and transformation workloads.
• Knowledge of Snowflake security and governance features, including RBAC, role management, data masking, and access controls.
• Experience with GitLab CI/CD for automated deployment and environment management.