Senior E-commerce Revenue & Profitability Analyst

Scale Up Recruiting Partners; A distancia; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A recruitment agency is seeking a Senior Analyst for a remote e-commerce analytics role. The ideal candidate will have extensive experience in analyzing Amazon Seller Central and Shopify data, focusing on revenue, unit economics, and profitability. Responsibilities include building profitability models, conducting in-depth analyses, and collaborating with leadership. Strong SQL skills and a business-driven mindset are essential for success in this position, aimed at driving data-informed decisions within a fast-paced environment.

Formación

• 4+ years in a hands-on e-commerce analytics role.
• Proven experience analyzing Amazon Seller Central and Shopify data.
• Strong SQL experience used for critical analysis.

Responsabilidades

• Build and maintain SKU-level profitability and contribution margin models.
• Analyze revenue, unit economics, and LTV models.
• Translate complex findings into actionable recommendations.

Conocimientos

Hands-on e-commerce analytics

SQL

Data analysis

Interpreting Amazon metrics

Business mindset

Herramientas

Looker

Tableau

Fivetran

Descripción del empleo

Location: Remote (LATAM)

Employment Type: Full‑time

Contract Type: Contractor (Long‑term)

About The Company

Our client is a fast‑growing U.S.‑based company that owns and operates multiple pet product brands across Amazon and direct‑to‑consumer responsibilities. With a strong presence in the U.S. market, the company is scaling rapidly, managing a complex multi‑SKU, multi‑brand portfolio in a highly competitive e‑commerce environment.

Data plays a central role in how decisions are made, especially when it comes to pricing, growth efficiency, and long‑term profitability.

About The Role

This is a hands‑on, SQL‑driven e‑commerce analytics role with a strong focus on revenue, unit economics, LTV, and profitability.

We are looking for a Senior Analyst who can independently analyze Amazon Seller Central and Shopify data, build robust profitability and LTV models, and diagnose performance drops without relying on predefined dashboards.

This role goes beyond reporting. You will act as an analytical owner of the business performance, partnering closely with leadership to identify root causes, quantify impact, and recommend corrective actions that directly influence revenue and margins.

What You’ll Own

Revenue, Profitability & LTV Ownership

• Build and maintain SKU‑level profitability and contribution margin models
• Develop LTV models by cohort, channel, and acquisition source
• Analyze CAC, payback periods, and long‑term profitability by channel
• Identify margin erosion drivers across pricing, fees, ads, fulfillment, and logistics
• Support pricing, discounting, and promotional decisions with data‑backed insights

Amazon Seller Central & Shopify Deep Analysis

• Perform hands‑on analysis of Amazon Seller Central data (fees, ads, TACoS, organic vs paid performance)
• Analyze Shopify/DTC performance including conversion, retention, and subscription behavior
• Evaluate the impact of Amazon fees, FBA costs')['returns' storage on unit economics
• Diagnose revenue, conversion, or margin drops across Amazon and Shopify independently

Advanced SQL & Data Analysis

• Use SQL daily to extract, join, and analyze raw data from multiple sources
• Design custom analyses rather than relying solely on existing dashboards
• Identify anomalies, trends, and root causes in large e‑commerce datasets
• Translate complex findings into clear, actionable recommendations

Business & Leadership Collaboration

• Present insights and recommendations directly to leadership
• Partner with growth, marketing, and operations teams to turn analysis into action
• Act as a thought partner on scaling decisions, budget allocation, and channel strategy

Qualifications

Required

• 4+ years in a hands‑on e‑commerce analytics role
• Proven experience analyzing Amazon Seller Central and Shopify data
• Strong, practical SQL experience (used for business‑critical analysis)
• Demonstrated experience building profitability, unit economics, and LTV models
• Ability to independently diagnose and explain performance drops
• Strong business mindset with the ability to connect data to revenue and margin impact

Nice to Have

• Experience with BI tools (Looker, Tableau, Triple Whale,pletely
• Familiarity with data pipelines (Fivetran, Stitch, etc.)
• Python or R for advanced analysis
• Experience working with multi‑brand or multi‑SKU portfolios
• Background in consumer goods or e‑commerce brands