Data Platform Engineer: Snowflake, dbt & ELT Pipelines

Allscreens Nationwide Ltd; Hemel Hempstead; On-site; GBP 65,000 - 100,000; Full time

Benefits offered by this job

Annual Bonus

25 days annual leave

Employee discounts

Life Assurance

Free Car Parking

Electric Vehicle scheme

Refer a friend scheme

Job summary

Warner Hotels is building a modern data platform on Snowflake and dbt, and seeks a Software Engineer (Data) to contribute to ingestion, transformation, and data quality. You will work in a squad with the Data Tech Lead and offshore partners, delivering the data engineering roadmap.

You will help ingest data from iStay, Maestro, Zonal, ElementSuite, and Coupa, develop dbt models, and enable reliable BI reporting.

Qualifications

• 2+ years in software engineering with front-end and back-end experience.
• Hands-on production experience with React/Next.js.
• Hands-on production experience with .NET Core/.NET 5+ and C#, .NET 8 preferred.
• Demonstrable experience building and deploying microservices on AWS.
• Experience with RESTful API design in a microservices architecture.
• Experience working in agile sprint teams, including offshore partners.
• Consumer-facing product experience preferred.

Responsibilities

• Design, build, and maintain data ingestion pipelines from sources into Snowflake using HVR for change data capture and dbt for transformation.
• Build and maintain dbt transformation models across Snowflake data warehouse with staging, intermediate, and mart layers.
• Develop and maintain ELT/ETL pipelines using Python and AWS services.
• Implement data quality tests, monitor pipeline health, and maintain data lineage/docs.

Skills

React/Next.js

.NET Core / C#

AWS (Lambda, S3, Glue)

RESTful API design

Microservices

Agile / sprint teams

Full-stack development

Tools

dbt

Snowflake

HVR

Python

AWS

Job description

Warner Hotels is building a modern data platform on Snowflake and dbt, and seeks a Software Engineer (Data) to contribute to ingestion, transformation, and data quality. You will work in a squad with the Data Tech Lead and offshore partners, delivering the data engineering roadmap.

You will help ingest data from iStay, Maestro, Zonal, ElementSuite, and Coupa, develop dbt models, and enable reliable BI reporting.