Data Analyst - Operations & Supply Chain

  
Data Analyst - Operations & Supply Chain

Company and Vision
PlanetArt’s vision is to be the leading seller of personalized and make-on-demand products worldwide. We provide consumers with unmatched tools and content and an unparalleled end-to-end customer experience that result in high-quality, meaningful finished products and memorable celebrations of live events.

The company’s brands include the popular FreePrints and FreePrints Photobooks apps and the industry leading SimplytoImpress card and stationery site, as well as Personal Creations, CafePress and ISeeMe! Visit www.planetart.com to learn more about our brands.

We have more than 500 team members across multiple offices, primarily in Calabasas CA, San Diego CA, Woodridge IL, Minneapolis, MN and Pleasanton, CA. We also have team members in two company-owned offices in China, as well as in Europe.
 

Job Overview

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.
 

What You’ll Do
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
   

What You Should Have
Skills, Qualifications, and Requirements

• 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

What You Can Expect
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