The Data Analyst will own the reporting infrastructure for an e-commerce brand, focusing on Amazon marketplace performance, PPC efficiency, and pricing models. They will transform complex data into actionable insights and dashboards to drive revenue growth and margin expansion.
Job Title: Data Analyst
Location: Remote
Employment Type: Full-Time Contractor
Working Hours: Monday–Friday, 8:00am–4:00pm Eastern Time
Industry: E-commerce / DTC Consumer Products
About Us
Mint Source is a remote-first bridge that connects vibrant talent with international clients and agencies, enabling skilled individuals to showcase their expertise on a global stage.
Role Overview
Mint Source is hiring a Data Analyst to support a fast-growing eCommerce and direct-to-consumer (DTC) consumer brand. In this role, you'll partner closely with leadership, marketing, and operations to transform complex data into clear, actionable insights that drive smarter business decisions. You will own the reporting infrastructure that leadership relies on, building and maintaining dashboards, modeling data from multiple sources, and delivering accurate, decision-ready analysis. This role centers on Amazon marketplace performance, from market share and PPC efficiency to pricing and lifetime value, so leadership always has a real-time view of where the business is winning and where it isn't. Success requires a strong analytical mindset, exceptional attention to detail, and the ability to communicate insights clearly and proactively across the organization.
What You'll Do
- Own and refine Amazon market share reporting, focusing on key metrics such as click share, impression share, add-to-cart share, and purchase share (SQP data).
- Analyze Amazon PPC performance, measuring incrementality, efficiency, and incremental lift to identify where ad spend drives true profitability and where it does not.
- Conduct dynamic price testing and demand elasticity modeling to identify optimal price points that maximize revenue and margin.
- Build pricing architecture models that balance TACoS (Total Advertising Cost of Sales) with profitability, helping determine when to push price or reduce reliance on ads.
- Develop Amazon customer lifetime value (LTV) analyses, including the use of coupons, to measure incrementality and identify levers for increasing LTV.
- Write SQL and use Excel/Google Sheets to clean, reconcile, and QA data for accuracy and consistency across sources.
- Define metric logic, naming conventions, and documentation so stakeholders share a single source of truth.
- Build and continuously refine dashboards using tools like Looker Studio, Tableau, or Power BI, giving leadership a clear, real-time view of Amazon performance, market share trends, and actionable growth opportunities.
- Collaborate with marketing, operations, and leadership to ensure data-driven decision-making that directly impacts revenue growth and margin expansion.
What We're Looking For
- Proven experience as a Data Analyst with a focus on Amazon marketplace data and reporting.
- 2–4+ years of experience preferred, though flexible for the right fit.
- Expertise in Amazon SQP (Search Query Performance) metrics, such as click share, impression share, and purchase share, and turning them into actionable insights.
- Deep familiarity with Amazon PPC reporting, measuring incrementality, ad efficiency, and understanding the true impact on profitability.
- Strong background in dynamic pricing, demand elasticity modeling, and balancing price points with TACoS for optimal margin.
- Comfortable with Amazon LTV analysis, including coupon usage, and identifying levers to increase customer lifetime value.
- Experience building dynamic dashboards and reporting infrastructure using tools like Looker Studio, Tableau, or Power BI, ensuring leadership has real-time, reliable insights.
- Proficiency in SQL and Excel/Google Sheets to manipulate, join, and validate data.
- Ability to synthesize insights from multiple data sources and guide teams toward revenue growth and increased margins.
- Excellent communication skills, able to explain data simply to non-technical stakeholders.
- Highly detail-oriented, organized, and able to manage multiple projects, with proactive communication and openness to regular feedback.
Nice-to-have:
- Prior experience in consumer products, supplements, or DTC brands.
Key Performance Metrics (KPIs)
- Consistency & Accuracy of Reporting: Dashboards and reports present correct, reconciled Amazon data across sources with minimal errors.
- Clarity & Visual Quality: Dashboards are intuitive and easy for non-technical stakeholders to interpret.
- Responsiveness & Turnaround Time: Reliable delivery of new dashboards or ad hoc analyses to support leadership priorities.
- 30/60/90-Day Ramp: By 30 days, fluent in the existing reporting stack and Amazon data sources. By 60 days, independently owning core market share and PPC reporting. By 90 days, proactively surfacing pricing, LTV, and margin insights that shape leadership decisions.
What You Get
- A meaningful role shaping how business leaders see performance and make decisions.
- Autonomy with clear priorities, defined KPIs, and regular feedback.
- Exposure to a modern e-commerce data stack and multi-channel datasets.
- Growth opportunities through varied projects, feedback loops, and access to senior stakeholders.
- Remote-first setup with flexible Eastern Time core hours and a focused, respectful work style.
- Back-office support from Mint Source for payroll, onboarding, and HR.