Jobs at Air (Now Hiring) — 3 open

The Role

Core Responsibilities

• 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

• 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

• 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

• 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

Requirements

• Experience: 6+ years experience in an analytics role, uncovering and delivering insights to stakeholders that significantly change their priorities
  • Technical Ability: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
• Collaborative:
  • Proactive communicator who can effectively partner with business stakeholders and technical teams
  • Self-drive who can gather context autonomously and translate data needs into task and solutions

How We Work at Air

• Act like a driver: Take initiative and ownership without waiting to be told.
• Work in public: Share ideas openly, get feedback early, and collaborate across teams.
• Play to win: Aim high and bring creativity, adaptability, and focus to your work.
• Say the hard thing: Give and receive feedback with clarity and respect.
• Disagree and commit: Debate honestly, then align quickly to move forward together.

Benefits

• Growth and Impact: 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.
• Comprehensive Benefits: 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.
• Commitment to Diversity: We believe in the power of diverse perspectives and strive to create an inclusive culture that welcomes individuals from all backgrounds and experiences.
• Competitive Compensation: 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.