Job Information
The Estee Lauder Companies Coordinator, Account/Planning CL NA in New York, New York
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
The Planner Coordinator is responsible for effectively assisting the Planners and Account Leads in the Management of account level activities including data entry, tracking and logging POs and pulling reports for analysis.
Order Mgmt. & Execution
Assist planners with Launch/ Basic order analysis, tracking information and reporting errors
Track Saleable PO’s & Shipments (Basic / Launch Pos) - SAP
Track Non-Saleable / Promotional POs (GWP, Samples, Collateral etc / No Cost Pos) - Passport
Execute Launch reorders
Write orders as needed
Reporting
Pull weekly and month end reports (ELC & Retailer systems)
Pull reports from Data Warehouse / Power BI and format properly in Excel for printing
Misc / Relevant administrative tasks
Support Inventory Adjustments for testers, damages and customer returns.
Manage SRP updates (filling out retailer required information)
Filling out retailer required information for new products
Provide retailers / dotcom partners launch set up information
New Door Opening
New Account Opening Form
Track Opening Order
Set up New Account Openings and closings
Analysis
Manipulate Excel files using v-lookup, and formulas to present new data
Track Promotional results / Update Side x Side calendar
Analyze retail performance by door assortment type
Ad Pro (non-digital)
Confirm programing and budget with Account Lead / Account Programmer
Input non digital ad spend
Qualifications
Qualifications
Strong math and analytical skills
Intermediate to Advanced knowledge of Microsoft Office (esp. Word, Excel, & Power Point)
Strong interpersonal skills and an adept learner of new computer programs
Proficient in data entry, organization and analysis.
Self-Starter, detail oriented, adept at problem solving and analyzing information
Excellent verbal and written communication skills.
Ability to meet and exceed established deadlines, prioritizing and multi-tasking with minimal supervision.
Pay Range:
The anticipated base salary range for this position is $0.00 to $0.00 . Exact salary depends on several factors such as experience, skills, 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.
The Estee Lauder Companies
-
- The Estee Lauder Companies Jobs