Key Purpose of the Job :
Act as key point of contact amongst Global Supply Office hubs, Regional Brand Offices, and Corporate Finance teams to collect and consolidate report data for executive level review.
Create standard reporting formats from data consolidation to be partitioned out to internal stakeholders for further analysis.
Assist with generation of presentation material (report summaries, PowerPoint slides, graphs, charts) for various meeting deliverable.
Support finance team with update and maintenance of files, templates, data mapping definitions and inputs.
Work on ad-hoc projects requiring data mining, integration, and manipulation of data across various sources to leverage information for reporting and decision-making needs.
Key Areas of Responsibility :
Prepare regular management & financial reports such as FOB & Opex report through various data sources (e.g. Anaplan & Tableau) for financial review.
Design and implement standardized report formats and input templates for respective analysis and input by both financial and non-
Consolidate data points and prepare relevant slices of data to divisional partners for analysis and commentary.
Generate ad hoc reports or summaries from several sources of data in various formats utilizing Excel functions, including Lookups, Pivot Tables, Charts, etc.
Assist in driving change e.g. construct reports based on changed specifications of stakeholders, being responsive to stakeholder needs.
Provide decision support to different sourcing hubs / sourcing divisions & shared services functions through financial analysis / scenario planning.
Develop strong relationship with key stakeholders and provide analytical support in driving informed business decision.
Coordinate with sourcing hubs and operational teams for annual budget, forecast, and cost allocation to drive and support a robust financial cadence
Initiates data requests and establishes a working relationship with the business partners, ensuring timely receipt of complete and accurate submissions.
Major Challenge :
A strong team player who engage with colleagues of various functions, time zones, and levels to meet time sensitive deadlines.
Working with high volumes of data manually to produce relevant and easy to maintain data sets / reports.
Understand full process flow of consolidation and able to identify bottlenecks of the process to shorten the lead time.
Ability to work under pressure and independently to meet tight deadlines.
Required Competencies :
Excellent communication skills required to work with colleagues across functions and levels.
Detail oriented with strong numeric sense and technical data manipulation skills.
Strong organizational and coordination skills.
Strong in communicating with people from different background and at all levels, both internally and externally.
Results oriented, ability to manage timelines.
Organized and analytical mind in performing financial analysis.
Works well under time-sensitive pressure.
A self-starter who can work independently and in teams.
Required Special Skills :
Strong level knowledge in Excel Pivot Table data mining.
Microsoft Access skills would be an advantage.