LMArena

Analytics Engineer

LMArena

full-time

Posted on:

Location Type: Hybrid

Location: Bay Area • California • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowBigQueryPythonSQL

About the role

  • 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

  • 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
  • Comprehensive health and wellness benefits, including medical, dental, vision, and additional support programs.
  • The opportunity to work on cutting-edge AI with a small, mission-driven team
  • A culture that values transparency, trust, and community impact
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