Job Description We are looking for a hands-on Snowflake Data Engineer to support the modernization of an enterprise data warehouse to a cloud-native analytics platform on AWS and Snowflake. You will be responsible for building scalable data pipelines, developing dimensional data models, and delivering reliable ELT solutions while working closely with architects, senior engineers, QA teams, cloud engineers, and business stakeholders. Key Responsibilities Design, develop, and maintain data pipelines and warehouse layers (RAW, ODS, DW) in Snowflake. Build and support ELT/ETL pipelines using Snowflake features such as Snowpipe, Tasks, Streams, Stages, Storage Integrations, and Stored Procedures. Develop dimensional data models including fact tables, dimension tables, aggregates, and lookup tables. Write, optimize, and troubleshoot complex SQL queries for transformation, reconciliation, and performance tuning. Implement data quality checks, validation, reconciliation, logging, and error-handling mechanisms. Support rerun, recovery, and replay processes for failed data loads. Integrate data securely using AWS services such as S3 and IAM. Participate in SIT, UAT, deployment, documentation, and production support. Collaborate with architects and engineering teams while following coding standards and best practices. Contribute to code reviews and continuous improvement initiatives. Required Skills
Data Engineer in Cornwall employer: ELLIOTT MOSS CONSULTING PTE. LTD.
As a Test Analyst at our company, you will be part of a dynamic team dedicated to delivering high-quality software solutions in a collaborative and supportive environment. We prioritise employee growth through continuous learning opportunities and foster a culture of innovation and excellence, all while being located in a vibrant area that offers a great work-life balance. Join us to make a meaningful impact in the public sector and enjoy the unique advantages of working with cutting-edge technologies and a diverse team.
Contact Details:
ELLIOTT MOSS CONSULTING PTE. LTD. Recruitment Team
