Staff Analytics Lead

Role Description

The Data team has a large seat at the table. We act as strategic advisors to every team at Air, including product, marketing, sales, and customer experience teams. Our questions and insights have led to important changes in our pricing model and product development process.

We are looking for a Staff Analytics Engineer to perform full-stack analytics — building our core data pipelines and reporting and partnering with our product and growth teams.

You’ll be in the driver’s seat establishing the analytics function at Air. Expect to drive strategic conversations about what we should measure and why; what areas of the product and what acquisition channels we should focus on and why; and what decisions we should make and why.

Core Responsibilities

• Data Modeling & the Transformation Layer
  • Own the design, health, and performance of Air's transformation layer in dbt and BigQuery.
  • Set the modeling conventions, layering strategy, and quality bar the rest of the team's models conform to.
  • Own schema governance and the structural decisions downstream tools and stakeholders depend on - like Claude skills and dashboards.
  • Keep the layer performant and cost-aware as the warehouse grows.
  • Own the long-horizon architecture so today's modeling choices don't become tomorrow's debt.
• Data Quality & Trust
  • Own what "trustworthy" means for Air's data, and the systems that enforce it.
  • Own the testing strategy, freshness SLAs, and observability that make the warehouse dependable by default.
  • Define and publish the standard for a "trusted" dataset.
  • Drive incident response and root-cause when data breaks, and close the loop so the same break doesn't recur.
  • Make data trust visible: stakeholders should be able to see freshness and reliability, not take it on faith.
• Organizational Data Enablement
  • Make every team at Air able to answer its own data questions without a data person in the loop.
  • Build and own the self-serve tooling, including AI-native interfaces, that lets non-technical teams query, explore, and trust the data themselves.
  • Partner with GTM, Finance, Product, Operations, and CS to turn business needs into performant, trustworthy data products.
  • Own the BI layer (Mode / Hex) and the trust model around it. The dashboards people rely on should be the right ones.
  • Raise the data literacy of the org.
• Data Pipeline Ownership
  • Own how data gets into the warehouse and stays reliable.
  • Own ingestion and orchestration end to end, including source API quotas and Fivetran limits, so syncs don't silently break.
  • Build the observability that flags anomalies and surfaces them to the right owner, instead of catching them by hand.
  • Keep ingestion cost-aware as sources and volume grow.
  • Contribute to internal data documentation and governance so the pipeline isn't a black box only one person understands.

Qualifications

• 6+ years experience in an analytics role, uncovering and delivering insights to stakeholders that significantly change their priorities.
• Deep hands-on DBT expertise is required: modular, tested, well-documented models; project structure at scale.
• Proficient in SQL and have extensive data modeling experience. Experience with a statistical scripting language (Python, R) is a plus.
• Experience owning a semantic or metrics layer as a shared product that standardizes business logic across tools and teams is a plus.
• Proactive communicator who can effectively partner with business stakeholders and technical teams.
• Self-drive who can gather context autonomously and translate data needs into tasks and solutions.

Benefits

• Join a rapidly scaling company with a mission to transform the creative ops space. Your work will have a direct, tangible impact on our ARR growth.
• We offer competitive medical, dental, and vision insurance, along with dependent coverage. You’ll also enjoy a generous work-from-home stipend, professional development reimbursement, and unlimited vacation days.
• We believe in the power of diverse perspectives and strive to create an inclusive culture that welcomes individuals from all backgrounds and experiences.
• The compensation range for this role is USD $183,000 - $216,000 if based in the US, and CAD $189,000 - $223,000 if based in Canada.