You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Liberty Wines

Data and Analytics Engineer

  • Office
  • 0-3 years

Salary

Not stated

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The company is moving its data estate from on-premises platforms to a cloud-based analytics environment and growing its AI and machine learning work. With an outside data consultancy, it is building a new analytics platform from scratch on BigQuery, Snowflake, dbt, Looker and Omni.

As Data and Analytics Engineer, you will help shape this platform from the start, across data engineering, modelling, reporting and enabling stakeholders. You will help choose technology, set good practice and spread data-driven thinking through the business.

Responsibilities

  • Design relational and lakehouse schemas in a cloud warehouse such as BigQuery or Snowflake, using dbt.
  • Work with the consultants to move SSAS cubes to modern lakehouse models, learning hands-on as you go.
  • Build layered, tested dbt models, from staging through to governed marts, and keep pipelines efficient and maintained.
  • Help roll out the new platform and architecture across the business and make sure the investment pays off.
  • Build, extend and maintain ETL or ELT jobs, middleware and integrations.
  • Bring in data from WMS, ERP, ecommerce, IoT and ad-hoc sources such as CSV files, APIs and unstructured data.
  • Model data through dbt and a governed semantic layer, and build dashboards for Sales, Buying, Ops and Finance.
  • Tune datasets for speed, cost and freshness using partitioning, clustering and incremental models.
  • Prepare and expose curated data for the AI and machine learning tools and workflows used by the company's AI and Automation Dev Team.
  • Keep clear documentation for BI projects, processes and solutions.
  • Apply data governance practices that meet company standards.
  • Build analysts' skills through show-and-tell sessions and guard-rail documentation.
  • Improve CI/CD pipelines and Git source control, and automate dbt and BI deployments.
  • Follow and maintain data-quality rules, lineage and catalogue standards.

Requirements

  • Solid background in data engineering, BI development or analytics engineering, and a real drive to grow with the platform.
  • Strong SQL and a good grasp of data modelling, such as dimensional modelling or 3NF.
  • Working knowledge of SQL Server or a similar relational database, including execution plans, indexing and locking.
  • Experience with ELT and with pulling data from a live transactional system without disrupting it, working under production change control.
  • Experience designing and building modern data pipelines and lakehouse architectures.
  • Hands-on use of at least one enterprise data platform, such as Google BigQuery, Snowflake, Databricks or an equivalent.
  • Familiarity with cloud services and deployment automation, such as GCP, AWS, Terraform, CI/CD and Git.
  • Ability to produce clear, insightful and fast data visualisations and dashboards in tools such as Looker, Omni, Power BI or other modern BI platforms.
  • An agile approach: comfortable with iterative delivery, peer code review and test-driven development.
  • Excellent communication and stakeholder engagement skills.
  • Desirable: experience with lakehouse patterns, including setting standards and quality checks.
  • Desirable: Parquet partitioning and clustering to improve query speed and cost.
  • Desirable: GitHub Actions.
  • Desirable: REST APIs.
  • Desirable: ML Ops tooling.

Conditions

25 days holiday, excluding public holidays, rising after 2 years of service.

The company is an equal-opportunity employer and welcomes applicants from all backgrounds and experiences.

Benefits

  • Personal bonus of up to 5% of salary, based on performance against key objectives.
  • Company bonus of up to 15% of salary.
  • Company pension scheme that matches contributions up to 5%.
  • 18 weeks of enhanced maternity leave and 4 weeks of paternity leave.
  • Cycle to work scheme and season ticket loan.
  • Employee Assistance Programme.
  • Travel insurance.
  • Employee wine discount.
  • Discounts on retail, wellbeing, technology and travel.

Where you’d work

From the office

About the company

Liberty Wines

Office in London, United Kingdom

Your chances

Worth a look before you spend an evening tailoring a CV for it.

  • 18 checks run
  • 2 red flags

Still hiring?

12 checks

No red flags

How crowded?

6 checks

2 red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details9 facts · Role, Location, Compensation
Tech stack
  • SQL
  • AWS
  • dbt
  • Looker
  • Databricks
  • Snowflake
  • BigQuery
  • Power BI
Specialty
BI
Region
United Kingdom
Pay period
Annual
Show 5 more factsShow less

Role

Category
Data & Analytics
Specialty
BI
Experience
2+ years
Tech stack
  • SQL
  • AWS
  • dbt
  • Looker
  • Databricks
  • Snowflake
  • BigQuery
  • Power BI

Location

Work model
Office
Region
United Kingdom
Office
  • London, United Kingdom

Compensation

Salary
Salary by agreement
Pay period
Annual

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason