Staff Analytics Engineer

Air is a Creative Ops System for creative teams. Our product automates the mindless tasks that creatives and marketers do every day to manage content and unlocks creativity through image recognition, automated versioning, and approval workflows. We launched in March 2021 and have raised $70M+ from world-class venture capital groups including Avenir, Tiger Global, Headline Ventures, Lerer Hippeau, WndrCo, and Slack Ventures. The Role 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 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 Why Air? 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. At Air, we’re committed to building a world-class team and helping every individual reach their full potential. If you're passionate about solving big problems and growing with an innovative company, we’d love to meet you!