**The Estée Lauder Companies Inc.** is one of the world’s leading manufacturers, marketers, and sellers of quality skin care, makeup, fragrance, and hair care products, and is a steward of luxury and prestige brands globally. The company’s products are sold in approximately 150 countries and territories under brand names including: Estée Lauder, Aramis, Clinique, Lab Series, Origins, M·A·C, La Mer, Bobbi Brown Cosmetics, Aveda, Jo Malone London, Bumble and bumble, Darphin Paris, TOM FORD, Smashbox, AERIN Beauty, Le Labo, Editions de Parfums Frédéric Malle, GLAMGLOW, KILIAN PARIS, Too Faced, Dr.Jart+, the DECIEM family of brands, including The Ordinary and NIOD, and BALMAIN Beauty. **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 **Pay Range:** The anticipated hourly range for this position is **$26.25 to $38.95.** Exact hourly rate depends on several factors such as experience, skills, education, and budget. Hourly range may vary based on geographic location. In addition to hourly rate, this position may be eligible for an annual discretionary bonus. education, and budget. Salary range may vary based on geographic location. In addition to base salary, this position is eligible for participation in a highly competitive bonus program with the possibility for overachievement based on performance and company results. In addition, The Estée Lauder Companies offers a variety of benefits to eligible employees, including health insurance coverage, wellness and family support programs, life and disability insurance, retirement savings plans, paid leave programs, education-related programs, paid holidays and vacation time, and many others. Many of these benefits are subsidized or fully paid for by the company **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 **Michigan Applicants:** Persons with disabilities needing accommodations for employment must notify the company in writing of the need for an accommodation within 182 days after the date the person with a disability knew or reasonably should have known that an accommodation was needed. **Philadelphia Applicants:** Philadelphia's Fair Chance Hiring Law (https://www.phila.gov/media/20240326142036/V6-Fireball-Handout-fairchance-E-S.pdf) **Rhode Island Applicants:** The company is subject to chapters 29-38 of title 28 of the general laws of Rhode Island and is therefore covered by the state's workers' compensation law. 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.