Planner Coordinator, Clinique North America

The Planner Coordinator is responsible for effectively assisting the Department Store Planners in the Management of account level activities including data entry, tracking and logging POs and pulling reports for analysis. Order Mgmt & Execution 35% Assist planners with Launch/ Basic order analysis , tracking information and reporting errors Track Basic POs & Shipments Track Launch POs Track Promotional POs Execute Launch reorders Write orders as needed Send order confirmation to accounts Conducts some relevant administrative tasks (e.g., filling out retailer required information for new products) Reporting 20% Weekly shipment confirmation to AE and counter managers (Launch/Basic/Collateral) Send weekly communication to the field (Sell Thru by door, Out of Stock, PO Tracking, Upcoming Promotions, Cannibalization) Pull month end reports Pull reports from Data Warehouse and format properly in Excel for printing Inventory 20% Review store inventory adjustment paperwork Support Inventory Adjustments for testers, damages and customer returns. Support Return to Vendor execution New Door Opening 5% New Account Opening Form Track Opening Order Set up New Account Openings and closings Analysis 20% Manipulate Excel files using v-lookup, and formulas to present new data Provide retailers launch set up information 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. The anticipated hourly range for this position is $26.00 to $39.00. 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. 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. Job: Sales Primary Location: US-NY-New York Job Type: Standard Schedule: Full-time Shift: 1st (Day) Shift Job Number: 231236 We are an equal opportunity employer. Minorities, women, veterans, and individuals with disabilities are encouraged to apply. 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 [email protected].