Strategy & Planning Analyst – LATAM

AirDNA

Strategy & Planning Analyst at AirDNA driving data management and analysis initiatives across multiple teams. Shaping the company’s data architecture for better business insights.

Posted 7/20/2026contractRemote • 🇲🇽 MexicoJuniorMid-Level💰 $45,000 - $50,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong SQL proficiency and experience in data analysis, with the ability to design and build data architectures and create executive dashboards. Excels in cross-functional collaboration and communication, translating complex data into actionable insights for leadership.

Highest-signal resume keywords

SQL ProficiencyData Architecture DesignBI Tools ExperienceData Quality GovernanceCross-Functional Collaboration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData AnalysisETL ConceptsData MappingDashboard CreationData ReconciliationAutomationComplex QueriesData TransformationKPI Analysis

Soft Skills

Sharp CommunicatorCollaborativeAccountableAdaptableCurious

Tools & Technologies

SigmaPower BIHexAdvanced ExcelConfluenceSnowflakePostgreSQLRedshiftAirflowFivetran

Industry Keywords

Business IntelligenceData GovernanceCross-Functional TeamsKPI PrioritiesAd-Hoc Analysis

Tech Stack

Tools & technologies

AirflowAmazon RedshiftETLPostgresPythonSQL

About the role

Key responsibilities & impact

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

What you’ll need

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.

Benefits

Comp & perks

Unlimited vacation policy; take time when you need it
Continuing education stipend
Paid parental leave
High visibility: work closely with the S&P Associate, CFO, and CEO to influence company strategy.