Business Analyst

ESTEE LAUDER TRAVEL RETAILING, INC.; Singapore; On-site; SGD 72,000 - 105,000; Full time

Job summary

ESTEE LAUDER TRAVEL RETAILING, INC. seeks an FP&A Analyst to oversee and consolidate corporate analyses, dashboards, and reports across brand, function, and geographic levels. You will support management reporting and decision-making.

In this newly created role, you will drive value-added analyses, coordinate with data centers, and assist with budget and LRP processes while developing into a strategic business partner for brand clusters.

Qualifications

• Bachelor’s degree or equivalent with 3+ years of relevant experience.
• Strong analytical and problem-solving skills with ability to translate needs into data-driven analyses.
• Excellent written and verbal communication and stakeholder management.
• Strategic thinker able to operate in a fast-paced FMCG/travel retail environment.

Responsibilities

• Ensure monthly and quarterly management reporting is updated and stored on Finance Sharepoint.
• Create value-added analyses for brand, commercial and function teams (e.g., dashboards, market reports).
• Coordinate with internal/external centers of excellence for data and reports; share new reports across regions and NY Head Office.
• Develop analyses for corporate projects and initiatives, including presentations when needed.
• Support the annual budget and LRP processes for cross-brand opportunities.
• Administer Finance Sharepoint access and manage reporting cadence.

Skills

Analytical skills

Problem solving

Communication skills

Strategic thinking

Multitasking

Continuous improvement

Data analysis

Systems savvy

SAP

CPM

Power BI

Power Query

Education

Bachelor’s Degree

Tools

Power BI

Power Query

SAP

CPM

Job description

PALOBJECTIVES:

This is a newly created role within the FP&A team reporting into one of the Business Managers. The primary objective of this critical role is to oversee and consolidate corporate analyses, dashboards, and reports which can be leveraged by key business stakeholders(e.g. brand teams, commercial market teams, etc…) to drive the business and support business decisions at the brand, function, and geographic levels.

The responsibilities of the role include, but are not limited to, the following:

1)Ensure all recurring monthly and quarterly management reporting is updated and saved on the Finance Sharepoint site. Initially there will be opportunities to enhance and refine existing reporting. Over time the role will evolve from report creation to report analysis as the understanding of the business expands. (15% of time)

2)Create new value-added business analyses to be leveraged by the brand, commercial and function teams. Examples of these analyses include: beauty advisor productivity dashboards, inventory reporting, market dashboards, door P&Ls, brand market penetration dashboards, etc.. These represent newly created reports which will become part of the FP&A’s published management reporting. (60% of time)

3)In creating new value-added business reports, the role will leverage internal and external centers of excellence for data, some reports and dashboards, and other capabilities. Therole will support the coordination efforts with these centers and be responsible for sharing new reports with other TR Regions and the NY Head Office.

4)Create analyses to support corporate projects and other new initiatives. These are one-off projects which will not likely becomes part of our regular business reviews. Attimes, the project scope could include the compilation of presentations. (15%of time)

5)Support the annual budget and LRP processes on corporate aspects that can be leveraged across the branded Business Managers (e.g. assist with the generation of new supporting LRP templates to manage new door opportunities, etc..) (10% of time)

6)Administrator role for the Finance Sharepoint- grant and remove access to the site, organize the monthly and quarterly reporting, send updates when information becomes available, etc… (< 5% of time)

This role will be a diverse, dynamic FP&A role with evolving analytical responsibilities as the knowledge and understanding of the company expands. The role is perfectly suited for someone with aspirations to eventually become a strategic business partner to one of our brand clusters.

Successful candidate will exhibit a strong business acumen, strategic thinking, and analytic expertise. Should have the courage to initiate change when appropriate and has the interest and ability to work across the organization with different people. Strong communication skills including the ability to convey ideas, conclusions and recommendations to senior management.

REQUIREMENTS

• Bachelor’s Degree or equivalent with 3 or more years of similar or relevant experience.
• Analytical/ problem solving skills. Able to take business need/request/idea and translate it into data driven analyses and draw conclusions or form actionable recommendations.
• Strong communication skills both written and verbal. Able to work with alllevels of the organization and establish a strong rapport.
• Strategic, thinks out of the box and comfortable in a fast-paced environment.
• Capableof managing multiple concurrent tasks/projects and meeting deadlines.
• Drivecontinuous improvement in reporting and analysis
• Able to manage large amount of data.
• Must be systems savvy and detail oriented? Experience with SAP, CPM, Power BI,Power Query is a plus.
• FMCG,Luxury Retail industry, or Travel retail experience a plus.