Data Analyst

Asia Peopleworks Inc.; Makati; On-site; PHP 334,800 - 558,000; Full time

Job summary

A consulting firm based in Metro Manila is seeking an individual proficient in data analysis and report generation. As part of the team, you will utilize Power BI, Excel, and Access to manage monthly sales data, maintain budget reports, and ensure data accuracy. The ideal candidate holds a Bachelor’s degree in Business Administration or a related field and has experience in creating complex spreadsheets. This position offers an opportunity to enhance data-driven decision-making within the organization.

Qualifications

• Bachelor's degree in Business Administration or related field.
• Expertise in creating complex Excel spreadsheets.
• Ability to analyze data and generate reports.

Responsibilities

• Generate and process monthly sales pivot files using Power BI, Excel, and Access.
• Maintain budget monitoring for POSM.
• Provide weekly sales report updates.

Skills

Power BI

MS Excel

MS Access

Data Analysis

Report Generation

Education

Bachelor of Science in Business Administration or related field

Job description

Responsibilities

• To generate and process Monthly Point of Sales Pivot Files using Power BI, MS Excel and MS Access for all of the Supermarkets and Convenience Store including the E-Commerce.
• Maintain budget monitoring report for POSM.
• Provide Key Accounts and TD per door Inventory of products.
• Provide weekly bundling update.
• Provide the update on the validation of MVP Contracts
• Provide sales report

Qualifications

• Bachelor of Science in Business Administration or any related field.
• Create and maintain complex Excel spreadsheets.
• Analyze data and generate reports.
• Develop and implement Excel-based solutions to improve efficiency.
• Collaborate with team members to understand data requirements.
• Ensure data accuracy and integrity in all reports and analyses.