Data Analyst II, Ecommerce

About The Role

We are seeking a Data Analyst II, Ecommerce, to take ownership of analytics for Greenlight’s devices business, which includes physical hardware products such as the Safe Family GPS tracker and the Family Hub smart home display. These products are sold via Shopify and Amazon, and this role will serve as the analytical lead for this segment, focusing on understanding the drivers of device sales, conversion pathways, and optimizing marketing spend across channels.

Qualifications

• 4 to 8 years of experience in a data or analytics role, preferably within e-commerce or retail marketing analytics.
• Hands-on experience with Shopify analytics and Amazon Seller Central or Amazon Ads platforms.
• Strong proficiency in SQL, with a proven ability to write clean, efficient queries across complex schemas.
• Experience with dbt, including owning models in production environments.
• Proficiency in Python for data manipulation, automation, and scripting, with familiarity with pandas.
• Experience with AI tools such as Claude or similar for accelerating analytical workflows.
• Knowledge of attribution models, marketplace performance metrics, and understanding of LTV, CAC, and payback periods in hardware and subscription contexts.
• Ability to independently identify analytical opportunities, scope projects, and drive results.
• Excellent communication skills, capable of presenting complex insights to senior stakeholders.
• Preferred: Experience with Amazon Clean Room, Amazon DSP, AMC analytics, Snowflake, or mentoring junior analysts.
• Background in hardware sales with recurring subscriptions, connected devices, or smart home products is a plus.

Responsibilities

• Own the end-to-end measurement framework for Greenlight’s devices business across Shopify and Amazon, including defining KPIs and building reports.
• Measure the full funnel from ad impression to device purchase and subscriber conversion, identifying key drivers and bottlenecks.
• Analyze paid advertising performance, evaluating ROAS, CAC, and payback periods, and providing actionable recommendations to optimize spend.
• Investigate conversion rates on Shopify storefronts and Amazon product pages, identifying leakage points and opportunities for improvement.
• Develop and maintain scalable dbt models that encode business logic for the devices domain, supporting dashboards and self-serve reporting.
• Create and manage Tableau dashboards that provide real-time insights into device sales, channel performance, and customer acquisition metrics.
• Utilize AI tools such as Claude to streamline analysis, automate workflows, and enhance productivity, while establishing best practices for AI-assisted analytics.
• Collaborate closely with the marketing team to scope analytical problems, validate data quality, and ensure reporting accuracy and coverage.
• Proactively identify gaps in data, metrics, or reporting, and own the process of resolving issues to maintain reliable insights.

Benefits

• Medical, dental, and vision insurance, along with HSA matching contributions.
• Paid life insurance, accidental death & dismemberment (AD&D), and disability benefits.
• Traditional 401(k) plan with company match to support long-term financial planning.
• Unlimited paid time off (PTO), paid company holidays, and additional pop-up bonus holidays.
• Stipends for professional development and continuous learning opportunities.
• Personalized financial planning sessions with certified financial planners.
• Fertility healthcare benefits to support family planning needs.
• 100% paid parental and caregiving leave, including support services during leave.
• Flexible work arrangements with options for remote or in-office work.
• Participation in employee resource groups to foster an inclusive community.