Note: The job is a remote job and is open to candidates in USA. Dexter is seeking a Network Optimization Analyst to support logistics network strategy through data-driven modeling and analysis. The role develops network models, SQL data sets, Tableau dashboards, cost-to-serve reporting, scenario analyses, and recommendations that improve service, reduce costs, increase visibility, and guide continuous improvement.
Responsibilities
- Develop, maintain, and refresh logistics network models used to evaluate transportation flows, delivery zones, market assignments, branch activity, customer delivery patterns, service requirements, capacity constraints, cost-to-serve, and network performance
- Lead the extraction, consolidation, validation, and refresh of logistics data from SQL Server, transportation systems, ERP sources, financial data, operational inputs, and other business systems to ensure models, dashboards, and analyses are built on reliable data
- Build Tableau dashboards, scorecards, and recurring performance reporting that provide visibility to logistics cost, service, savings progress, route performance, network utilization, customer delivery activity, carrier usage, fleet utilization, and execution gaps
- Incorporate business policies, operational constraints, customer requirements, geography, branch capabilities, fleet capacity, carrier capacity, production inputs, inventory considerations, and service expectations into network models and scenario analyses
- Identify and quantify logistics savings opportunities related to transportation cost, branch transfers, linehaul activity, carrier usage, delivery zones, route structure, fleet utilization, warehousing touchpoints, customer delivery patterns, and network inefficiencies
- Develop cost-to-serve reporting and analysis to evaluate customer, market, branch, region, delivery territory, carrier, and service model cost impact
- Build scenario analyses to support decisions related to new locations, branch alignment, market changes, delivery territory design, capacity requirements, network flow changes, service models, and logistics roadmap initiatives
- Collect business input, voice-of-customer information, operational requirements, and stakeholder assumptions to ensure modeling outputs reflect realistic business conditions and decision needs
- Identify and use proxy data sources when clean or complete data is not available, while documenting assumptions, limitations, risks, and confidence levels
- Analyze large data sets and translate findings into business recommendations, initiative summaries, performance insights, and action plans for Logistics leadership and cross-functional partners
- Support process improvement projects that result from network analytics by helping define opportunities, quantify expected benefits, establish baselines, track progress, and measure results
- Partner with Finance to validate savings assumptions, ROI, cost impact, business cases, P&L implications, and financial methodology tied to logistics network initiatives
- Partner with SIOP to align logistics analysis with demand, supply, inventory positioning, production planning inputs, customer requirements, and service expectations
- Partner with IT/AI to improve data pipelines, reporting automation, AI-enabled analytics, predictive tools, scalable dashboards, and data availability for logistics decision-making
- Partner with Logistics Procurement and Systems + Execution to ensure network recommendations are operationally feasible and supported by carrier capacity, fleet capacity, routing execution, system capabilities, and field processes
- Communicate model methodology, assumptions, calculations, findings, risks, tradeoffs, and recommendations clearly to technical and non-technical stakeholders
- Maintain and improve data integrity, reporting consistency, model documentation, calculation logic, dashboard definitions, and refresh processes to build confidence in logistics analytics
- Monitor recurring cost, service, capacity, routing, branch transfer, delivery territory, and network performance trends; escalate insights and recommended actions to the Senior Manager, Network Strategy & Optimization
- Support governance processes for evaluating network changes, market and zone guardrails, service territory decisions, cost-to-serve logic, savings initiatives, and logistics roadmap priorities
- Leverage AI-enabled analytics, automation, and predictive modeling where practical to improve logistics planning, scenario development, performance tracking, and decision support
- Perform other logistics analytics, network optimization, and continuous improvement duties as assigned
Skills
- Experience analyzing large data sets and translating findings into business recommendations, dashboards, models, scorecards, or operational action plans
- Experience with SQL, SQL Server, relational database tools, data extraction, query development, data validation, and recurring data refresh processes
- Experience building dashboards, scorecards, or reporting tools using Tableau, Power BI, or similar business intelligence platforms
- Advanced Microsoft Excel skills, including data analysis, modeling, formulas, pivots, and structured analysis
- Strong understanding of logistics or supply chain operations, including transportation, distribution, branch operations, freight movement, service requirements, capacity, cost, and operational constraints
- Experience developing scenario analyses, cost models, savings tracking, performance reporting, process improvement recommendations, or business cases
- Ability to communicate complex analysis, methodology, assumptions, risks, and recommendations to business stakeholders in a clear and practical manner
- Strong planning, organization, execution, problem-solving, and attention to detail with the ability to manage multiple priorities in a fast-paced and sometimes ambiguous environment
- Ability to work effectively with Logistics, Finance, IT/AI, SIOP, Operations, Manufacturing, TWA, Distribution, Procurement, Systems + Execution, and other business partners
- Experience with logistics network modeling, supply chain optimization, cost-to-serve analysis, route optimization, distribution network analysis, transportation modeling, or logistics engineering
- Experience with Alteryx, Python, R, Tableau Prep, Coupa Supply Chain Guru, LLamasoft, any Logistix, simulation tools, optimization platforms, or similar tools
- Familiarity with optimization concepts such as network flows, linear programming, simulation, heuristics, mixed integer programming, scenario modeling, or constraint-based modeling
- Experience in a multi-site manufacturing, distribution, wholesale, building products, transportation, or branch-based logistics environment
- Experience working with TMS, ERP, WMS, telematics, freight audit, transportation visibility, or other logistics systems as data sources
- Experience partnering with Finance to validate savings, ROI, cost assumptions, and business cases
- Experience supporting logistics transformation, network redesign, centralized transportation, control tower, or enterprise continuous improvement initiatives
Company Overview
Company H1B Sponsorship