- 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
- 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.
- 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.
Skills Required
- 6+ years experience in an analytics role, delivering insights that change stakeholder priorities
- Deep hands-on dbt expertise: modular, tested, well-documented models and project structure at scale
- Experience designing, maintaining, and optimizing transformations in BigQuery
- Proficient in SQL with extensive data modeling experience
- Proactive communicator who can effectively partner with business stakeholders and technical teams
- Self-driven; able to gather context autonomously and translate data needs into tasks and solutions
- Experience with statistical scripting languages (Python or R)
- Experience owning a semantic or metrics layer as a shared product
- Experience with ingestion and orchestration tooling and limits (e.g., Fivetran)
- Experience owning BI layer and dashboards (Mode, Hex) and driving data trust for stakeholders
What We Do
Air automates the mindless tasks that marketers do every day to manage content. We call this Creative Ops. Today, global brands like the NBA and Google use Air as their Creative Ops system. Our product unlocks creativity for marketers through image recognition, automated versioning, and approval workflows. We launched in March 2021 and have raised +$28M from world-class venture capital groups including Tiger Global, Headline Ventures, Lerer Hippeau, WndrCo, and Slack Ventures.
Why Work With Us
Air’s leadership cares deeply about vocational training. From the CEO to individual managers, there’s a real desire and effort to see team members growth. Whether that advancement is through internal promotion, moving into a new role to learn new skills, or chasing opportunities elsewhere, personal and professional growth is a true priority.
Gallery
.png)

.png)






