Data Analyst II, Ecommerce
Overview
The Data Analyst II, Ecommerce role at Greenlight is responsible for owning analytics for Greenlight's devices business, which includes the Safe Family GPS tracker and the Family Hub smart home display, sold through Shopify and Amazon.
Responsibilities
Own the end-to-end measurement framework for Greenlight’s devices business across Shopify and Amazon. Define the KPIs, build the reporting, and ensure the team always has a clear, current view of device sales performance.
Measure the full funnel from ad impression to device purchase to subscriber conversion. Understand which marketing inputs drive device sales and which device buyers become high-LTV subscribers.
Analyze paid performance across Amazon Ads and Shopify-driven channels. Evaluate ROAS, CAC, and payback period at the device level and surface recommendations on where to shift spend.
Dig into the Shopify storefront and Amazon product page funnels. Identify where conversion is leaking, what product, pricing, or creative variables are driving lift, and bring findings forward before stakeholders ask.
Build and own dbt models that encode business logic for the devices domain in a scalable, reusable way to power dashboards, reporting, and stakeholder self-serve.
Build and maintain Tableau dashboards that give marketing and leadership a reliable, current view of device sales, channel performance, and subscriber attach rates.
Use Claude fluently as a daily productivity layer: accelerating SQL, generating documentation, QA-ing work, and building faster analytical workflows.
Help define and share best practices for AI-assisted analytics across the team.
Partner directly with the devices marketing team to scope analytical problems, pressure-test assumptions, and identify gaps before they become problems.
Requirements
4 to 8 years in a data or analytics role with direct experience in e-commerce or retail marketing analytics.
Hands-on experience with Shopify analytics and Amazon Seller Central or Amazon Ads.
Strong, proven SQL ability. Write clean, efficient queries across complex schemas and can build analytics logic others can maintain.
Proficient with dbt or similar tools for analytics.
Experience with Python for analytical work: data manipulation, automation, or scripting.
Fluency with Claude or similar AI tools for analytical work.
Understanding of how attribution models work in a marketplace context, what makes a good experiment, and how to think about LTV, CAC, and payback period for a hardware product that feeds a subscription business.
Ability to take a fuzzy business question and turn it into a clear analytical plan. Ask the right clarifying questions and bring structure without needing the problem handed to you pre-scoped.
Communicate findings in a way that drives decisions. Know when a chart is enough and when you need a narrative. Present to senior stakeholders and know how to calibrate.
Qualifications
Preferred experience: Amazon Clean Room, Amazon DSP, Amazon Marketing Cloud (AMC) analytics, familiarity with Shopify analytics APIs or third-party Shopify reporting tools, background in a business that sells hardware with a recurring subscription attached, hands-on experiment design experience, experience with Snowflake or a similar cloud data warehouse, experience mentoring or reviewing the work of junior analysts.
Benefits
Work perks at Greenlight include medical, dental, vision, and HSA match; paid life insurance, AD&D, and disability benefits; traditional 401k with company match; professional development stipends; mental health resources; 100% paid parental and caregiving leave, plus cleaning service and meals during your leave; flexible WFH options; fully stocked kitchen, catered lunches, and occasional in-office happy hours; Employee resource groups; and more.
Pay
The estimated base pay range for this position in NY, CA, WA is $100,000-130,000 and in CO is $100,000-120,000. Final hiring decisions are made by humans.
About Greenlight
Greenlight is a family fintech company dedicated to helping parents raise financially smart kids. We serve more than 6 million parents and kids with our award-winning banking app for families. The Data Analyst II, Ecommerce role is part of the Business Analytics team, led by the Senior Director, Business Analytics.