Remote Data Engineer - Build, Own & Scale Global Data

Smart Working; Brierley Hill; Remote; GBP 65,000 - 90,000; Full time

Job summary

Smart Working is recruiting a Data Engineer for a permanent, full‑time remote role. You will take ownership of an in‑house data warehouse, optimise ERP data pipelines and extend data models feeding the reporting layer.

The role suits candidates with 5+ years in data engineering, strong SQL, BigQuery and dbt experience, plus Git proficiency. You’ll work with the Data Analyst and senior stakeholders, including the CEO, to translate business questions into robust data solutions while maintaining

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, including regular commits, clear commit messages and branching.
• 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, ensuring tests pass before deployment.

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

Data modelling

Communication with stakeholders

Problem solving

Tools

BigQuery

dbt

Git

Python (basic)

Job description

Smart Working is recruiting a Data Engineer for a permanent, full‑time remote role. You will take ownership of an in‑house data warehouse, optimise ERP data pipelines and extend data models feeding the reporting layer.

The role suits candidates with 5+ years in data engineering, strong SQL, BigQuery and dbt experience, plus Git proficiency. You’ll work with the Data Analyst and senior stakeholders, including the CEO, to translate business questions into robust data solutions while maintaining