Data Analyst

This is a fully remote position, open to applicants in Philippines.

📋 Description

• Take ownership of refining the reporting of Amazon market share, concentrating on essential metrics such as click share, impression share, add-to-cart share, and purchase share (SQP data).

• Evaluate Amazon PPC performance by assessing incrementality, efficiency, and incremental lift to pinpoint where advertising expenditure contributes to genuine profitability and where it does not.

• Implement dynamic price testing and demand elasticity modeling to discover optimal price points that enhance revenue and margin.

• Create pricing architecture models that balance TACoS (Total Advertising Cost of Sales) with profitability, assisting in decisions regarding price increases or reduced ad reliance.

• Formulate analyses of Amazon customer lifetime value (LTV), encompassing coupon utilization, to gauge incrementality and identify strategies for enhancing LTV.

• Utilize SQL and Excel/Google Sheets to clean, reconcile, and ensure data accuracy and consistency across various sources.

• Establish metric logic, naming conventions, and documentation to ensure stakeholders have a unified source of truth.

• Develop and continually enhance dashboards utilizing tools like Looker Studio, Tableau, or Power BI, providing leadership with a clear, real-time overview of Amazon performance, market share trends, and actionable growth opportunities.

• Work collaboratively with marketing, operations, and leadership to promote data-driven decision-making that directly influences revenue growth and margin expansion.

⛳️ Requirements

• Demonstrated experience as a Data Analyst with a focus on data and reporting from the Amazon marketplace.

• 2–4+ years of experience preferred, although flexibility exists for the right candidate.

• Proficiency in Amazon SQP (Search Query Performance) metrics, including click share, impression share, and purchase share, and the ability to translate them into actionable insights.

• Extensive knowledge of Amazon PPC reporting, particularly in measuring incrementality, ad efficiency, and understanding its true effect on profitability.

• Strong expertise in dynamic pricing, demand elasticity modeling, and balancing price points with TACoS for optimal margins.

• Familiarity with Amazon LTV analysis, including coupon application, and identifying strategies to maximize customer lifetime value.

• Experience in creating dynamic dashboards and reporting frameworks using tools like Looker Studio, Tableau, or Power BI, ensuring that leadership has access to real-time and reliable insights.

• Proficient in SQL and Excel/Google Sheets for data manipulation, joining, and validation.

• Capacity to synthesize insights from diverse data sources and guide teams toward revenue growth and improved margins.

• Exceptional communication skills, capable of simplifying data for non-technical stakeholders.

• Highly detail-oriented, organized, and adept at managing multiple projects, with proactive communication and a receptiveness to ongoing feedback.

🏝️ Benefits

• Remote-first setup with flexible core hours aligned with Eastern Time.

• Back-office support from Mint Source for payroll, onboarding, and HR.