Remote Senior Data Engineer — In‑House Data Warehouse

Smart Working; Halesowen; Remote; GBP 65,000 - 100,000; Full time

Job summary

Smart Working in the United Kingdom is hiring a Data Engineer to bring the data function in-house, taking ownership of an existing data warehouse after a structured handover. The role is permanent and full-time, with UK hours in a remote-first setup.

You will collaborate with the Data Analyst and data owners across operations and finance to transform business questions into reliable data solutions, and you will communicate findings to the CEO and directors, contributing to architecture, testing

Qualifications

• 5+ years of data engineering experience for the global Senior route.
• Advanced SQL skills, including joins, CTEs, window functions, aggregations and debugging complex queries.
• 3+ years of production BigQuery experience with hands-on use.

Responsibilities

• Take over the existing data warehouse from the current third-party data provider during the handover period and then run it in-house.
• Maintain and improve the pipelines moving ERP data into the data warehouse so that data lands reliably and on time.
• Write, maintain and extend data models across staging, business logic, marts and reporting tables that feed the reporting layer.
• Read and understand the existing codebase before building new models.
• Implement and monitor data quality tests, deploying only once tests pass.
• Use version control consistently with disciplined commits, clear messages and branching.
• Answer business questions using data and explain findings clearly to non-technical colleagues, including the CEO and directors.
• Co-own technical documentation, core business definitions and the report library.
• Cross-cover with the Data Analyst on reporting during holidays and absence.
• Pick up occasional wider IT tasks, with training provided.
• Work collaboratively with the Data Analyst and speak directly with data owners across the business.
• Manage your own workload and own outcomes.
• Maintain a detail-oriented approach to data accuracy, testing and documentation while understanding the end-to-end business processes behind the data and asking “why before how”
• Work flexibly within firm guardrails, with version-control discipline and test-before-deploy practices being non-negotiable
• Frame and answer business questions rather than simply executing tickets
• Learn quickly during the handover while maintaining a thorough approach focused on pipeline reliability, data quality and business adoption of reports

Skills

Advanced SQL

BigQuery

dbt

ELT & DW

Git/GitHub

Data modeling

Communication

Tools

GitHub

dbt

BigQuery

Job description

Smart Working in the United Kingdom is hiring a Data Engineer to bring the data function in-house, taking ownership of an existing data warehouse after a structured handover. The role is permanent and full-time, with UK hours in a remote-first setup.

You will collaborate with the Data Analyst and data owners across operations and finance to transform business questions into reliable data solutions, and you will communicate findings to the CEO and directors, contributing to architecture, testing