Business Analyst

Dormont Manufacturing Co; Philippines; On-site; PHP 900,000 - 1,300,000; Full time

Job summary

Dormont Manufacturing Co. is seeking a Business Analyst to formulate a comprehensive commercial calendar and optimize wholesales performance across the Philippines through Sell in / Sell out analysis and KPI-driven insights. You will collaborate with the wholesales head of sales and management to drive data-informed decisions.

You will develop dashboards, standardize reporting, and provide ad hoc analyses. Strong Excel, Power BI, and SAP experience, plus ability to present complex data to senior

Qualifications

• Bachelor's degree in Business Administration or Finance.
• 5+ years of relevant experience, incl. 2+ years in management.
• Retail finance and analytics experience in multinational context.

Responsibilities

• Collect, structure and report business data with dashboards and KPI analyses.
• Monitor weekly/monthly performance and provide commentary and corrective actions.
• Evaluate store openings and market opportunities to boost sales.
• Standardize country reporting and train teams on Power BI.
• Participate in budgeting, forecasts and mid-term business planning.

Skills

Data analysis

Power BI

Excel

Dashboarding

Education

Bachelor's degree in Business Administration

Master's degree (preferred)

Tools

Power BI

Hyperion (HFM)

SAP

PowerPoint

Job description

YOUR MISSION

The Business Analyst is responsible for formulating a comprehensive commercial calendar detailing distribution, display, promotion and activation priorities and commercial excellence. They will also improve the Wholesales customers business and Operational Performance across the Philippines (PH) through Sell in / Sell out and statistical analysis, providing decision-making proposals and recommendations to the wholesales head of sales and the wider PH Wholesales management team. The Analyst actively engage in the day-to-day controlling and management of the Business, being the natural go-to person for any data- and number-related information or queries.

Task 1:

Collect, Structure, Analyze and Report (Wholesales Customers)- Establish Systems and Processes to collect, structure and analyses reliable Business, Operational and Merchandising Data and KPI’s to enable Wholesales Senior Management to proactively manage the Wholesales business. Enhance and/or develop a suite of Dash Boards and Reports to provide visual presentations and comparisons across countries, channels and time periods.

Data Accuracy - In cooperation with Global IT, Country- and Regional IT, ensure data from POS systems are reconcilable between various system platforms (e.g. Sell in/ out data system, Power BI, data warehouse inbound etc) and provide monthly reconciliation of store count, budget performance etc.

Ad Hoc Reporting - Prepare ad hoc business analysis and reports for management purposes as and when required.

Task 2:

Business Monitoring and Management - Analyze weekly/monthly/quarterly/seasonal data and provide commentary on individual territory’ and stores’ monthly performance, highlighting problem areas and recommending corrective actions. Through Business and Statistical analysis, identify Areas of Improvement as well as Key Success Factors within the in-country business. Participate in Monthly Business Reviews with individual countries, leading the business grow YOY.

Observation List Management – Closely monitor stores with extreme performance swings and/or loss-making Business and work cross-functionally to ensure that corrective action plans are in place. Provide a monthly Observation List to Senior Management

Task 3:

Store Investment Evaluation/ Market information – Review incoming proposals on business unit focus, Propose and provide recommendation of business opportunity. Execute key area, malls, Stores, and evaluation of Store Openings to evaluate accuracy and implement measures to increase accuracy and PUMA business at customers’ level.

Task 4:

Standardize Country Reporting – Standardize the reporting used for managing the Retail Business within countries and across the Region, providing first-class templates and processes to identify focus areas and pain points

Training and Support – Power BI – Train and teach sales teams to analyses their business in detail. Provide clear and consistent definitions of KPI’s and support countries in the development and implementation of new practices/ Business tools

Task 5:

Business and Budget Planning – Actively participate in the Planning and Budgeting of the Business through evaluation of in-year Forecasts (FC1, FC2, LE) and Budget proposals and Mid-term Business Plans. Critically evaluate assumptions and provide feedback and recommendations

YOUR TALENT

Education: Bachelor’s Degree in Business Administration / Finance and/or related courses, preferably with Master’s Degree in the related field also.

Professional Skills:

• Minimum of 5 years of relevant experience, with at least 2 years at managerial level in Business and analytical role in multinational corporation
• Previous retail finance and analysis experience is a must - strong understanding of relationship between retailers and operations is required

Functional Competencies:

• A team player with strong interpersonal and presentation skills
• Detail-minded with excellent communication skills with all levels - ability to communicate in English (written and spoken) at high level is required
• Self-motivated and performance oriented, and able to work independently under time pressure in a fast paced, dynamic environment

Functional Skills:

• Strong analytical skills with solid retail business acumen - ability to link business KPIs to Operational KPIs

Additional Skills:

• Extensive experience in MS Excel, Hyperion (HFM), SAP and MS Powerpoint
• Power BI is an advantage
• intermediate knowledge with statistical methods and tools such as: SPSS or similar