[Hiring] Data Analyst @PlanetArt

Role Description

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.

Key Responsibilities

• 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.

Qualifications

• 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.

Working Conditions

• 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.

Work From Home Requirements

• 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).

Pay Range

• Pay Rate: Php 90,000 - Php 115,000 per month.