Transportation Optimization Business Analyst

Company: Widenet Consulting
Location: Seattle
Posted on: April 23, 2025

Job Description:

Job Description/Skills:

Not sure what skills you will need for this opportunity Simply read the full description below to get a complete picture of candidate requirements.
This position is remote nationwide but the candidate must work PST/MST hours no matter where they are located.

Background
Our client is engaged in an extensive Transportation Optimization program to increase efficiency and identify opportunities to improve our trucking fleet capabilities through key metrics such as 'loaded mile percentage' and 'trips per truck per day'.

Our client is looking for a Business Analyst to increase bandwidth for critical data centric tasks related to Optimization vendor selection and implementation, configuring and executing proof of concept and pilot programs, as well as final solution implementation and maintenance.

Responsibilities
Candidate will function as a Business Analyst, working directly with our Sr. IT Analyst as well as the Transportation Business team within the Optimization program, with the following responsibilities that include but are not limited to:

Develop a solid understanding of Transportation metrics and data, business use cases and requirements related to Optimization and how these align with strategic goals
Partner with business customers and technical staff to define requirements; translate and document recommendations into functional and technical specifications
Formulate, configure and execute data export and ingestion according to Optimization platform vendor and client specifications
Interpret and consolidate data results from Optimization platform outputs
Suggest improvements to processes, database structure and data formatting to achieve Optimization goals
Develop workflows to fine tune Optimization efforts according to individual area requirements
Create/augment reports that showcase data in clear and easily understood terms
Plan, create, document, and conduct Optimization system testing and implementation activities, ensuring business requirements and functional specifications are implemented effectively and meet business objectives

Qualifications

Education: Bachelor's degree in computer science, Information Systems, Data Science, Database Management, or a degree with a focus on data analytics or similar discipline, or equivalent experience is required
Experience: Minimum of three (3) to five (5) years of progressive, relevant IT/Data Science experience
Advanced ability to translate business needs into functional requirements and IT Product technical specifications
Demonstrated experience partnering with subject matter experts and third parties to identify and recommend new data solutions or improvements to existing solutions
Knowledge and understanding of Transportation/Logistics industry
Ability to develop business use cases including outcomes, benefits, and KPIs
Ability to develop specific business and industry domain expertise and knowledge of business roadmap and strategy
Strong analytical skills for interpreting and visualizing transportation data
High attention to detail
Proven ability to operate and effectively communicate while under pressure, as well as the ability to manage a diverse workload and work under time constraints with minimal supervision
Team-first professional with strong oral and written communication skills, proficient in communicating technical topics to non-technical audiences

Technical Qualifications

Advanced knowledge of SQL (SSMS) and MySQL (MySQL Workbench) with experience creating and executing stored procedures, as well as analyzing and improving query efficiency
Advanced knowledge of Microsoft Excel and Power BI for analyzing and displaying detailed data and creating reports
Expertise in SQL Server Reporting Services (SSRS) and the ability to create/modify reports
Familiarity with ticketing systems and change management processes
Familiarity with Transportation Management Systems (TMS) is a plus but not required


Pay Range: $55.00 - $65.00 per hour, depending upon experience.
Health & Medical Benefits, 401K, Employee Assistance Program, and Sick Time applicable by state.

Keywords: Widenet Consulting, Olympia , Transportation Optimization Business Analyst, Professions , Seattle, Washington