Growth Marketing Analyst (CO)

Catch Co. is the maker of Mystery Tackle Box, a fishing subscription box aiming to get people outdoors. The Growth Marketing Analyst role involves building data infrastructure for the company's growth marketing function, focusing on data reconciliation, quality, and performance analysis.

Responsibilities:

• Investigate and reconcile data across Recharge (subscription management), Shopify (ecommerce), Klaviyo (email/SMS), Source Medium (analytics reporting), Snowflake (warehouse), and paid ad platforms (Meta, Google)
• Surface data quality problems proactively. The current environment has known discrepancies across platforms that require investigation and resolution
• Build cohort level retention and LTV analysis from raw transactional data, segmented by acquisition channel, subscriber tier, and plan type
• Develop and maintain a channel level payback model connecting acquisition costs to downstream subscription revenue, churn, and lifetime value
• Support financial model updates by providing clean, segmented inputs (tier weighted COGS, gift vs paid subscriber separation, adjusted churn rates)
• Validate and extend the existing Snowflake ETL pipeline from Recharge, backfill historical data where gaps exist, and work toward a single source of truth
• Produce channel level performance reporting for recurring business reviews and leadership reporting packages
• Support A/B test design and statistical analysis for landing pages, email flows, and ad creative

Requirements:

• SQL proficiency (writing queries against warehouse data, not just using a GUI)
• Excel/Google Sheets at an advanced level (pivot tables, lookups, data modeling, large dataset manipulation)
• Demonstrated comfort using AI/LLM tools (Claude, ChatGPT, Copilot, or similar) for data exploration, code generation, and analytical workflows
• Demonstrated ability to reconcile conflicting data sources and determine which source to trust
• Experience building cohort retention curves and LTV models from raw transactional data
• Experience working with ecommerce or subscription data (Shopify, Recharge, Stripe, or equivalents)
• Comfortable working with messy, incomplete, or conflicting data where clean join keys do not exist
• Self directed problem solver who surfaces issues before being asked. This is not a ticket driven reporting role
• Strong written communication in English for presenting findings to non technical stakeholders
• Experience with Snowflake or similar data warehouses, including pipeline validation and data engineering
• Experience with ad platform data (Meta Ads Manager, Google Ads) and understanding of attribution models
• Experience with Klaviyo or similar email/SMS marketing platforms
• Experience building AI-assisted analytical workflows (e.g., using LLMs for data reconciliation, anomaly detection, or automated reporting)
• Experience with Source Medium or similar analytics reporting tools
• Python or R for data manipulation and automation
• Financial modeling experience (LTV, payback period, contribution margin)
• Experience in a subscription box or D2C subscription business