Supply Chain Data & Reporting Analyst

AllSTEM Connections; Milwaukee (WI); Hybrid; USD 52,000 - 65,000; Full time

Benefits offered by this job

Health benefits? etc.

Job summary

AllSTEM Connections seeks an entry-level (with some experience) supply chain data analyst to support transportation, planning and customer supply operations. The role handles data inputs, validates system accuracy, analyzes performance, and maintains recurring reports and dashboards across SAP, 3PL portals, and analytics tools to improve service levels and efficiency.

The position involves hybrid work with onsite Monday–Thursday and remote Fridays, collaborating with Customer Service and Supply

Qualifications

• 2–5 years in supply chain, logistics, or related field.
• Bachelor's degree or equivalent practical experience.
• Strong analytical skills with large datasets.
• Proficiency in Microsoft Excel (lookups, pivot tables, nested formulas).
• Familiarity with Microsoft Access or other data tools is a plus.
• Ability to learn SAP ECC, SAP TM, SAP APO, SNC, and BusinessObjects.

Responsibilities

• Monitor data quality in shipments, inventory and supply planning; escalate anomalies with analysis.
• Analyze large datasets to identify trends and improvement opportunities.
• Support financial reporting by tracking transport and warehousing costs.
• Create recurring and ad hoc reports translating operational data into insights.
• Support domestic transport including LTL/FTL and cross-border shipments; validate data and tendering.
• Collaborate with Customer Service and Supply Planning to resolve issues and prevent failures.
• Work with 3PLs, carriers, and warehouses to investigate discrepancies and drive improvements.
• Document workflows, data logic, and business definitions for consistency.
• Validate and upload key US/Canada supply chain inputs into SAP/APO weekly.
• Execute weekly APO transactions used to generate supply plans.
• Investigate SAP APO, ECC, SNC issues with IT teams.

Skills

Data analysis

Excel proficiency

SQL/BI data handling

Communication

Cross-functional collaboration

Problem-solving

Education

Bachelor's degree in Supply Chain Management or related field

Tools

SAP ECC

SAP APO

SAP TM

SNC

BusinessObjects

Power BI/Tableau

Microsoft Access

Job description

This entry-level opportunity supports transportation, supply planning, and customer supply operations by managing data inputs, validating system accuracy, analyzing performance, and maintaining recurring reports and dashboards. The role works across SAP systems, third-party logistics (3PL) portals, and analytical tools to support accurate supply chain execution, improve service levels, reduce costs, and enhance operational efficiency.

Work Schedule: Hybrid — Monday through Thursday onsite; Friday remote.

Key Responsibilities

• Monitor shipment, inventory, and supply planning data to ensure accuracy and **escalate anomalies** with supporting analysis.
• Analyze large datasets using Excel, Access, BusinessObjects, and SAP data sources to identify trends and improvement opportunities.
• Support financial reporting by tracking transportation and warehousing expenses against established targets.
• Produce recurring and ad hoc reports that translate operational data into actionable insights.
• Support domestic transportation, including less-than-truckload (LTL) and full-truckload (FTL) shipments, as well as cross-border transportation, by validating data, monitoring shipment status, and ensuring timely tendering.
• Collaborate with Customer Service and Supply Planning teams to resolve route-to-market issues and prevent service failures.
• Work with 3PLs, carriers, and warehousing partners to investigate discrepancies and support continuous improvement.
• Document workflows, business definitions, and data logic to strengthen operational knowledge and consistency.
• Validate, manage, and upload critical US and Canadian supply chain inputs into SAP/APO on a weekly basis.
• Execute and validate weekly APO transactions used to generate supply plans.
• Investigate and resolve issues involving SAP APO, ECC, and SNC in collaboration with IT teams.

Minimum Qualifications

• Two to five years of relevant experience in supply chain, logistics, transportation, business analysis, reporting, or a related field.
• Bachelor's degree in Supply Chain Management, Business, Analytics, Logistics, or a related discipline, or equivalent practical experience.
• Strong analytical skills and the ability to work with large datasets.
• Proficiency in Microsoft Excel, including lookups, pivot tables, and nested formulas.
• Familiarity with Microsoft Access or other data analysis tools is an advantage.
• Ability to learn and navigate complex enterprise systems, including SAP ECC, SAP TM, SAP APO, SNC, and BusinessObjects.
• Strong written and verbal communication skills, with the ability to explain technical information clearly.
• Demonstrated teamwork, accountability, curiosity, and willingness to learn.
• Ability to prioritize recurring responsibilities, meet deadlines, and respond effectively to ad hoc analytical requests.

Preferred Qualifications

• Experience with SAP ECC, APO, TM, or SNC through professional work, internships, or coursework.
• Exposure to transportation or supply chain planning processes, including LTL/FTL shipments, tendering, MABDs, and planning runs.
• Experience with BusinessObjects, Power BI, Tableau, or other reporting and visualization tools.
• Understanding of supply chain financial drivers, transportation KPIs, and network optimization concepts.
• Experience supporting system testing, enhancements, troubleshooting, or issue resolution.
• Exposure to 3PLs, carriers, warehousing providers, or other logistics partners.
• Familiarity with workflow improvement, automation tools, and data cleansing and validation methods.

Core Competencies

• Data analysis and validation
• Supply chain planning and transportation support
• Excel reporting and dashboard maintenance
• Enterprise systems and SAP data management
• Problem-solving and root cause analysis
• Cross-functional collaboration
• Process documentation and continuous improvement