Analyst, Transportation & Supply Chain Strategy
Analyst role focused on transportation economics, supply chain strategy, and quantitative modeling to optimize network design, carrier strategy, and cost structure. Requires 3-6 years experience, strong SQL and BI skills, and the ability to translate data into actionable recommendations for senior leadership.
About the job
You Will
- Own lane analysis and zone skip strategy including lane-level margin modeling, utilization thresholds, go/no-go decision frameworks for trailer dispatch, and identification of new lane opportunities across our middle mile and deep injection network.
- Drive Cross-Functional Execution: Translate complex operational and network simulations into structured project plans; partner closely with Product and Engineering teams to scale standalone analytical tools into platform-native features.
- Build cost models and simulations that forecast the financial and service impact of network changes before they go live—new zone skip lanes, carrier mix shifts, rate card scenarios, schedule changes, and FC expansion.
- Conduct shipment and transportation cost analysis including label cost trends, carrier overpayment identification, rate shopping effectiveness, and per-shipment margin by merchant, lane, and carrier.
- Support carrier RFP and network strategy by modeling rate card scenarios, benchmarking carrier economics across lanes and geographies, and building the analytical case for carrier mix decisions and contract negotiations.
- Conduct supply chain analysis including inbound flow modeling, FC throughput and capacity analysis, and demand-driven network planning inputs to support inventory positioning and FC capacity planning.
- Support network and location analysis to evaluate fulfillment center and sort center placement, injection point optimization, and the cost impact of serving different geographies from different nodes.
- Build reporting and business intelligence for carrier ops managers and transportation leadership—translating complex operational data into clear dashboards covering OTD, TNT performance, trailer utilization, and lane-level economics.
- Drive cross-functional transportation initiatives as a project lead: defining scope, aligning stakeholders across carrier ops, engineering, finance, and commercial teams, and managing workstreams from analysis through implementation.
- Produce competitive and strategic analysis on how Flexport's transportation network and product compare to the market.
- Act as a technical and domain mentor, helping scale team capabilities in SQL best practices, data modeling frameworks, AI usage and effective stakeholder communication.
You Should Have
- 3–6 years of experience in supply chain analytics, transportation strategy, network design, or a closely related analytical role.
- Strong quantitative skills—you're comfortable building financial models, running scenario analysis, and designing simulations that inform network or operational decisions.
- Proficiency in SQL; experience querying large operational datasets in tools like Snowflake, Redshift, or BigQuery.
- Strong proficiency with BI and data visualization tools (e.g., Tableau, Looker, PowerBI) to build automated, executive-ready dashboards.
- Experience with transportation or supply chain economics: shipping cost structures, carrier rate cards, zone-based pricing, network cost modeling, or equivalent.
- Supply chain or network economics—you have a solid understanding of freight procurement frameworks, carrier bid structures, or data-driven RFP evaluation models.
- A track record of translating complex, multi-source data into clear recommendations that leadership actually acts on.
- Strong project management instincts—you can own an analytical initiative end-to-end, drive cross-functional alignment, and deliver without needing close direction.
- Excellent communication skills; you can present nuanced quantitative analysis simply and confidently to senior operational and commercial audiences.
- Experience working in highly ambiguous operational environments—you're comfortable navigating fragmented or incomplete datasets and confidently making data-driven recommendations.
Bonus Points
- Experience with zone skip, middle mile, parcel carrier networks, or last mile logistics.
- Familiarity with rate shopping logic, fulfillment network simulation, or carrier rate card structures.
- Python or R skills for advanced modeling, automation, or data pipeline work.
- Background at a 3PL, e-commerce fulfillment company, carrier, or supply chain consulting firm.
- Experience with BI tools such as Metabase, Looker, or Tableau for operational reporting.
- Exposure to location optimization or facility network modeling.
Skills
SQL, Snowflake, Redshift, BigQuery, Tableau, Looker, Power BI, Python, R, Financial Modeling, Scenario Analysis, Network Cost Modeling, Carrier Rate Cards, Zone Skip Strategy, Supply Chain Analytics
Similar jobs
Data Analytics jobsAnalyzes marketing spend, channel performance, attribution, and customer growth through reporting, experimentation, data modeling, and predictive analytics. Requires 3+ years of data analysis experience, marketing expertise, SQL, BI tools, Python, and a quantitative bachelor’s degree.
Leads qualitative and quantitative market research to generate customer and market insights that guide product, growth, and business strategy. Requires five years of healthcare market research experience, advanced analytical and presentation skills, and proficiency with Excel, PowerPoint, Power BI, and AI solutions.
Analyzes loan-level quality, portfolio asset quality, and production model performance for unsecured lending. The role requires at least three years of experience in financial services or a related analytical risk function, plus proficiency with structured-data analysis and governance documentation.
Build and monitor pre-game and in-game sports player projections, manage risk through quantitative analysis, and support game-operations processes across leagues. The role requires strong DFS and sports-gaming knowledge, attention to detail, timely decision-making, and night/weekend availability.
The BI Analyst will analyze game operations, product, pricing, and user-performance data, translating findings into recommendations, dashboards, and reusable analyses. The role requires advanced SQL, visualization, and Excel skills plus experience in analytics, gaming, finance, or related domains.