Analytics Engineer - Real-Time Data Pipelines & AI Insights

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

Job summary

Arena Entertainment is seeking an Analytics Engineer to transform raw data into trusted, production-ready datasets powering the BI suite. You will own ETL/ELT pipelines in Snowflake and dbt for real-time and batch data, supporting cross-functional decision-making across Marketing, Product, and Retention.

You will act as SME for data across the business, ensuring reliable data delivery while collaborating with teams to ship scalable analytics solutions and pave the way for AI-driven semantic

Qualifications

• 1-3 years in Analytics Engineering or similar roles.
• Excellent SQL skills.
• Good Python skills.
• dbt experience in production environments.

Responsibilities

• Design, build, and maintain Snowflake & dbt queries.
• Build scalable ETL/ELT pipelines (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.
• Bridge product development, data, and operations with cross-functional teams.
• Move to real-time data ingestion & ETL using DMS, Kafka, or Kinesis.

Skills

SQL

Python

dbt

AWS

CI/CD

AI coding assistants

Analytics experience

Tools

Snowflake

Airflow

Fivetran

Kafka

Kinesis

GitHub Actions

Job description

Arena Entertainment is seeking an Analytics Engineer to transform raw data into trusted, production-ready datasets powering the BI suite. You will own ETL/ELT pipelines in Snowflake and dbt for real-time and batch data, supporting cross-functional decision-making across Marketing, Product, and Retention.

You will act as SME for data across the business, ensuring reliable data delivery while collaborating with teams to ship scalable analytics solutions and pave the way for AI-driven semantic