Strategy & Planning Analyst (LATAM)

Alpine SG; United States; On-site; USD 45,000 - 50,000; Full time

Benefits offered by this job

Unlimited vacation policy

Continuing education stipend

Paid parental leave

Real influence in strategy

Get Stuff Done culture

Job summary

AirDNA seeks a Strategy & Planning (S&P) Analyst who sits at the intersection of strategy and data, partnering with the CFO and CEO to answer the company's most important questions and build the data foundation for decision-making. You'll audit data, design a unified master table, and create executive dashboards using Sigma, Power BI, and SQL-driven automation, enabling leadership with real-time KPIs.

This role offers influence and cross-functional collaboration to scale AirDNA's analytics

Qualifications

• 2+ years of experience in a data-driven, analytical role (e.g., strategy, BizOps, FP&A, consulting, or business intelligence).
• Strong SQL proficiency (complex queries, joins, window functions, CTEs) across databases like Snowflake, PostgreSQL, or Redshift.
• Strategic mindset: care about what the data means and what we should do about it.
• Initiative and ownership: form a point of view, bring ideas, and drive your own projects forward.
• Executive communication: translate complex analysis into a clear story for leadership and non-technical stakeholders.
• Experience using Hex, Sigma, Power BI, or similar; Advanced Excel/Sheets skills.
• Collaborative and low-ego: build trust quickly and work cross-functionally.

Responsibilities

• Partner directly with the CFO and CEO on high-impact strategic questions, turning complex analysis into clear, actionable recommendations.
• Identify trends, risks, and growth opportunities across the business, including questions leadership hasn't asked yet.
• Support planning, forecasting, and performance reviews, helping leadership understand what's working, what isn't, and why.
• Lead your own strategic initiatives end to end, from scoping the problem to presenting the recommendation.
• Partner cross-functionally with Growth, Finance, Marketing, and Customer Support to align on KPI priorities and close data gaps.
• Audit and map 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 that surface real-time KPIs for leadership.
• Automate reporting workflows using SQL, Python, AI tools, or BI scheduling; document data lineage and dashboards in Confluence.

Skills

SQL

Strategic mindset

Initiative & ownership

Executive communication

BI tools (Hex, Sigma, Power BI)

Excel/Sheets

Cross-functional collaboration

Data-driven analysis

ETL familiarity

Tools

Hex

Sigma

Power BI

Job description

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 who sits at the intersection of strategy and data. Partnering closely with the S&P Manager, CFO, and CEO, you'll help leadership answer the company's most important business questions, and you'll build the data foundation that makes those answers possible.

On the strategy side, you'll dig into what's driving performance, uncover opportunities and risks, and turn your analysis into clear recommendations that shape executive decisions. On the data side, you'll audit, consolidate, and enrich AirDNA's core data across Growth, Finance, Marketing, and Customer Support to create a single source of truth for the business.

This is a great opportunity to shape both how AirDNA sees its data and what it does with it. We're looking for a hands-on who takes initiative, brings their own ideas, and owns projects from the first question to the final recommendation.

Here’s what you'll get to do:

• Strategy & Insights
  • Partner directly with the CFO and CEO on high-impact strategic questions, turning complex analysis into clear, actionable recommendations.
  • Proactively identify trends, risks, and growth opportunities across the business, including questions leadership hasn't asked yet.
  • Support planning, forecasting, and performance reviews, helping leadership understand what's working, what isn't, and why.
  • Lead your own strategic initiatives end to end, from scoping the problem to presenting the recommendation and following it through.
  • Partner cross-functionally with Growth, Finance, Marketing, and Customer Support to align on KPI priorities and close data gaps.
• Data Foundation
  • Audit and map 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 that surface real-time KPIs for leadership.
  • Automate reporting workflows using SQL, Python, AI-based tools, or BI-native scheduling, freeing up time for higher-value strategic work.
  • Ensure data quality and governance by reconciling discrepancies across systems, and document data lineage, logic, and dashboards in Confluence.

Here’s what you’ll need to be successful:

• 2+ years of experience in a data-driven, analytical role (e.g., strategy, BizOps, FP&A, consulting, or business intelligence).
• Strong SQL proficiency (complex queries, joins, window functions, CTEs) across databases like Snowflake, PostgreSQL, or Redshift.
• Strategic mindset: you care as much about what the data means and what we should do about it as about how to query it.
• Initiative and ownership: you don't wait to be told what to analyze. You form a point of view, bring ideas, and drive your own projects forward.
• Executive communication: you can translate complex analysis into a clear story and recommendation for leadership and non-technical stakeholders.
• Experience using Hex, Sigma, Power BI, or similar. Advanced Excel/Sheets skills are a given.
• Collaborative and low-ego: you build trust quickly and thrive working cross-functionally.
• Accountable and adaptable: you meet deadlines and reprioritize fast in a high-growth environment.
• Hungry to grow: coachable, curious, and excited to scale AirDNA through better insights.
• Bonus points: familiarity with ETL tools (dbt, Airflow, Fivetran), AI tooling (Claude, Zapier), or experience with Amplitude, Stripe, or HubSpot.

Here’s what you can expect from us:

• Full-time indefinite contract (this is not a freelance position)
• Unlimited vacation policy; take time when you need it
• Continuing education stipend
• Paid parental leave
• Real influence: your analysis will directly shape decisions made by our CFO and CEO.
• A seat at the strategy table: high visibility with leadership, with room to grow your scope as the S&P function grows.
• Build something from scratch: design how AirDNA measures and understands its business.
• World-class data: work with one of the richest short-term rental datasets in the world.
• A culture that rewards initiative, curiosity, and a Get Stuff Done mentality.

Hiring process

• Stage 1: Initial screen with Kadriana Lopez (30 minutes)
• Stage 2: SQL deep dive with Hiring Manager, Luis Noack (45 minutes)
• Final round: Case study presentation with CFO, Henrik Hartmann (1.5 hours)

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 [e-mail]. 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.

45000 - 50000 USD a year

You are also eligible for our annual discretionary incentive bonus program (based on company and individual performance).

Any offered salary is determined based on internal equity, internal salary ranges, market data/ranges, applicant's skills and prior relevant experience, certain degrees and certifications.