Remote Data Engineer: Data Warehousing & Analytics

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

Job summary

Smart Working is seeking a Data Engineer to bring the organisation’s data function in-house, taking ownership of an existing data warehouse from a third-party provider. The role is ~90% data engineering and 10% reporting support, with no UI development.

You will work with the Data Analyst and data owners across the business to translate business questions into reliable data solutions, and communicate findings to non-technical stakeholders including the CEO and directors.

Qualifications

• 5+ years of data engineering experience for the global Senior route.
• 3+ years of commercial, hands-on Google BigQuery experience for the global route.
• 3+ years of production dbt experience for the global route.
• 1+ year of experience with Git/GitHub, including regular commits and branching.
• 1+ year of experience with data warehouse concepts, including ELT and dimensional modelling.
• Ability to communicate effectively with non-technical stakeholders, including CEO and director-level.
• Experience with data pipelines and managed connectors for ingesting ERP data into BigQuery.
• Experience with data quality testing and safe deployment.

Responsibilities

• Take over the existing data warehouse from the current third-party data provider during handover and run it in-house.
• Maintain and improve pipelines moving ERP data into the data warehouse for reliable, on-time data lands.
• Write and extend data models across staging, business logic, marts and reporting tables.
• Read and understand the existing codebase before building new models.
• Implement and monitor data quality tests; deploy only after tests pass.
• Use version control with clear commits and branching.
• Answer business questions using data and explain findings to non-technical colleagues incl. CEO and directors.
• Co-own core business definitions and the report library.

Skills

Advanced SQL

BigQuery

dbt

ETL pipelines

Git/GitHub

Data quality tests

Stakeholder comms

ELT concepts

Tools

Fivetran

Airbyte

Stitch

Azure Data Factory

dbt

GitHub

Job description

Smart Working is seeking a Data Engineer to bring the organisation’s data function in-house, taking ownership of an existing data warehouse from a third-party provider. The role is ~90% data engineering and 10% reporting support, with no UI development.

You will work with the Data Analyst and data owners across the business to translate business questions into reliable data solutions, and communicate findings to non-technical stakeholders including the CEO and directors.