Data Analyst - Operations & Supply Chain

PlanetArt is seeking a talented, driven, and highly analytical Data Analyst to join our Operations and Supply Chain team. This role will leverage data to drive business decisions, improve customer experience, and reduce cost across a complex global fulfillment network supporting multiple brands, 3PL partners, and print-on-demand production models.

The successful candidate brings strong analytical skills, hands-on SQL experience, and an understanding of cost accounting concepts related to COGS, carrier spend, and vendor pricing in a large-scale e-commerce environment.

This is a remote, work-from-home position.
 

• →Support day-to-day invoice validation and reconciliation across multiple vendors, helping ensure invoices are reviewed accurately and on time
• →Use error reporting and exception-based reports to identify pricing discrepancies, missing mappings, and invoice issues across product, freight, and service costs
• →Investigate invoice variances, document findings clearly, and escalate higher-complexity issues when needed
• →Maintain vendor pricing documentation, mappings, and source-of-truth references in Confluence to improve consistency and reduce manual research
• →Work with Operations, Finance, and internal teams to follow up on pricing, billing, and validation questions
• →Take on repeatable validation work from senior team members as processes become more standardized
• →Learn how to interpret reporting outputs and apply them to day-to-day invoice reconciliation with guidance from the team
• →Support continuous improvement efforts by documenting recurring issues and helping refine invoice validation SOPs
   

• BA/BS degree in Finance, Accounting, Supply Chain Management, Engineering, or a related field
• 5+ years of experience using advanced Excel tools (pivot tables, lookups, Power Query, etc.)
• · Advanced SQL skills, including experience pulling and validating data from relational databases (MySQL preferred)
• Strong analytical and problem-solving skills with high attention to detail
• Experience working with Excel, including lookups, pivot tables, filtering, and reconciliation checks
• Ability to work with large transactional datasets and identify patterns, discrepancies, and exceptions
• Working knowledge of SQL, or the ability to learn quickly and use relational data for validation and reporting
• Strong written and verbal communication skills
• Ability to follow structured processes, document findings clearly, and stay organized across multiple vendors and priorities
• Comfort working with reporting outputs and using data to support issue investigation and resolution
• Ability to escalate unclear or higher-complexity issues appropriately while independently handling routine validation work
• Experience with Tableau or similar BI/reporting tools is a plus
• Familiarity with invoice reconciliation, vendor pricing, COGS, freight, or supply chain/operations data is a plus

• Own computer (Windows 10 or higher or Mac, at least 8GB RAM and at least Intel i5, Ryzen 5 or M1 processor)
• Reliable high-speed internet access
• Noise-cancelling headset (if applicable)
• Private, distraction-free environment (if applicable)

• Position requires short-term and fully remote work scheduled from 9:00 AM - 6:00 PM US Pacific Time. The expected contract period is October to December.
• Position requires regular, continuous use of computer.
• Position requires regular sitting and standing.
• Position requires regular interaction with team members through the following methods: phone, Zoom, Slack, or email.
• Position requires time and screen tracking via Hubstaff
   

· Pay Rate: Php 90,000 - Php 115,000 per month