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

  • Play a key role in the Analytics Engineering function and manage the dbt environment.
  • Design, build, and maintain scalable data models from the staging layer through to the Golden Layer with a focus on performance and reliability on AWS Redshift.
  • Serve as a technical data partner to Product, Operations, Commercial, and other business functions, translating business requirements into robust data models.
  • Collaborate with the Lead Data Engineer and Analytics Lead to contribute to the overall data strategy.
  • Support and grow junior team members through code reviews, knowledge sharing, pairing, and day-to-day guidance.
  • Contribute to the code-first backend of the BI environment (Lightdash & Count or similar) and maintain the Semantic Layer.
  • Assist in integrating AI capabilities (e.g., text-to-SQL) and develop automations to advance self-serve analytics and reduce manual work.
  • Champion software engineering best practices within the data team, including GitLab/GitHub workflows, CI/CD pipelines, testing frameworks, and documentation-as-code.
  • Proactively identify and flag data quality or architectural issues and suggest improvements.

Requirements

  • 3+ years of highly technical experience with dbt and SQL.
  • Proven ability to write DRY, optimized SQL/dbt code, build macros, manage dbt packages, and troubleshoot performance bottlenecks.
  • Strong hands-on experience with AWS Redshift or a similar cloud warehouse (Snowflake/BigQuery), including query optimisation and warehouse architecture.
  • Familiarity with DAG structures and how the transformation layer interfaces with orchestration tools like Apache Airflow or similar.
  • Experience mentoring or supporting junior data team members through code reviews, pairing, or informal guidance.
  • Experience working with the code-first backend of modern BI tools (ideally Lightdash & Count, or similar).
  • Good understanding of Semantic Layer concepts and a desire to develop further in this area.
  • Comfortable partnering with non-technical stakeholders across Product, Commercial, and Ops to translate data needs into solutions.
  • Some experience or strong appetite to use AI and automation tools, scripting, and workflows to reduce repetitive manual work.

Benefits

  • Competitive salary.
  • 30 days annual leave plus bank holidays.
  • Remote-first working environment.
  • Flexible working hours (start between 8–10am and finish between 4:30–6:30pm).
  • Monthly wellness allowance, gym memberships, access to mental health first aiders, and a health cash plan.
  • £200 work-from-home setup allowance.
  • Access to partnership discounts with major global brands (e.g., Google, Apple, GymShark).
  • Commitment to personal development, coaching workshops, progression plans, and accredited 'Great Place To Work' recognition.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior Analytics Engineer

NIVA Health 11-50 Health Care Providers & Services

Senior Analytics Engineer at an unspecified company to own the analytics layer end-to-end, turning raw data into trusted metrics, models, dashboards, and reporting outputs across business and engineering teams.

dbt GCP Git GitHub JavaScript Python SQL
6 hours, 11 minutes ago

BI Engineer

Creditstar Group 51-250 Banks

Creditstar Group is seeking a BI Engineer to support reporting and decision-making across finance, risk, and product teams in its international fintech operations.

AWS Azure dbt GCP Power BI Python Snowflake SQL
11 hours, 25 minutes ago

Senior Analytics Engineer

Outreach 1K-5K Internet Software & Services

Outreach is seeking a Senior Analytics Engineer in its Business Systems team to build, document, and govern trusted data sources and models that support analytics and operational decision-making across the company.

Apache Airflow Apache Spark Databricks dbt Machine Learning PostgreSQL SageMaker Snowflake SQL Tableau
13 hours, 48 minutes ago

Analytics Engineer III

Harford County Public Library 51-250 Diversified Consumer Services

Stone Tech, o hub de tecnologia da Stone Co., busca uma pessoa Analytics Engineer Pleno para atuar com dados, visualização e modelagem em um ambiente de transformação da indústria de pagamentos.

Databricks dbt GCP Generative AI Looker Metabase SQL Tableau
1 day, 2 hours 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