Main purpose of job The main objective of the Cloud Data Engineer (Snowflake) role is to design, develop, and maintain secure and scalable data pipelines, supporting the seamless migration from SQL Server to Snowflake on AWS, ensuring efficient data flow across the organisation and contributing to the execution of the global data strategy. Key accountabilities 1. Design, develop, and maintain data pipelines to ensure seamless and efficient data migration from on premise SQL Server to Snowflake on AWS, enabling secure, scalable, and reliable data storage that supports advanced analytics and reporting needs. 2. Implement and manage data integration processes to unify data from multiple sources within Snowflake, ensuring high data quality, consistency, and accessibility, which drives accurate, timely insights for business users across the organisation. 3. Optimise Snowflake performance by enhancing query speeds, data load times, and storage efficiency, ensuring that the data platform remains fast, responsive, and capable of handling high data volumes, which supports the organisation’s operational and analytical requirements. 4. Enforce data security and compliance measures by applying best practices in data encryption, access controls, and adherence to relevant regulatory standards, ensuring sensitive information remains protected and compliant throughout the migration and within Snowflake. 5. Collaborate with data scientists, analysts, and key stakeholders to gather and understand data requirements, aligning Snowflake infrastructure and solutions with business needs and fostering cross-team communication to deliver reliable and actionable data. 6. Evaluate and recommend complementary tools and technologies that enhance Snowflake’s capabilities, keeping the data platform adaptable and current with evolving cloud technologies to ensure the organisation maximises the value of its cloud infrastructure. 7. Lead migration efforts from on-premise to cloud-based infrastructure, coordinating with the Global Data Engineering Lead to establish timelines and address migration challenges, ensuring a smooth transition with minimal business disruption. 8. Document and maintain data infrastructure processes and standards within the Snowflake platform to ensure knowledge sharing, consistency, and ease of maintenance, supporting long-term operational stability and team efficiency