Data Engineer (Analytics Engineering)

Most of what we build is back-office software for property managers, including lease tracking, work orders and tenant payments. Wickfield Labs builds scheduling and dispatch software for field service companies, from two-truck plumbing outfits to regional HVAC contractors.

Role overview:

Looking for a Data Engineer (Analytics Engineering) who wants to stay somewhere for a while. The Finance Data team moves data from about 30 source systems into Snowflake. You'll own ingestion, modelling and data quality checks. Remote position. Most of the team is in London, but nobody is required to come in. Normal working hours, Monday to Friday.

Job duties:

• Build batch and streaming pipelines with Airflow, Dagster or Prefect
• Respond to pipeline failures and backfill data when needed
• Write data quality tests with dbt or Great Expectations and alert on failures
• Maintain CI for data code and review pull requests
• Model data in dbt using staging, intermediate and mart layers
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python

You'll need:

• Hands-on with an orchestration tool such as Airflow
• Patience with messy source data and the habit of documenting assumptions
• Familiarity with Git, CI/CD and testing practices for data code
• Understanding of dimensional modelling and slowly changing dimensions

Preferred qualifications:

• Kafka, Flink or Spark Structured Streaming
• Dbt Certified Developer or Databricks certification
• Terraform for data infrastructure

Pay and benefits:

£69,000 - £88,000 per annum

• Company pension
• 25 days holiday plus bank holidays
• Share options
• Cycle to work scheme
• Professional qualifications paid for
• 28 days annual leave including bank holidays

Please send your CV. A cover letter is welcome but not required.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Wickfield Labs Ltd.