Lead Analytics Engineer

2 hours, 54 minutes ago
Full-time
Lead
Data Science and Analytics

Pion

Pion is a marketing/advertising and verification company focused on helping brands attract, engage, verify, and convert Gen Z and other closed consumer groups. It describes itself as a growth partner and verification expert built on 20 years of youth marketing experience, originally starting with Student Beans in 2005, and says the broader Pion brand was born in January 2024.

Marketing and advertising
201-500
Founded 2005

Description

  • Take full ownership of the analytics engineering function and the dbt environment.
  • Design scalable data models from the staging layer through to the Golden Layer on AWS Redshift.
  • Act as a technical consultant for Product, Operations, Commercial, and other business teams.
  • Translate complex business requirements into robust data models and reliable data foundations.
  • Collaborate with the Lead Data Engineer and Analytics Lead to shape the overall data strategy.
  • Line manage, mentor, and upskill an initial team of two Analytics Engineers.
  • Conduct 1:1s, guide career progression, establish engineering standards, and oversee code reviews.
  • Own the code-based backend of the BI environment, including Lightdash and Count.
  • Architect the semantic layer and explore AI capabilities such as text-to-SQL to improve self-serve analytics.
  • Champion engineering best practices, including Git workflows, CI/CD, testing, documentation-as-code, automation, and AI-enabled efficiencies.

Requirements

  • 4+ years of highly technical experience with dbt and SQL.
  • Strong ability to write DRY, optimized code, build macros, manage dbt packages, and troubleshoot performance bottlenecks.
  • Deep hands-on experience with AWS Redshift or a similar cloud data warehouse such as Snowflake or BigQuery.
  • Strong understanding of query optimization, warehouse architecture, and DAG structures.
  • Experience interfacing transformation layers with orchestration tools such as Apache Airflow or similar.
  • Experience mentoring or line managing junior data team members.
  • Ability to support a collaborative, psychologically safe engineering culture through effective 1:1s and coaching.
  • Experience partnering with non-technical stakeholders across Product, Commercial, and Operations.
  • Advanced experience managing the code-first backend of modern BI tools such as Lightdash and Count.
  • Strong interest in automation, scripting, and AI tools to reduce repetitive manual work within a data function.

Benefits

  • Competitive salary.
  • 30 days annual leave plus bank holidays.
  • Remote-first working environment.
  • Flexible working hours between 8-10am start and 4:30-6:30pm finish.
  • Monthly wellness allowance, gym memberships, mental health first aiders, and a health cash plan.
  • Personal development and career growth support, including coaching workshops and progression plans.
  • £200 work-from-home setup allowance.
  • Access to partnership discounts with major brands such as Google, Apple, GymShark, Domino's, and Uber.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Sr Analytics Engineer

RecargaPay 251-1K Capital Markets

RecargaPay is hiring an Analytics Engineer to support its AI-first, remote financial platform by turning business needs into scalable, governed analytical data solutions.

Apache Spark Databricks dbt Git Power BI Python SQL Tableau
54 minutes ago

Martech Analyst

CloudWalk 51-250 Diversified Financial Services

CloudWalk is hiring a Martech Analyst to build and govern the data foundation that powers growth across acquisition, engagement, retention, and monetization in a remote operations role based in São Paulo.

Amplitude CRM SQL
1 hour, 39 minutes ago

Marketing Tracking & Attribution Specialist (Fluent English)

Modern.ai SaaS, B2B, AI, analytics, ecommerce/commercial intelligence

Marketing Technology Architect at a company focused on tracking and attribution infrastructure, responsible for owning server-side measurement systems and improving data integrity across client reporting and growth analytics.

Google Tag Manager JSON TikTok
2 hours, 54 minutes ago

Lead Analytics Engineer

Prolific 51-250 Professional Services

Prolific is seeking a Lead Analytics Engineer in its Data Infrastructure team to redesign and scale the company’s analytics stack, with a focus on reliable data models, pipelines, and business-facing reporting.

AWS dbt GCP SQL
5 hours, 26 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers