Growth Marketing Analyst, MX

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Conduct investigations and reconcile data across Recharge (subscription management), Shopify (ecommerce), Klaviyo (email/SMS), Source Medium (analytics reporting), Snowflake (warehouse), and various paid advertising platforms (Meta, Google).

• Proactively identify and address data quality issues. The current landscape presents known discrepancies across platforms that necessitate thorough investigation and resolution.

• Create retention and lifetime value (LTV) analyses at the cohort level utilizing raw transactional data, categorized by acquisition channel, subscriber tier, and plan type.

• Develop and sustain a channel-level payback model that links acquisition costs to subsequent subscription revenue, churn rates, and lifetime value.

• Facilitate updates to financial models by supplying clean and segmented inputs (tier-weighted cost of goods sold, differentiation between gift and paid subscribers, adjusted churn rates).

• Validate and enhance the existing Snowflake ETL pipeline sourced from Recharge, backfilling historical data where necessary, and striving towards a unified source of truth.

• Generate channel-level performance reports for recurring business reviews and leadership reporting packages.

• Assist in the design of A/B tests and perform statistical analysis for landing pages, email flows, and ad creative.

⛳️ Requirements

• Proficiency in SQL (capable of writing queries against warehouse data, rather than solely utilizing a graphical user interface).

• Advanced skills in Excel/Google Sheets (including pivot tables, lookups, data modeling, and manipulation of large datasets).

• Proven comfort in using AI/LLM tools (such as Claude, ChatGPT, Copilot, or similar) for data exploration, code generation, and analytical processes.

• Demonstrated ability to reconcile conflicting data sources and assess which source to trust.

• Experience in constructing cohort retention curves and LTV models from raw transactional data.

• Background in working with ecommerce or subscription data (Shopify, Recharge, Stripe, or comparable platforms).

• Comfortable managing disorganized, incomplete, or conflicting data where clean join keys are absent.

• A self-motivated problem solver who identifies issues proactively without waiting for requests. This role does not operate on a ticket-driven reporting basis.

• Strong written communication skills in English for effectively presenting findings to non-technical stakeholders.

🏝️ Benefits

• Flexible work arrangements.