Snowflake Engineer - 3 days per week onsite
12‑month fixed term contract
Role Overview
A Snowflake Data Engineer role focused on maintaining and enhancing an enterprise data platform. The position centres on building secure, performant data pipelines and analytical models in Snowflake, primarily supporting a Power BI reporting layer.
Key Responsibilities
* Design and implement dimensional data models in Snowflake to support enterprise analytics.
* Build and maintain production-grade data transformation workflows, including version control, testing, and documentation.
* Develop and orchestrate data ingestion pipelines using Azure Data Factory (ADF).
* Optimise Snowflake warehouses for performance and cost efficiency.
* Automate and monitor data loads to ensure timely, reliable data availability.
* Implement and manage RBAC and data masking policies to protect sensitive data.
* Help define and maintain engineering standards, naming conventions, and CI/CD practices.
* Act as a trusted technical advisor to non‑technical business stakeholders.
Required Experience & Skills
* Strong hands-on experience with Snowflake (architecture, administration, optimisation).
* Proven experience with Azure Data Factory (ADF).
* Solid understanding of data warehousing and dimensional modelling concepts.
* Experience working in enterprise, production data environments.
* Ability to communicate technical concepts clearly to non‑technical stakeholders.