Logistics Data Analyst

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 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 looking for a talented, driven, and highly analytical, Logistics Data Analyst to join our Operations and Supply Chain team. The candidate will have strong analytical skills and using data to drive business decisions and reduce cost. The candidate will have knowledge and experience with major Carrier ship options and packaging guidelines. The candidate should have experience with international freight(UK/EU) as well as domestic shipping for international territories.
PLEASE NOTE:
Candidates much be local to or willing to relocate to the Calabasas area as we operate on a hybrid work model (3 days onsite, 2 remote)
What You’ll DoKey Responsibilities
Identify, develop, manage, and execute analyses to uncover areas of opportunity and present written business recommendations.
Develop tool to monitor worldwide ship method accuracy from all ship facilities.
Develop automation for freight cost reporting for business partners.
Design exception based reporting highlighting and analyzing outliers.
Weekly discussions reporting on pricing gaps, spot quotes, and areas of improvement.
Discover the most cost-effective shipping modes.
Collaborate with IT professionals to implement effective processes and systems.
Requirements
Skills, Qualifications, and Requirements
Proven expertise managing, evaluating, analyzing quickly, and creating meaningful business reporting and analytics
Proven ability to develop strategic relationships with your business partners – you influence the decisions. You can root cause issues quickly and uncover core issues using data, then assist, consult with, and teach the business how decisions affect costs in their sites and create new mechanisms as they are needed
BA/BS degree in Finance, Accounting, Supply Chain Management, Engineering or related
5+ years of experience with Excel advanced tools (pivots, lookups, etc.)
Advanced SQL knowledge to pull data into BI tools such as Tableau, or Power Queries within Excel
Knowledge of freight carriers and audit processes
Experience in data mining, analysis, and reporting
Working knowledge of Microsoft Office, relational databases, and ERP systems (e.G., JDE)
Familiarity with supply chain processes (e.G., Inventory planning, warehouse management)
Strong analytical mind with problem-solving aptitude
Strong attention to detail
Great interpersonal skills
Exceptional verbal and written communication skills
Covid-19 vaccine is required - reasonable accommodations will be considered
What You Can ExpectWorking Conditions
Work is performed in an office environment with low to moderate noise levels.
Occasional lifting of up to 20 pounds.
Position requires regular, continuous use of computer.
Position requires regular sitting and standing.
Position requires regular interaction with team members through the following methods:
in-person, phone, WebEx, Slack, or email.
May require occasional travel.
This is a hybrid position;
interns are expected tobe in the office three days per week (Monday, Tuesday, and Thursday) with the option of working remotely two days (Wednesday and Friday).
Benefits
The compensation range for this position is $80,000 - $100,000 annual salary.
PlanetArt offers a comprehensive benefits package including:
Health, Dental and Vision Insurance
Life Insurance
401(k) with matching
Excellent Work/Life Balance – Paid Time Off, Sick Days, Paid Holidays, and Floating Holidays
Employee Product Discounts