Analytics Engineer — Real-Time Data Pipelines & AI Tooling

Arena Entertainment; Greater London; On-site; GBP 55,000 - 90,000; Full time

Job summary

Arena Entertainment is hiring an Analytics Engineer to transform raw data into trusted, production-ready datasets powering our BI suite. You will own ETL/ELT pipelines within Snowflake and dbt—designing, building, and optimising them for real-time and batch data. Your work enables fast, reliable insights across the business.

You will act as SME for cross-functional teams, ensuring data quality and clarity. Initial projects focus on mature dbt modeling and AI-driven monitoring, with a strong

Qualifications

• 1-3 years in Analytics Engineering or similar roles.
• Excellent SQL skills.
• Good Python skills.
• dbt experience in production environments (macros, testing, modularisation).
• Practical hands-on experience with AWS.
• Practical ELT design and data warehousing best practices.
• Good CI/CD and Git skills.
• You have used AI coding assistants to work efficiently.

Responsibilities

• Design, build, and maintain Snowflake & dbt queries.
• Build scalable ETL/ELT pipelines (using dbt, Airflow, Fivetran).
• Transform raw data into clean, usable models as a single source of truth.
• Integrate different data sources (CRM, payments, games, etc.).
• Own initiatives for data quality improvement and monitoring (e.g. anomaly detection, automated alerts).
• Keep an eye on performance, cost, and security.
• Work closely with cross-functional teams to bridge product development, data, and operations, establishing yourself as the SME.
• Help us move to real-time data ingestion & ETL using tools like DMS, Kafka, or Kinesis.

Skills

SQL

Python

dbt

AWS

CI/CD

Git

AI coding assistants

Tools

Snowflake

Postgres

Airflow

Dagster

Fivetran

DMS

Debezium

Kafka

Kinesis

Terraform

Docker

Kubernetes

ArgoCD

GitHub Actions

QuickSight

PowerBI

Job description

Arena Entertainment is hiring an Analytics Engineer to transform raw data into trusted, production-ready datasets powering our BI suite. You will own ETL/ELT pipelines within Snowflake and dbt—designing, building, and optimising them for real-time and batch data. Your work enables fast, reliable insights across the business.

You will act as SME for cross-functional teams, ensuring data quality and clarity. Initial projects focus on mature dbt modeling and AI-driven monitoring, with a strong