Responsibilities
- 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.
Requirements
- 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.
- 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.
Nice to Have
- Automation mindset: familiarity with ETL concepts (dbt, Airflow, Fivetran) or AI-based tooling (Claude, Zapier) is a plus.
- Bonus points for Amplitude, Stripe, or HubSpot experience.
Benefits
- Full time indefinite contract (this is a contract position)
- 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
- You are also eligibile for our annual discretionary incentive bonus program (based on company and individual performance).
Additional Information
- Please note that this role requires candidates to be in Latin America.
- 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.
- 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.
