Sr. Pricing and Promotions Specialist II
Description
At Shutterfly, we make life’s experiences unforgettable. We believe there is extraordinary power in the self-expression. That’s why our family of brands helps customers create products and capture moments that reflect who they uniquely are.
- Serve as P&P technical expert (SQL Black Belt) and process owner for all BI reporting and analysis. Experience owning and maintaining dashboards in a productional BI environment, e.g. Tableau or Power BI.
- Answer key P&P questions: define analytics approach, retrieve, and manipulate data needed to perform analysis, and deliver actionable insights to the P&P team.
- Build and maintain domain expertise in relevant data sets and be able to think strategically about what data is critical to capture.
- Collaborate with the P&P team in developing A/B test plans for new promo constructs, features and workflows.
- Create, maintain and publish KPI Dashboards for the P&P team; automating and enabling team members to self-serve whenever possible.
- Establish collaborative working relationship with cross-functional business partners across Category Management, Product, Engineering, Marketing, Ecommerce, Merch Planning; coordinate with other Analysts; work with data engineers to define data requirements, participate and share findings with the broader Analyst community at Shutterfly.
Qualifications:
- B.S. or M.S. degree in quantitative field and 6-8+ years of progressive experience in an analytical role in ecommerce, pricing/promotions, finance, strategy consulting, internet marketing, decision support, or related field
- SQL Black Belt (aggregate functions, joins etc.); Power BI knowledge is core competency. Experience with Adobe Analytics or another web analytics platform; experience working with large datasets
- Thorough understanding of Internet/E-commerce (Mobile App good addition) data collection and metrics. Should be able to relate to standard financial/pricing metrics like ASP, AOS as well as marketing and ecommerce: conversion rates, response rates, lift, ROAS, and ROI.
- Excellent English verbal and written communication skills; comfortable presenting to all levels of a global organization and to different stakeholders, in person and via tele conference. Able to influence senior leadership with data backed recommendations.
- Detail oriented with ability to independently validate / triangulate data and analysis.
- Proactive with an interest in improving processes and creating efficiencies.
- Curious about what drives business trends; demonstrated capacity to learn, intellectual honesty and independent thinking. Must be comfortable with unstructured, fast-moving and constantly evolving high growth environment. Passion for excellence and continuous improvement
Supporting a diverse and inclusive workforce is important to Shutterfly not only because it directly reflects our value of Embracing our Differences, but also because it’s the right thing to do for our business and for our people. Learn more about our commitment to Diversity, Equity and Inclusion at Shutterfly DE&I.
This position will accept applications on an ongoing basis until filled.