Supply Chain Data Analyst | McKinley

Asticom Technology Inc; Taguig; On-site; PHP 450,000 - 750,000; Full time

Job summary

Asticom Technology Inc. is seeking a detail‑driven Analytics Specialist to support supply chain operations in the Philippines. You will monitor inventory, analyze aging stock, and maintain RAC stock updates while ensuring accurate backdate handling.

You will perform sales and profitability analysis by dealer and product, build BI dashboards, and generate on‑demand reports to inform strategic decisions. A Bachelor's degree and strong Excel skills are required, with an aptitude for data

Qualifications

• Bachelor’s degree required; related field preferred (Supply Chain/ Logistics/ Business Analytics) or equivalent experience.
• Advanced Excel skills (VLOOKUP/XLOOKUP, Pivot Tables, data modeling) are essential.
• Strong data entry accuracy and ability to interpret BI dashboards and metrics.

Responsibilities

• Inventory & aging analysis and RAC stock availability updates.
• Sales & profitability analytics by dealer and product.
• Reporting and BI dashboards to support decision‑making.
• Planning and data management, including core system and Sales Matrix formats.

Skills

Data analysis

Attention to detail

Analytical thinking

Education

Bachelor's degree in Supply Chain Management, Logistics, Business Analytics, or related field

Tools

Excel

Pivot Tables

Data Modeling

Job description

Key Roles and Responsibilities:

• Inventory & Aging Analysis: Track stock levels, inventory movement, aging stock, and maintain RAC stock availability updates while managing backdates.

• Sales & Profitability Analytics: Perform sell-out analysis per dealer and product, calculate AC profit per product, and compile sales & profit summaries to evaluate overall performance.

• Reporting & BI Dashboards: Generate custom, on-demand operational ad-hoc reports and analyze Business Intelligence (BI) metrics to support strategic decision‑making.

• Planning & Data Management: Update core system/allocation tracking files (AP2 All-in File), maintain B2C demand planning sheets, and format Sales Matrix summaries.

Qualifications & Skills:

• Education: Bachelor’s degree required; degree in Supply Chain Management, Logistics, Business Administration, Data Analytics, or a related commercial field preferred (equivalent operational experience accepted).

• Technical Skills: Advanced mastery of Microsoft Office Suite, specifically Microsoft Excel (VLOOKUP/XLOOKUP, Pivot Tables, formulas, data modeling).

• Core Competencies: High proficiency in data entry with strict attention to detail and accuracy. Strong analytical mind with the ability to interpret BI dashboards and operational metrics.