The Role
Build a unified data architecture for AirDNA's Strategy & Planning team: audit and consolidate cross-functional data, create executive dashboards, deliver ad-hoc analyses, automate reporting, ensure data quality and governance, document processes, and partner with Growth, Finance, Marketing, and Support to close data gaps.
Summary Generated by Built In
About AirDNA
We built AirDNA to solve a problem: how do you make smart short-term rental decisions when there’s too much guesswork and not enough good data? What started in a garage in California in 2015 is now a global team helping thousands of people — from aspiring hosts to major real estate firms — make confident choices about where to invest, what to charge, and how to grow. Our mission is simple: give people the tools they need to build freedom through short-term rentals. Whether that means buying their first Airbnb or scaling a portfolio, we’re here to help unlock financial independence and growth. We track 10M+ listings in 120,000 markets, and our platform is trusted by users in over 100 countries. It’s big data, made useful.
The AirDNA team
We’re a curious, driven, and kind group of humans who genuinely love what we do. Our values — Happy, Hungry, Honest — guide how we show up for our customers and for each other. You’ll get a feel once you meet us.
We welcome applicants from all backgrounds and encourage you to apply even if you don’t check every box. Passion, potential, and perspective matter here.
The Role
We're looking for a Strategy & Planning (S&P) Analyst to serve as the foundational data architect within our S&P function. Partnering closely with the S&P Associate as well as CFO, you'll build a unified, comprehensive data ecosystem across AirDNA auditing, consolidating, and enriching the company's core data tables to deliver a holistic view of business performance.
This is a ground-floor opportunity to shape how an entire company sees and uses its data. You'll work cross-functionally with Growth, Finance, Marketing, and Customer Support, leveraging SQL, BI tools, and automation to turn fragmented data into a single source of truth that drives executive decision-making.
Here's what you'll get to do:
- Audit and map all existing data tables across Finance, Growth, Marketing, and Customer Support.
- Design and build a unified master table architecture that consolidates cross-functional data into a single source of truth.
- Create executive dashboards in Sigma or similar BI tools to surface real-time KPIs for leadership.
- Deliver ad-hoc analyses for the S&P Associate and CFO, synthesizing data from multiple sources into actionable recommendations.
- Automate reporting workflows using SQL, Python, AI-based tools, or BI-native scheduling to reduce manual work.
- Ensure data quality and governance by reconciling discrepancies across systems and enforcing consistency.
- Document all processes including data lineage, transformation logic, and dashboard guides in Confluence.
- Partner cross-functionally with Growth, Finance, Marketing, and Customer Support to understand KPI priorities and close data gaps.
Here's what you'll need to be successful:
- 2+ years of experience in a data-driven, analytical role (e.g., strategy, consulting, business intelligence).
- Strong SQL proficiency (complex queries, joins, window functions, CTEs) across databases like Snowflake, PostgreSQL, or Redshift.
- Experience using Hex, Sigma, Power BI or similar. Advanced Excel/Sheets skills are a given.
- Automation mindset: familiarity with ETL concepts (dbt, Airflow, Fivetran) or AI-based tooling (Claude, Zapier) is a plus.
- Builder’s mentality: a self-starter energized by ambiguity and the chance to architect something from the ground up.
- Sharp communicator who translates complex data into clear insights for non-technical stakeholders.
- Collaborative and low-ego: you build trust quickly across teams and thrive working cross-functionally.
- Accountable and adaptable: you take ownership, meet deadlines, and reprioritize fast in a high-growth environment.
- Hungry to grow: coachable, curious, and excited to scale AirDNA through better data.
- Bonus points for Amplitude, Stripe, or HubSpot experience.
Here's what you can expect from us:
- Full time indefinite contract (this is a contract position)
- Unlimited vacation policy; take time when you need it
- Continuing education stipend
- Paid parental leave
- Work at the intersection of data, technology, and travel in a high-growth company.
- Build something from scratch. This role is a greenfield opportunity to design AirDNA's data infrastructure.
- High visibility: work closely with the S&P Associate, CFO, and CEO to influence company strategy.
- Collaborate with a passionate and driven team that values ownership and impact.
- A culture that rewards initiative, curiosity, and a Get Stuff Done mentality
AirDNA seeks to attract the best-qualified candidates who support the mission, vision and values of the company and those who respect and promote excellence through diversity. We are committed to providing equal employment opportunities (EEO) to all employees and applicants without regard to race, color, creed, religion, sex, age, national origin, citizenship, sexual orientation, gender identity and expression, physical or mental disability, marital, familial or parental status, genetic information, military status, veteran status or any other legally protected classification. The company complies with all applicable state and local laws governing nondiscrimination in employment and prohibits unlawful harassment based on any of the aforementioned protected classes at every location in which the company operates. This applies to all terms, conditions and privileges of employment including but not limited to: hiring, assessments, probation, placement, benefits, promotion, demotion, termination, layoff, recall, transfer, leave of absence, compensation, training and development, social and recreational programs, education assistance and retirement.
We are committed to making our application process and workplace accessible for individuals with disabilities. Upon request, AirDNA will reasonably accommodate applicants so they can participate in the application process unless doing so would create an undue hardship to AirDNA or a threat to these individuals, others in the workplace or the company as a whole. To request accommodation, please email [email protected]. Please allow for 24 hours to process your request.
By applying for the above position, you will confirm that you have reviewed and agreed to our Data Privacy Notice for Applicants.
Skills Required
- 2+ years in a data-driven analytical role (strategy, consulting, business intelligence)
- Strong SQL proficiency (complex queries, joins, window functions, CTEs)
- Experience with databases like Snowflake, PostgreSQL, or Redshift
- Experience using Hex, Sigma, Power BI or similar BI tools
- Advanced Excel and Google Sheets skills
- Automation mindset and familiarity with ETL concepts (dbt, Airflow, Fivetran)
- Experience using or integrating AI-based tooling (Claude, Zapier) for automation
- Ability to automate reporting workflows using SQL and Python
- Strong communication skills to translate data for non-technical stakeholders
- Self-starter with a builder's mentality and ability to work with ambiguity
- Collaborative, low-ego team player who builds trust cross-functionally
- Experience documenting data lineage, transformation logic, and dashboards in Confluence
- Bonus: experience with Amplitude, Stripe, or HubSpot
What the Team is Saying
Austin
Social Media Manager
Bree
Account Manager
Kristie
Data Engineering Lead
Diane
Senior Accountant
Marc
Senior Data Scientist
AirDNA Compensation & Benefits Highlights
-
Leave & Time Off Breadth — Unlimited PTO, sick time, paid holidays, and a paid sabbatical indicate broad support for time away and rest. Hybrid work and flexibility further reinforce the ability to take meaningful time when needed.
-
Parental & Family Support — Paid parental leave, a structured return‑to‑work program, and an onsite Mother’s Room point to strong family support. Company‑sponsored family events further underscore a family‑friendly approach.
-
Healthcare Strength — Medical, dental, and vision coverage are core offerings, with multiple indications of strong plan availability. Coverage is complemented by protections such as life and disability insurance.
AirDNA Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
We built AirDNA to solve a problem: how do you make smart short-term rental decisions when there’s too much guesswork and not enough good data? What started in a garage in California in 2015 is now a global team helping thousands of people — from aspiring hosts to major real estate firms — make confident choices about where to invest, what to charge, and how to grow. Our mission is simple: give people the tools they need to build freedom through short-term rentals. Whether that means buying their first Airbnb or scaling a portfolio, we’re here to help unlock financial independence and growth. We track 10M+ listings in 120,000 markets, and our platform is trusted by users in over 100 countries. It’s big data, made useful. In 2023, AirDNA acquired Uplisting, a powerful property management software that helps hosts and operators manage listings across Airbnb, Vrbo, and other platforms. With features like channel management, automated messaging, dynamic pricing, task coordination, and financial reporting, Uplisting expands our mission to support every stage of the short-term rental journey — from investment to operations.
Why Work With Us
We’re a curious, driven, and kind group of humans who genuinely love what we do. Our values — Happy, Hungry, Honest — guide how we show up for our customers and for each other.
Gallery
AirDNA Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
Typical time on-site:
Flexible
