Strategic Data & Planning Analyst

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

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