Apply on Employer Site

CosmoProf Beauty · 4 months ago

SR PROMOTION ANALYST-Merchandising

Denton, TX, United States

Full-time

Hybrid

Senior Level

5+ years exp

CosmoProf Beauty is a company that values diversity and innovation in the beauty industry. They are seeking a Sr. Promotion Analyst who will provide strategic promotional recommendations through analysis and execution of promotional effectiveness, collaborating with various teams including Merchandising and Marketing.

Responsibilities

Work with Merchants and IT to create and maintain a repository of historical promotions financial performance, trends associated tactics

Develop and manage processes to identify and measure actual promo volume, discount depth, promo types, support vehicles, basket, # trips vendor funding

Construct a baseline calculation process and update as promo periods are cycled through

Capture marketing/shopping guide features, ads and placements for promo periods

Help manage promo planning deliverables across teams and accuracy of information submitted

Lead category and vendor performance reviews to make recommendations on which types of promotions and tactics to be tested and built into plans

Create promotional scenario modeling to forecasting to estimate the performance ROI of promotions being planned

Evaluate effectiveness of promo strategy rules, identify opportunities and make recommendations for future promo planning

Work with merchandising and store ops to develop promo verification to measure actual results of a current promotional period against forecast and goals

Build drillable reporting on promotions to provide insights and recommendations on actions that should be taken

Promo projects as identified by supervisor

Qualification

Advanced ExcelSQLBI & Visualization ToolsAlteryxCloud platformsPromotional planningCommunication skillsOrganizational skillsSelf-starterNegotiating skills

Required

Bachelors Degree required, MBA preferred

Area of Study: Marketing, Business, Finance, Statistics

Advanced Excel

Skilled in BI & Visualization Tools ( Power BI/ Tableau)

Strong proficiency in SQL and experience working with relational databases

Familiarity with Alteryx tool

Exposure to Cloud platforms (Microsoft Azure Preferred)

Prior experience with Databricks is a plus

5-7 years of retail analytical experience preferred

Merchandising or Marketing analysis experience a preferred with previous exposure to trade funds and promotional planning

Strong skills in using BI/analytical tools along with willingness to learning new solutions

Previous work with promotional effectiveness software solutions

Clear, concise communication style with the ability to develop strong relationships

Ability to organize and manage multiple priorities and quickly react to changing business needs while meeting firm deadlines

Needs to be a self-starter to be able to follow processes and use programs to meet business objectives

Ability to organize and manage a variety of activities while addressing multiple priorities and quickly react to changing business needs while meeting firm deadlines

Strong negotiating skills supported by excellent oral and written communication skills

Needs to be a self-starter to be able to develop policies and programs to meet new business objectives