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.

To apply,simply click the "Apply" button or send your updated profile to [email protected] 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.