> Markdown version of [/jobs/ext/2309951-data-engineer](https://www.wearedevelopers.com/jobs/ext/2309951-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - **Company:** ELLIOTT MOSS CONSULTING PTE. LTD. - **Location:** Penarth, UK - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Artificial Intelligence, Amazon Web Services, Amazon S3, Code Review, Continuous Integration, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Database Development, Database Queries, Dimensional Modeling, Identity and Access Management, JSON, Lookup Table, Oracle Warehouse Builder, Performance Tuning, Query Optimization, SQL Stored Procedures, Systems Integration, Tableau (Software), Extensible Markup Language (XML), Data Logging, Freeform SQL, Snowflake, Git, Semi-structured Data, Deployment Automation, Star Schema, Data Management, Cloud Integration, Data Pipelines, Legacy Systems - **Published:** August 30, 2026 - **Apply:** https://www.collegerecruiter.com/job/2815444320-data-engineer ## About the Role * 3+ years of experience in Data Engineering, Data Warehousing, or Database Development. * Hands-on experience with Snowflake or another cloud data warehouse platform. * Strong SQL skills including joins, window functions, CTEs, query optimization, and troubleshooting. * Good understanding of dimensional modelling (Star Schema, Fact & Dimension tables). * Experience developing and maintaining ETL/ELT pipelines. * Knowledge of data quality, reconciliation, logging, monitoring, and production support. * Good analytical, communication, and problem-solving skills. * Ability to work independently and collaboratively in an Agile delivery environment. Preferred Skills * Experience with Snowflake features: Snowpipe Tasks Streams Stages Storage Integrations Stored Procedures Experience migrating Oracle Data Warehouse or legacy platforms to Snowflake. * Experience handling semi-structured data (JSON, XML, VARIANT). * AWS knowledge, especially: Amazon S3 IAM Encryption Cloud integration Experience with Git, CI/CD, and deployment automation. * Exposure to Tableau or other BI reporting tools. Snowflake, AWS, Data Engineering, AI/ML, or GenAI certifications ## 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., * 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. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)