Strategy & Planning Analyst
New
A
AirDNAData Analytics
Remote (LATAM)ContractMiddle
Salary$45,000 - $50,000 a year
Apply NowOpens the employer's application page
Job Details
- Experience
- 2+ years
- Required Skills
- PostgreSQLSQLBusiness IntelligenceETLMicrosoft Power BISnowflakeMicrosoft ExcelRedshift
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.
- Familiarity with ETL concepts (dbt, Airflow, Fivetran) or AI-based tooling (Claude, Zapier).
- 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.
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.
View Full Description & ApplyYou'll be redirected to the employer's site
