**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 Equal Opportunity Employer It is Company's policy not to discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth and related medical conditions), gender identity or gender expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. The Company will endeavor to provide a reasonable accommodation consistent with the law to otherwise qualified employees and prospective employees with a disability and to employees and prospective employees with needs related to their religious observance or practices. Should you wish to apply for this position or any other position with the Company and you believe you require assistance to complete an application or participate in an interview, please contact USApplicantAccommodations@Estee.com.