Snowflake Engineer

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.