战略与规划分析师（拉美区）
Strategy & Planning Analyst (LATAM)
AirDNA简介
我们创建AirDNA的初衷是为了解决一个问题：当有太多猜测而缺乏可靠数据时，如何做出明智的短期租赁决策？2015年在加州车库中起步的项目，如今已发展成一个全球团队，帮助成千上万的人——从有志成为房东的人到大型房地产公司——在投资地点、定价策略和增长方式上做出自信的选择。我们的使命很简单：为人们提供实现自由所需的工具。无论是购买第一处Airbnb房源还是扩大投资组合，我们都致力于帮助用户实现财务独立和增长。我们追踪1000多万个房源，覆盖12万个市场，平台被超过100个国家的用户所信赖。这是真正有用的大数据。
AirDNA团队
我们是一群充满好奇心、有动力且善良的人，我们真心热爱自己的工作。我们的价值观——快乐、渴望、诚实——指导着我们如何为客户和彼此服务。你一旦与我们接触就会感受到这一点。
我们欢迎来自不同背景的申请人，即使你没有满足所有条件也请申请。热情、潜力和视角在这里非常重要。
职位描述
我们正在寻找一名战略与规划（S&P）分析师，作为S&P部门的基础数据架构师。与S&P助理以及首席财务官紧密合作，你将构建统一且全面的数据生态系统，对AirDNA的审计、整合和丰富核心数据表，以提供业务表现的全景视图。请注意，该职位要求候选人位于拉丁美洲。
这是一个从零开始的机会，可以塑造整个公司如何看待和使用数据。你将与增长、财务、营销和客户支持团队跨职能合作，利用SQL、商业智能工具和自动化技术，将分散的数据转化为驱动高管决策的单一真实数据源。
以下是你的工作内容：
审计并绘制财务、增长、营销和客户支持部门的所有现有数据表。
设计并构建统一的主表架构，将跨职能数据整合为单一真实数据源。
在Sigma或其他类似BI工具中创建高管仪表盘，展示实时关键绩效指标。
为S&P助理和首席财务官提供临时分析，将多来源数据综合为可操作的建议。
使用SQL、Python、基于AI的工具或BI原生调度功能自动化报告流程，减少手动工作。
确保数据质量
查看英文原文
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. Please note that this role requires candidates to be in Latin America.
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
36 holidays per year
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
Hiring process
Stage 1: Recruiter screen with Kadriana (30 minutes)
Stage 2: Interview and live SQL test with Luis Noack (60 minutes)
Final round: Case study presentation with CFO, Henrik Hartmann (45 minutes)
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 compliance@airdna.co. 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.