Regional Supply Chain Manager

AMMEGA is seeking a highly analytical and data-driven logistics professional responsible for transportation analytics, network performance measurement, freight optimization, cost visibility, dashboard development, and supply chain decision support.

This role serves as the primary owner of transportation and logistics data across North America and is responsible for transforming large volumes of operational and financial information into executive-level insights and actionable recommendations.

The successful candidate will independently access, extract, validate, analyze, and present transportation data from multiple internal and external systems while driving measurable freight cost reductions, service improvements, and process optimization initiatives.

Core Competencies

Advanced Data Analytics

- Analyze large transportation and supply chain datasets.
- Identify trends, risks, inefficiencies, and cost reduction opportunities.
- Develop executive dashboards, KPI scorecards, and operational performance reporting.
- Present findings to senior leadership in a concise and actionable format.
- Independently determine appropriate methodologies to answer business questions.
- Translate ambiguous business requests into measurable analytical outputs.

Project Leadership

- Drive analytics initiatives from concept through implementation.
- Manage multiple priorities while meeting established deadlines.

Transportation Analytics

- Develop monthly freight performance reporting across all transportation modes.
- Analyze transportation costs, accessorials, duties, taxes, and landed cost.
- Identify freight optimization opportunities and quantify resulting savings.
- Support annual budgeting and forecasting activities.

Data Extraction & Analysis

- Independently obtain data from TMS platforms, ERP systems, freight portals, carrier systems, BI tools, and supplier reporting systems.
- Combine data from multiple sources through advanced Excel, Power Query, Power BI, SQL, or other analytical tools.
- Create repeatable automated reporting processes.

Business Intelligence

- Develop dashboards showing: Spend by mode
- Spend by brand
- Lane performance
- Carrier performance
- Service levels
- Inventory movement trends
- Transportation KPIs

Executive Reporting

- Prepare analysis and recommendations for: Regional Leadership
- Supply Chain Leadership
- Finance Leadership
- Executive Management

Continuous Improvement

- Lead transportation cost-reduction initiatives.
- Develop optimization projects supported by data-driven analysis.
- Measure and validate realized savings.

Technical Requirements

Required

- Advanced Microsoft Excel Power Query
- Pivot Tables
- Pivot Charts
- XLOOKUP
- INDEX/MATCH
- Power Pivot
- Complex formulas
- Data modeling

- Power BI Dashboard creation
- Data modeling

- Transportation Management Systems (TMS)
- ERP reporting tools
- Advanced data validation and cleansing techniques

Experience Requirements

- 5+ years of transportation, logistics, supply chain analytics, or business intelligence experience.
- Demonstrated experience creating executive-level dashboards and KPI reporting.
- Experience independently collecting and analyzing transportation data from multiple systems.
- Experience leading cost-reduction projects supported by analytical findings.
- Experience presenting findings to leadership teams.

What Makes You Successful

- Self-starter who requires minimal direction.
- Able to independently identify required datasets and reporting methodologies.
- Comfortable working with incomplete or ambiguous business requests.
- Strong analytical curiosity and critical thinking skills.
- Demonstrated ownership and accountability.
- Ability to translate complex transportation data into actionable business insights.
- Experience with ERP implementation is a plus

- Bachelor's degree in Supply Chain Management, Logistics, Business Analytics, or a related field.
- 5+ years of experience in supply chain management, with a focus on transportation and logistics.
- Proven track record of driving cost savings and service improvements through data-driven initiatives.
- Strong analytical skills and expertise in advanced analytics and business intelligence tools.
- Excellent problem-solving abilities and a results-oriented mindset.
- Proficiency in data visualization and reporting tools (e.g., Tableau, Power BI).
- Experience in leading and mentoring a team of supply chain professionals.
- Strong communication and collaboration skills, with the ability to work cross-functionally.
- Ability to work independently and manage multiple projects simultaneously.
- Willingness to stay updated on industry trends and best practices in supply chain management.