Senior Analytics Engineer

2 hours, 55 minutes ago
Full-time
Senior
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

  • 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

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
55 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, 40 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, 55 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, 28 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