Remote Data Engineer - BigQuery & dbt Expert

Smart Working; Larkhill; Remote; GBP 85,000 - 120,000; Full time

Job summary

Smart Working is seeking a Data Engineer to bring the data function in-house, taking over an existing warehouse, building robust ETL pipelines and scalable data models. You will collaborate with the Data Analyst and senior stakeholders to translate business questions into reliable data solutions.

This permanent, full-time role prioritises data engineering with some reporting support, operates on UK hours, and supports a remote-first working model.

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 commercial, hands-on Google BigQuery experience for the global route
• 3+ years of production dbt experience for the global route, including staging layers, business logic models, marts and tests
• 1+ year of experience with Git/GitHub
• 1+ year of experience with data warehouse concepts, including ELT, layered modelling and dimensional modelling
• Ability to communicate effectively with non-technical stakeholders, including CEO and director-level stakeholders
• Experience with data pipelines and managed connectors for ingesting ERP data into BigQuery
• Experience with data quality testing and safe deployment
• Full overlap with UK business hours, including GMT/BST change

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
• 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

Git/GitHub

ELT/Dim modelling

Data quality testing

Effective communication

Tools

Looker

Power BI

Tableau

Python

Job description

Smart Working is seeking a Data Engineer to bring the data function in-house, taking over an existing warehouse, building robust ETL pipelines and scalable data models. You will collaborate with the Data Analyst and senior stakeholders to translate business questions into reliable data solutions.

This permanent, full-time role prioritises data engineering with some reporting support, operates on UK hours, and supports a remote-first working model.