Freight Invoice & Data Analyst (SAP, Excel, Power BI)

Job description

Freight Invoice & Data Analyst (SAP, Excel, Power BI)

About the Role

We are seeking a detail-oriented analyst to manage and approve freight invoices, maintain accurate transport rate data, and create insightful reports to support cost control.

This role requires using SAP as an investigative tool to review shipment details, resolve billing discrepancies, and collaborate with logistics partners and external freight auditing companies to ensure all charges are accurate and justified.

Key Responsibilities

• Review, validate, and approve freight invoices within SAP, ensuring accuracy against agreed rates

• Use SAP to investigate shipment history, cost components, and resolve invoice discrepancies

• Liaise with external freight auditing companies to verify and correct charges as needed

• Maintain and update transport rate structures across multiple shipping modes (air, road, ocean, rail)

• Develop and maintain dashboards using Power BI and perform advanced data analysis in Excel (pivot tables, lookups, formulas)

Skills & Experience Required

• Only candidates with extensive experience and strong skills in Excel and SAP will be considered

• Proven expertise in Excel, including pivot tables, VLOOKUP/XLOOKUP, SUMIFS, and data manipulation

• Solid experience with SAP freight invoice approval and investigative functions

• Experience working alongside freight invoice auditing companies is highly desirable

• Familiarity with Power BI or similar reporting tools

• Strong attention to detail and excellent communication skills to manage supplier relationships and internal stakeholders

Due to the high volume of applications, only candidates who meet the required criteria will be contacted. We appreciate your understanding.