Lead full-stack analytics at Air by designing and maintaining dbt models and BigQuery transformation layer, ensuring data quality and observability, owning ingestion/orchestration, building self-serve BI (Mode/Hex) and AI-native interfaces, and partnering with product, growth, and GTM teams to deliver trusted data products and strategic insights.
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 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.
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
- 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
- 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.
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!
Similar Jobs
.png)
Enterprise Web • Greentech • Information Technology • Software • Energy
Design and maintain scalable dbt data models and Looker dashboards; partner with Finance, Product, and GTM to translate requirements into analytics solutions; ensure data quality with Data Engineering; perform analyses, forecasting, and QA to deliver trusted reporting and drive analytics initiatives.
Top Skills:
Ai ToolsDbtLookerSQL
AdTech
Lead analytics engineering: design scalable dimensional models, build modular tested transformations, replace brittle pipelines with reusable patterns, drive semantic layers and self-service analytics, partner on data architecture, and provide cross-functional technical leadership and governance.
Top Skills:
BigQueryCi/CdData Tests/ContractsDatabricksDbtHexIncremental ModelsLookerRedshiftSemantic LayerSigmaSnowflakeSQLSqlmeshTableauVersion Control
.png)
Greentech • Energy
Build and maintain electricity cost modeling REST APIs and DBT data pipelines, translate SME requirements into designs, participate in technical reviews, improve engineering processes, and collaborate across remote squads to deliver energy analytics and battery performance simulations.
Top Skills:
ArgoAWSDbtJavaJupyterKubernetesLarge Language Models (Llms)MongoDBNoSQLPandasPythonReactRest ApisSnowflakeSpringSpring BootSQLStreamlit
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
