Description
This position requires developed analytic skills, a strong business acumen, and a focus on detail. There will be heavy spreadsheet and data retrieval analytics using various systems. Strong database and project management skills & advanced excel skills are required.
Key Roles And Responsibilities
Sales Planning/Annual Budget
⁃ Support the 3⁃year LRP and Annual budget process through preparing the following
⁃ Prepare and issue templates to the Field to develop annual retail sales targets by Channel & door.
⁃ Prepares the template for Gross to Net sales
⁃ Prepares the template for Retail & Net Sales
⁃ Calculate monthly field retail sales plans based on annual retail sales targets Monthly Estimate
⁃ Prepare & issues monthly retail sales estimate file on department store calendar
⁃ Prepare & calculate Monthly Estimate of Retails Sales by account / channel.
⁃ Responsible to track new doors & closures. Completes door count file
⁃ Work with Account Leads for monthly updates to Retail Sales/ LE⁃ Populate total NA Monthly/ weekly breakout by census type
Reporting
⁃ Compile, review, and input weekly audited sales
⁃ Compile and report retail audited sales results v PL, LE and LY incl. weekly and monthly
⁃ Maintain DTC audited weekly/daily sales files, develop estimates for monthly dailies
Data Maintenance
⁃ Maintain Field Door Alignment files
⁃ Compile high volumes of material data sets in Excel. Map, migrate, and validate data sets in system. Accountable for the integrity of all sales data in database
⁃ Maintain internal database of door data including EL code, opening date, field hierarchy, monthly plan numbers
⁃ Maintain daily history of promotions, weather activity, renovations
Ad Hoc
⁃ Develop standardized tools, methodologies and business processes aimed at improving decision making and information access
⁃ Provide analysis & strategic insight requested by Sales Operations & Account Management teams
Core Competencies
⁃ Planning/Organizing and Dependability ⁃ Is highly organized, prioritizes and plans work activities, uses time efficiently.
⁃ Strong financial and analytical acumen, ability to develop insights that continuously improve planning
⁃ Highly organized and structured
⁃ Experience with data manipulation and Excel formulas (Date functions, V⁃lookup, Pivot Tables, etc).
⁃ Communication with the Field
Qualifications
⁃ Strong Analytical and Business acumen
⁃ Ability to analyze and manipulate large amount of data in excel
⁃ Self⁃starter and ability to work independently
⁃ Self⁃starter, adept at problem solving
⁃ Detail⁃oriented with strong organizational skills
⁃ Flexible mindset, with the ability to shift focus, multi⁃task, and prioritize requirements
