Job Description: Details
QVC's Commerce Planning Team is recruiting for a Senior Business Analyst to support our Commerce Reporting efforts. This Senior Business Analyst will sit at our QVC, West Chester location and drive forecasting data to collect inputs from various Commerce teams in preparation for the SMI and annual sales planning, provide sales forecasting and narrative for category leaders, aid in the development and provide input to the SMI and annual planning process for easy pay, price code usage and free shipping and handling usage.
Who We Are
The Commerce Planning team is a well rounded organization that supports merchandising analytics and for the first time ever we are looking at bringing in internal analytics to grow out our reporting function. This is a strong senior development opportunity that will interface with the Planning and Programming Leadership team.
Commerce Analytics for Planning and Programming
Provides Ad-Hoc Analysis and What if Scenarios for category leadership in Planning and Programming. Use SQL to access the needed data and provide analysis when required.
Provide analysis for category and individual item promotions. Specifically reviewing the main promotional levers of easy pay, free shipping and handling and promotional pricing within each category
Recommend actions from a total company perspective, neutral to category bias
Commerce Multi-Platform Forecasting:
Aggregates sales inputs from multiple commerce teams to prepare total company sales forecasts and plans
Provides narrative to category leaders based on analysis
Aid in the development of tools for forecasting commerce financial metrics like margin rate, revenue, promotional metrics
Aids in the regular review of pricing formulas ensuring category initial margin objectives are met, associated product cost are accounted for in the margin, and formula maintenance and consolidation occurs as needed
Ensure that operational reporting that tracks pricing compliance is maintained.
Review and report on price handle usage and provide recommendations at the category level
Promotional Calendar Development
Evaluate and interpret results of promotions and recommend actions
Recommend promotional activity (QVC Promotion Calendar)
Forecast cost/benefit of upcoming promotions
What You Bring
Bachelor's degree in business analytics, economics, administration, merchandising, marketing or ecommerce, or equivalent business experience.
5 years in business analytics, merchandise planning or buying in combination with the required critical skills and knowledge
Preferred Experience:5 years merchandise financial planning or business analytics for a retailer or consumer products company
Tableau and SQL
About Qurate Retail Group
Qurate Retail Group comprises seven leading retail brands - QVC, HSN, zulily, Ballard Designs, Frontgate, Garnet Hill, and Grandin Road - all dedicated to providing a 'third way to shop,' beyond transactional ecommerce or traditional brick-and-mortar stores. Globally, Qurate Retail Group is #1 in video commerce, reaching approximately 370 million homes worldwide via 16 television networks and multiple ecommerce sites, social pages, mobile apps, print catalogs, and in-store destinations. Qurate Retail Group is #3 in ecommerce in North America and #3 in mobile commerce in the U.S. (according to Internet Retailer). Qurate Retail Group combines the best of retail, media and social to curate products, experiences, conversations and communities for millions of highly discerning shoppers -- bringing joy, inspiration and humanity to shopping. Qurate Retail Group also curates large audiences, across multiple platforms, for thousands of brand vendors. Headquartered in West Chester, Pa., Qurate Retail Group has 27,000 team members in the U.S., the U.K., Germany, Japan, Italy, France, Poland and China. For more information, visit www.qurateretailgroup.com. Qurate Retail, Inc. (NASDAQ: QRTEA, QRTEB) includes the Qurate Retail Group portfolio of brands as well as other minority investments.
As an equal opportunity employer, Qurate Retail Group is committed to a diverse workforce and is also committed to a barrier-free employment process. In order to ensure reasonable accommodations for individuals pursuant to applicable law, individuals that require accommodation in the job application process for a posted position may contact us at CareersUS@QVC.com for assistance.
Click Apply and log in with your existing account or create an account. This will allow you to check the status of your application at any time and receive the most up to date communications from our Talent Acquisition team.