eCommerce Business Analyst (Hybrid)
Role details
Job location
Tech stack
Job description
The Ecommerce Business Analyst supports the Ecommerce team by gathering information, digging into complex problems, and translating data into easily consumable reports with actionable insights. A successful team member will proactively monitor website performance, innovate current reporting and forecasting processes, support Ecommerce leadership in measuring goals, and shape measurable KPIs to help the team quickly identify how changes impact the business and where resources should be focused., Reporting and Dashboard Ownership
-
Own, maintain, and continuously improve Ecommerce performance dashboards in Sigma, ensuring self-service reporting that answers common day-to-day questions about the business
-
Proactively monitor website performance on a daily basis, surfacing emerging trends, anomalies, and conversion rate shifts to Ecommerce leadership before they become material headwinds
-
Support weekly business reporting on Ecommerce KPIs, ensuring leadership and business partners have clear visibility into drivers of performance across Website, Amazon, and Inside Sales channels
-
Deliver product performance insights, promotional hindsight analysis, and ad-hoc analytical requests for the Ecommerce team
-
Partner with the Business Intelligence team to define and maintain necessary tables in Snowflake to store and reference KPIs across all reports
Forecasting and Planning
-
Play a key role in total-business planning and forecasting, working cross-functionally to deliver challenging and achievable sales and KPI targets
-
Maintain end-to-end AOP KPIs in reporting dashboards with consistent updates aligned to changing forecasts
-
Oversee net new processes for capturing, prioritizing, and delivering financial modeling requests
Site Analytics and Testing
-
Design, execute, and analyze A/B and multivariate website tests, translating results into clear recommendations for site optimization
-
Monitor and report on conversion rate performance, with the ability to overlay current trends against prior-year benchmarks to identify meaningful shifts
-
Leverage Adobe Analytics as the primary web data source, establishing and maintaining accurate baselines as the platform evolves
-
Cross-train on additional web analytics tooling as needed to create detailed promotional recap analyses with attention to messaging, merchandising, and media performance
AI and Self-Service Analytics
-
Use AI tools and LLMs (e.g., Claude) to accelerate data analysis, draft insights, and improve reporting workflows through effective prompt engineering
-
Help drive the Ecommerce team's transition toward self-service analytics, identifying opportunities to reduce dependency on centralized BI resources for routine reporting needs
Cross-Functional Collaboration
-
Develop strong relationships with Merchandise Planning, Product Management, Consumer Insights, Marketing Strategy, and Advertising teams to support total Ecommerce business needs
-
Collaborate with Product, Supply, and Ops teams to improve the S&OP process and identify promotional execution opportunities tied to inventory positioning, * Adjusting or moving objects up to 15 pounds in all directions
Regular activities include:
-
Communicating with others to exchange information
-
Repeating motions that may include the wrists, hands, and/or fingers
-
Assessing the accuracy, neatness, and thoroughness of assigned work
The physical demands described are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with a disability to perform the essential functions.
Requirements
You are creative and resourceful in your approach to identifying opportunities and solving problems, driving incremental value within the business. You have excellent analytical skills with the ability to extract, analyze, and explain promotional performance, business trends, and consumer behavior. You know how to balance business needs, consumer expectations, and technology constraints to help the team deliver innovative experiences that lead to deep brand and product loyalty. You have a passion for building productive, cross-functional relationships and thrive in collaborative environments., * Bachelor's degree in Business, Data Analytics, or related field
-
3+ years of demonstrated success as a business analyst or in a similar role
-
Experience in omni-channel retail with emphasis on Ecommerce or other DTC channels
-
Adobe Analytics: hands-on experience monitoring visitor and consumer engagement; ability to establish baselines and interpret differences across analytics platforms
-
Snowflake: experience querying and organizing data using SQL-based data warehousing
-
Excel: advanced proficiency for data manipulation, forecasting models, and ad-hoc analysis
-
AI and LLM prompting: demonstrated ability to use tools like Claude to accelerate analysis, generate insights, and streamline reporting workflows
-
A/B and multivariate testing: experience designing, executing, and interpreting website experiments with clear business recommendations
-
Experience compiling and analyzing large datasets and communicating results to senior stakeholders with actionable insights
-
Experience forecasting or planning using historical data, current trends, and assumptions
-
Understanding of data visualization best practices through dashboard or business report creation
Preferred Skills, Education, and Experience
-
Sigma: experience building and maintaining dashboards in Sigma for self-service business reporting
-
Looker: familiarity with Looker dashboards and Looks; experience supporting or managing a Looker migration is a plus
-
NetSuite: experience accessing and interpreting financial or operational data within NetSuite
-
Commercetools: familiarity with commerce platform data structures and order management reporting
-
Understanding of basic statistical models (regressions, cluster analysis) and their use in prediction and optimization; experience with R, Python, or similar tools is a plus
-
Excellent presentation and reporting skills with the ability to communicate complex data clearly to executive audiences
-
Ability to handle complex and often ambiguous problems while coordinating multiple projects simultaneously
-
Highly detail oriented, well organized, and able to demonstrate strong leadership and personal accountability within a collaborative team environment
Benefits & conditions
The compensation target for this role is: $97,800 - $115,000, * Medical, Dental, Vision
- 401(k) Match
- Flexible PTO
- Earn a Mattress
- Purple Swag
- Amazing Purple Products