Blink - The Frontline Experts

Analytics Engineer

Blink - The Frontline Experts

full-time

Posted on:

Location Type: Hybrid

Location: London • United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 £75,000 - £95,000 per year

Tech Stack

Amazon RedshiftBigQueryPythonSQL

About the role

  • Build, maintain, and optimize data transformations, models, and pipelines in dbt (or equivalent) - including testing, documentation, and version control.
  • Define, own, and monitor business metrics and models (e.g. dimension tables, slowly changing dimensions, aggregates).
  • Collaborate with analysts, BI users, data scientists, and business stakeholders to translate data requirements into reliable data products (tables, views, metrics).
  • Ensure data quality, consistency, and observability (tests, monitoring, alerting).
  • Optimize SQL queries and transformations for performance in your data warehouse / lakehouse environment.
  • Support or own CI/CD workflows around analytics (e.g. git, reviews, deployment of transformation code).
  • Build or maintain upstream data pipelines or ingestion processes when required

Requirements

  • Strong proficiency in SQL - writing and optimizing complex queries, joins, window functions, performance tuning.
  • Experience with dbt (or equivalent) - building models, tests, documentation, version control.
  • Understanding of data warehousing concepts (star schemas, snowflake, slowly changing dimensions, partitioning, clustering).
  • Experience working in a modern data stack (e.g. BigQuery, Snowflake, Redshift, Databricks, etc.)
  • Comfortable working downstream (with BI/analytics users) and upstream (pipelines, ingestion) contexts.
  • Familiarity with BI tools (we use Thoughtspot and Power BI).
  • Proficient in Python.
  • Solid software engineering skills, including version control, testing, and CI/CD.
  • Versatile and adaptable - comfortable working across the stack and able to rapidly learn new tools and solve novel problems.
  • You are a great communicator, equally comfortable engaging with technical and non-technical stakeholders
  • Experience in a lean or startup environment is a plus.
Benefits
  • Competitive salary.
  • Stock options on starting and additional high performer grants annually!
  • 25 days’ leave + public holidays.
  • Additional time off between Christmas and New Year.
  • Private healthcare with AXA.
  • 3% employer pension contribution when you contribute 5%.
  • Cycle to Work scheme.
  • Social events ( lunches, breakfasts, nights out).
  • Enhanced parental leave.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLdbtdata transformationsdata modelsdata pipelinesdata warehousingPythonCI/CDperformance tuningversion control
Soft skills
communicationcollaborationadaptabilityproblem-solvingengagement with stakeholders