Data Engineer (Snowflake)

We are modernising an enterprise data warehouse to a cloud-native analytics platform on AWS and Snowflake. We are looking for a hands-on Snowflake Data Engineer to build and support reliable ingestion and ELT pipelines, dimensional data models, and production-ready data solutions. The role will work closely with senior engineers, architects, QA, cloud/platform teams, and BI users through design, development, testing, deployment, and operational handover. Key Responsibilities: Design, develop, and maintain data pipelines and data warehouse layers in Snowflake, including RAW, ODS, and DW schemas, tables, and views. Implement data ingestion and orchestration using Snowflake features such as Stages, Storage Integrations, Snowpipe, Tasks, Streams, and Stored Procedures, or equivalent approved patterns. Develop and maintain dimensional data models, including fact and dimension tables, transformations, aggregates, and lookup structures. Write and optimise SQL for data transformation, reconciliation, troubleshooting, and performance improvement. Implement data quality checks, validation, reconciliation, logging, and error-handling controls. Support rerun, recovery, and replay activities for failed or incomplete data processing. Work with AWS services such as S3 and IAM as part of secure cloud data integration. Support SIT, UAT, deployment, documentation, and operational handover activities. Collaborate with senior engineers and architects, follow agreed engineering standards, and contribute to code reviews and continuous improvement. EA Licence No.:18S9405 / EA Reg. No.:R1330864 Percept Solutions is expanding and actively seeking talented individuals. We encourage applicants to follow Percept Solutions on LinkedIn at https://www.linkedin.com/company/percept-solutions/ to stay informed about new opportunities and events.