Strategy & Planning Analyst (LATAM)
Core
Foundational data architect building a unified data ecosystem to drive executive decision-making for short-term rental market data.
Role type
Strategy & Planning Analyst (Data Architect)
Builds
Unified master table architecture, executive dashboards, and automated reporting workflows.
Domain
Big data / Short-term rental market analytics
Deliverable
production ML models | dashboards & analysis | infrastructure
Required skills
SQL (complex queries, joins, window functions), Data auditing, Data mapping, Data consolidation, Executive dashboarding, Data quality governance, Cross-functional partnership
Preferred skills
ETL concepts (dbt, Airflow, Fivetran), AI-based tooling (Claude, Zapier), Amplitude, Stripe, HubSpot
Technologies
Snowflake, PostgreSQL, Redshift, Sigma, Hex, Power BI, Excel, Sheets, Confluence, Python
Responsibilities
Audit and map existing data tables across Finance, Growth, Marketing, and Customer Support; Design and build a unified master table architecture; Create executive dashboards to surface real-time KPIs; Deliver ad-hoc analyses synthesizing data into actionable recommendations; Automate reporting workflows; Ensure data quality and governance; Document processes including data lineage and transformation logic; Partner cross-functionally to understand KPI priorities and close data gaps.
Seniority
Mid-level, hands-on IC