Analytics Engineer

Arena

Analytics Engineer designing and building data models for AI performance evaluations at Arena Intelligence. Collaborating with researchers and product managers while ensuring data quality and scalability.

Posted 4/12/2026full-timeBay Area • California • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

AirflowBigQueryPythonSQL

About the role

Key responsibilities & impact

Own the design and implementation of analytics-ready data models, schemas, and tables in our data warehouse
Build and maintain reliable data pipelines (batch and incremental) that transform raw event and vote data into standardized, trusted datasets
Define and standardize core metrics used across product, research, and customer-facing evaluations
Partner with product managers and researchers to translate evaluation questions into robust data models
Develop and maintain dashboards, reports, and data artifacts used by internal teams and external partners
Ensure data quality through testing, validation, monitoring, and documentation
Orchestrate and schedule data workflows using Airflow or equivalent tools
Optimize queries and pipelines to support large-scale analytical workloads
Contribute to improving data discoverability, lineage, and documentation across the warehouse

Requirements

What you’ll need

3+ years of experience in analytics engineering, data engineering, or a closely related role
Strong proficiency in SQL, with experience designing analytics-friendly schemas and transformations
Hands-on experience working with a modern data warehouse (e.g., Databricks, Snowflake, BigQuery)
Experience building and orchestrating data pipelines using Airflow or similar workflow orchestration tools
Proficiency in Python for data transformation, validation, and pipeline development
A strong understanding of data modeling best practices (e.g., dimensional modeling, metrics layers)
Experience operating and debugging production data pipelines with a focus on correctness and reliability.

Benefits

Comp & perks

Comprehensive health and wellness benefits, including medical, dental, vision, and additional support programs.
Competitive compensation and equity aligned to the markets where our team members are based.
The opportunity to work on cutting-edge AI with a small, mission-driven team.
A culture that values transparency, trust, and community impact.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythondata modelingdata transformationdata validationdata pipeline developmentanalytics-friendly schemasdimensional modelingmetrics layersdata quality testing