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 Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
