The Junior Data Analyst supports the Finance department's data-driven operations within a 3PL business environment. This role is responsible for verifying logistics carrier invoices, processing and comparing carrier quotation data, and conducting gross margin analysis to support business decision-making and cost optimization initiatives. The role is expected to work AI-first, applying AI and LLM-based tools as the default approach to daily analysis, reconciliation and reporting work.
- Billing Verification & Reconciliation: Review logistics carrier invoices for data accuracy and reasonableness; identify discrepancies and follow up with carriers and internal teams for timely resolution. Maintain records to support audit trails.
- Carrier Rate Data Processing: Collect, organize, clean, and structure carrier rate quotes to enable systematic rate comparison; provide data-backed insights to support pricing negotiations and carrier selection.
- Gross Margin Analysis: Assist in preparing periodic gross margin reports; identify low-margin accounts or shipments, analyze root causes, and collaborate with business teams to surface cost reduction and efficiency improvement opportunities.
- Ad-hoc Data Support: Respond to data requests from internal business units as assigned, including supporting customer pricing tables and fulfilling cross-departmental analytical needs.
- AI-First Ways of Working: Use AI and LLM-based tools as the default approach to daily work — accelerating invoice review, rate data cleaning, gross margin analysis and report drafting. Write and refine prompts, build reusable prompt templates and lightweight AI-assisted workflows for recurring finance tasks, and always validate AI output against source data before it is used in any deliverable. Share effective methods with the wider Finance team.
Requirements
- Bachelor's degree or above in Finance, Accounting, Statistics, Supply Chain Management, or a related field.
- 2–3 years of relevant working experience; background in logistics, 3PL operations, or finance preferred.
- Proficient in English for both written documentation and verbal business communication.
- Advanced Excel proficiency including VLOOKUP / XLOOKUP, SUMIF(S), INDEX-MATCH, Pivot Tables, and data validation; ability to build structured, audit-ready workbooks.
- Demonstrated hands-on use of AI tools (e.g. ChatGPT, Claude, Copilot) in analytical, finance or operational work; able to write effective prompts, recognise when AI output is unreliable, and verify results against source data. Candidates should be prepared to describe how they currently use AI in their day-to-day work.
- Strong attention to detail and a rigorous approach to data accuracy; able to detect anomalies in large datasets.
- Comfortable working in a fast-paced, cross-functional environment with frequent changes; proactive and self-driven.
Skills Required
- Bachelor's degree or higher in Finance, Accounting, Statistics, Supply Chain Management, or a related field
- 2-3 years of relevant work experience
- Experience in logistics, 3PL operations, or finance
- Proficiency in written and verbal English business communication
- Advanced Excel skills, including VLOOKUP, XLOOKUP, SUMIFS, INDEX-MATCH, Pivot Tables, data validation, and structured audit-ready workbooks
- Hands-on experience using AI tools such as ChatGPT, Claude, or Copilot for analytical, finance, or operational work
- Ability to write effective prompts, identify unreliable AI output, and verify results against source data
- Strong attention to detail and ability to detect anomalies in large datasets
- Ability to work proactively in a fast-paced, cross-functional environment with frequent changes
What We Do
Build a healthier business with Portless. Portless fulfills e-commerce orders directly from China to your customer's front door, massively improving lead times, decreasing your shipping costs, and lowering your import tax fees. At Portless, we have shipped over 2.5 million cross-border packages with a 99.8% pick-and-pack accuracy and 98% on-time delivery rate. We pride ourselves on providing white-glove customer service and the fastest response times in the industry.
