Commercial Analyst Intern

The Estée Lauder Companies attracts the most outstanding people from diverse industries and nurtures their talents. Whether they work in one of our stores, on a production line, at our corporate headquarters in New York City or in one of our affiliates worldwide, our employees take pride in their contributions to our success.

Are you a motivated student looking to kickstart your career?
Do you dream of working in a supportive and dynamic environment that values your skills and fosters growth?
Look no further!

We are looking for
Commercial Analyst Intern 
to join our team in Budapest!

Primary function

Compile and calculate the suggested Rebilling Prices for the Estee Lauder Companies affiliates for various functions. Maintain and update the rebilling files. Handle affiliate notifications and questions.

Description

• Develop 360 presentation for each new launch to recap all available Marketing tools for affiliates
• Follow up on all affiliates launch tools (sampling, GWP, POSM)
• Benchmark competitive makeup brand and trends on social media Affiliates marketing coordination
• Daily support for Affiliates (visuals, marketing tools, presentations, etc) Business development
• Consolidate monthly sales performance and distribution rollout by country
• Follow up on stock level
• Support manager in preparing presentations & business meetings (with clients, business partners, distributors, affiliates)

Qualifications

The successful candidate will ideally have a marketing/business background and currently be in their final year of studies. They will demonstrate initiative and work relatively autonomously, without the need to be directed in minute detail every day.

They will be a conscientious team player, enjoy working to deadlines and effectively communicating with people at all levels. Excellent organisational and analytical skills are essential in addition to being proficient in Word, Excel and PowerPoint.

This role would appeal most to candidates who would enjoy working in a small, friendly office. Fluent in English with some exposure to the beauty, fashion or consumer goods industry will be much appreciated.

Responsibilities

• Receive and fact check transaction data from various sources
• Generate the billing files for affiliates following corresponding time schedule
• Enter charges into SAP as per instructions
• Maintain the affiliate rebilling information
• Execute ad-hoc changes to monthly rebills due to change in information
• Generate and review the Monthly recharge reports
• Notify affiliates and regional leads of monthly and quarterly billing
• With the support of senior colleagues follow up on internal or external queries to resolve discrepancies
• Provide training to affiliates on billing approvals, reporting, calculations etc.
• Support automation processes
• Work closely with the ELC Vendor Management Team (based in NYC and Budapest)

Requirements

• Advanced Microsoft Excel skills (Pivot Tables, complex formulas)
• SharePoint, Power Query, Power BI, Power Automate, VBA knowledge is an advantage
• Understanding of relational databases and statistics is a plus
• SAP knowledge is a plus
• Fluent English knowledge is a must, as you will be part of a diverse international team
• Ongoing collage/university studies preferably in the field of Accounting/Finance/Economics, IT
• Willingness to work at least 30 hours/week (flexible, home office is available) – We can give a certificate for last semester’s mandatory internship if requested
• Strong analytical and statistical skills
• Able to follow processes and to manage multiple deadlines (reprioritizing as needed)
• Strong attention to detail and service orientation

Why Choose Estée Lauder? 

• 🤝 A Welcoming and Friendly Environment: Our team is a bunch of fun-loving, multi-lingual experts who thrive on collaboration and teamwork. You'll feel right at home from day one!
• 🌐 International Exposure: Engage with teams from around the world, expanding your cultural awareness and professional network.
• 🚀 Room for Growth: We're dedicated to fostering talent and providing opportunities for professional development.
• 🕒 Flexible Working Hours: We understand the importance of balancing your studies and work commitments. That's why we offer flexible working hours, including the option to work from home.
• 💄 Employee Discounts: As a valued member of our team, you'll enjoy exclusive employee discounts on our exciting range of beauty products! Treat yourself and feel fabulous with Estée Lauder's premium offerings.

Job location

• Budapest, XI. district - Budapest One office
• We are working in a hybrid model

We can give a certificate for last semester’s mandatory internship if requested. Don't miss this opportunity to kickstart your career with Estée Lauder! Apply now and be a part of our vibrant team in Budapest.