Sr. Pricing and Promotions BI Analyst II

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.

The Senior Pricing Business Intelligence Analyst will be highly technical and will own the development and delivery of standard (and ad hoc) reporting on overall financial performance and channel/audience insights. This individual will have a keen ability in providing price discovery and insights. and is an SQL expert who will be responsible for data retrieval, analysis, identifying drivers, declaring findings and constructing in clean, easy to understand documents. Experience owning and maintaining dashboards in a productional BI environment, e.g. Tableau or Power BI. The individual works with BI developers and Pricing & Promotions (P&P) leadership to construct and adapt dashboards. This role requires an individual with strong analytical skills, E-commerce, retail or similar experience, excellent communications skills, and ability to synthesize and simplify complex problems. This is a great opportunity to play a key leadership role in helping Pricing & Promotions develop into a world-class data and insights-driven team.

Responsibilities:

• Serve as P&P technical expert 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. Provide analytical perspective on performance and develop recommendations on future actions with P&P leadership.
• Create, maintain and publish KPI Dashboards for the P&P team; automating and enabling team members to self-serve everywhere 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
• Expert SQL skills (aggregate functions, joins, subqueries, set operations, etc.); Power BI knowledge is core competency. Experience with Adobe Analytics or another web analytics platform; experience working with large datasets.  R/Python scripting is a plus.
• 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.