Ecommerce Growth & Data Analyst (LTV, Cohorts, Data Reconciliation)

Original Post

**About Us** We are a fast\-growing D2C subscription ecommerce brand building a lean, profitable, and data\-driven business. Our products reach customers through major retail platforms and online channels, and we are rebuilding our growth marketing function from the ground up. Data is at the center of how we make decisions — and this role is central to how we build that capability. **What This Role Is** This is not a reporting role. It is an investigative and systems\-building role for someone who has worked deep inside ecommerce or subscription data and knows how messy it really is. You will own the data infrastructure that connects acquisition spend to subscriber retention and lifetime value. You will reconcile conflicting data across platforms, build models that drive real business decisions, and be the person who flags problems before anyone else notices them. If you have spent time working with Shopify orders, subscription lifecycles, churn cohorts, and ad platform attribution — and you know where the data breaks down and why — this role was written for you. **What You Will Do** * **Investigate and reconcile** data across Recharge, Shopify, Klaviyo, Snowflake, Source Medium, Meta, and Google Ads — identifying discrepancies, finding root causes, and documenting resolutions * **Build cohort\-level retention and LTV models** from raw transactional data, segmented by acquisition channel, subscriber tier, and plan type * **Develop a channel\-level payback model** that connects acquisition cost to subscription revenue, churn, and lifetime value over time * **Support financial model inputs** — including tier\-weighted COGS, gift vs. paid subscriber separation, and adjusted churn rates * **Validate and extend the Snowflake ETL pipeline** from Recharge, backfill historical gaps, and work toward a single source of truth * **Produce recurring performance reports** for business reviews and leadership — clear, narrative\-driven, and actionable * **Design and analyse A/B tests** across landing pages, email flows, and ad creative * **Surface data quality issues proactively** — with a hypothesis, context, and ideally a fix **You Must Have** * **3\+ years working with ecommerce or subscription data** — Shopify, Recharge, Stripe, or direct equivalents. You understand order lifecycles, subscription events, cancellation flows, and how revenue is recognized across these platforms * **Strong SQL skills** — writing queries from scratch against warehouse data, not using a GUI * **Hands\-on experience reconciling data across multiple platforms** — you know how to figure out which source to trust and why * **Experience building cohort retention curves and LTV models** from raw transaction\-level data * **Advanced Excel or Google Sheets** — pivots, lookups, financial modeling, large datasets * **Active use of AI/LLM tools** (Claude, ChatGPT, Copilot, or similar) as part of your day\-to\-day analytical workflow * **Strong written English** for communicating findings to non\-technical stakeholders * **Self\-directed work style** — you surface problems before being asked and drive investigations to completion without hand\-holding **Nice to Have** * Experience with Snowflake or similar data warehouses, including ETL validation and pipeline work * Experience with Meta Ads Manager and Google Ads data, and familiarity with attribution models and their limitations * Experience with Klaviyo or similar email/SMS platforms * Experience with Source Medium or similar analytics reporting layers * Python or R for data manipulation and automation * Financial modeling experience — payback period, contribution margin, unit economics * Experience in a subscription box or D2C subscription business specifically **You Are the Right Person If** * You have looked at Shopify revenue and Recharge revenue for the same period and wondered why they don't match — and then figured out why * You know that last\-click attribution from Meta overstates performance and you can explain what to do about it * You build models that answer the next ten questions, not just the one in front of you * You flag a data problem with a hypothesis and a proposed fix, not just a Slack message saying "something looks off" * You translate messy data into a clear story that a founder or marketing lead can act on immediately **Why Join Us** * Ground\-floor opportunity to build the data function of a scaling D2C brand * Direct access to leadership and real influence on business decisions * Work across the full stack — from raw warehouse data to executive reporting * Fast\-moving, lean team where your work is visible and your impact is real *If you have deep ecommerce data experience and enjoy detective work as much as model building, we'd love to hear from you.* Job Type: Full\-time Pay: ₹1,000,000\.00 \- ₹1,900,000\.00 per year Benefits: * Work from home Application Question(s): * Q1\. How would you rate your SQL skills when working with raw warehouse data? * Q2\. Have you worked with ecommerce or subscription data (e.g., Shopify, Recharge, Stripe)? * Q3\. Have you built cohort\-based retention or LTV models from raw transactional data? * Q4\. Have you worked on reconciling data across multiple platforms (e.g., Shopify, Recharge, Ads, CRM)? * Q5\. Which tools/platforms have you worked with? * Q6\. How comfortable are you working with incomplete or inconsistent datasets (missing keys, conflicting numbers)? * Q7\. What is your level of proficiency in Excel / Google Sheets? * Q8\. Have you worked on CAC, LTV, or payback period calculations? * Q9\. Do you use AI tools (ChatGPT, Claude, Copilot, etc.) in your data analysis workflow? * Q10\. Do you have experience with Snowflake or similar data warehouses? Work Location: Remote