Shiseido Asia Pacific Pte Ltd – Finance Analytics Intern

Shiseido is one of the top cosmetics companies in the world, with a rich portfolio of international brands in 120 countries and regions. Among others, Shiseido owns the following prominent cosmetics, skincare and fragrance brands: SHISEIDO, NARS, Clé de Peau Beauté, Drunk Elephant, ELIXIR, ANESSA, d program, NARCISO RODRIGUEZ, and ISSEY MIYAKE. Our mission -BEAUTY INNOVATIONS FOR A BETTER WORLD- is to offer solutions to social problems and achieve a sustainable society, helping people find happiness through our mainstay beauty business. We strive to create a better world through beauty innovations, as we perceive and respond to each person's profound need for betterment in an ever-changing global environment. For more than 150 years, our history and tradition have been built on distinctive innovations in each era.  

Today, we are taking on new challenges and making a concerted effort across the entire Group to pursue innovations that break the status quo and meet the diverse beauty values and needs of people around the world. 

Please only apply to this role if you are able to commit to a 6 months full-time internship from Jan - Jun 2024.

The Finance (Analytics) Intern is responsible to support and assist the FP&A team in area of reporting, planning and generating meaningful insights to support decisions in the region.

The intern will participate in the region quarterly forecast planning cycle, and get hands-on exposure in analysis of revenue and profitability drivers in the business.

KEY RESPONSIBILITIES

 Reporting and Planning

• Assist with monthly sales reporting, ensuring accurate and prompt consolidation of the region sales performance by Brand, Product line and Channel
• Manage and update the Brand Planning template for each forecast cycle by market/brand to capture key sales and cost drivers.
• Participate and support the quarterly forecast planning cycle for the region
• Assist in preparation of analysis tables and presentation slides to support brand budget/forecast review and building blocks

 Analysis and Insights

• Conduct financial profitability analysis by channel, customer and store level
• Update product margin evolution and impact
• Maintain master standardisation mapping list for SKUs and product categorisation

REQUIREMENTS

• Degree in Finance or Business with specialisation in Data Analytics.
• Has passion working with large volume of data and providing insights / storytelling
• Possess knowledge of at least one programming languages such as Python, R, or VBA for Excel
• Hands-on experience using MsExcel, PowerBI or Visualisation software.
• Good communication and written skills
• Fast learner, proactive and resourceful