Overview
We are looking for an experienced Data Engineer with deep expertise in SQL, Snowflake, and DBT to support our ongoing data platform modernization initiative.
You will help design, implement, and maintain scalable, modular data models and transformations using modern tooling. This role is ideal for someone who understands how to work with complex data structures, including JSON, and build efficient, reusable DBT models that support analytical and operational use cases across the organization.
Responsibilities
* Develop robust and reusable DBT models to transform and organize raw data into clean, well-structured datasets
* Write complex, efficient SQL queries including CTEs, stored procedures, views, and partitioning strategies
* Build relational models from semi-structured data (e.g., JSON) using SQL and DBT
* Work within the Snowflake platform to design performant, scalable data solutions
* Optimize use of Snowflake Virtual Warehouses, manage data sharing, and understand cost/performance trade-offs
* Collaborate with analysts, data scientists, and engineering teams to ensure consistent and reliable data delivery
* Participate in code reviews and contribute to best practices around data modeling, transformation logic, and documentation
Requirements
* Excellent SQL skills — demonstrated expertise with CTEs, procedures, partitioning strategies, and creating views
* Strong working knowledge of Snowflake, including virtual warehouses, data sharing, and querying JSON and semi-structured data
* Minimum 2 years’ experience with DBT, including building and managing reusable transformation models
* Proven ability to model and transform complex data sources (especially JSON) into structured relational models
* Familiarity with version control (e.g., Git), testing frameworks, and deployment practices within DBT
* Strong understanding of performance optimization and cost-awareness in a cloud data warehouse context
* Experience working in a collaborative, agile environment
* Financial services or regulated industry experience is a plus
We offer
* Pension
* Employee Assistance Programme
* Enhanced Maternity policy
* Give as You Earn
* Cycle to Work Scheme
* Employee Referral Bonus Scheme
* Diversity Networks
* Access to a range of skills and certifications
Seniority level
* Mid-Senior level
Employment type
* Full-time
Job function
* Business Development, Information Technology, and Engineering
* Industries: Software Development and IT Services and IT Consulting
We’re committed to equal opportunity and an inclusive workplace. This description reflects the core responsibilities, qualifications, and benefits of the role.
#J-18808-Ljbffr