Data Engineer (On-site, Full-Time) [AS023]

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.

Requirements

• 5+ years of data engineering experience for the global Senior route.
• Advanced SQL skills, including joins, CTEs, window functions, aggregations and debugging complex queries, with 5+ years of experience for the global route.
• 3+ years of commercial, hands-on Google BigQuery experience for the global route, with production BigQuery experience required.
• 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. GitLab or Bitbucket are acceptable substitutes.
• 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. Relevant approaches include Fivetran, Airbyte, Stitch, Azure Data Factory or custom Python ingestion.
• Experience with data quality testing and safe deployment, ensuring tests pass before deployment. Relevant approaches include dbt tests, Great Expectations or CI checks. 
• Full overlap with UK business hours, including the GMT/BST change.

Nice to Have

Basic Power BI experience for reporting and cross-cover with the Data Analyst. Looker, Tableau or other BI tools are acceptable alternatives.
Basic Python skills for simple scripts and automation.
Basic experience with Oracle NetSuite ERP data; experience with other ERP data such as Dynamics, SAP or Sage may be considered.
Awareness of and interest in AI and emerging technology. 
Experience owning a pipeline or set of models end to end.