Transportation Analyst II

Company: Thermo Fisher Scientific
Location: Pittsburgh
Posted on: February 10, 2020

Job Description:

Position Summary: This position supports the supply chain business functions by preparing, analyzing, and reporting performance and results utilizing various data sources such as transportation scorecards and data warehouses. Areas of support include transportation, inventory stocking strategy, network optimization, contract negotiation support, etc. Key Responsibilities: As a member of the Global Transportation Team, the Transportation Analyst is responsible for variance analysis for monthly service, quality, and spend goals and objectives. Perform transportation network optimization studies. Manage monthly scorecard reporting of transportation metrics for service, quality, and spend. Generate cost benefit analysis for operations re-engineering projects. Analyze shifts, spikes, and trends on transportation scorecards to generate cost savings initiatives. Utilize software applications (SQL Server, Access, Excel etc.) to develop department-wide tools for transportation reporting metrics. Adapt and collaborate best practices with company divisions to achieve supply chain alignment and best practice methodology. Prepare Monthly Business Review (MBR) materials. Execute quantitative analysis to solve problems, overcome constraints and measure the impact of project initiatives. Perform Analytics and cost studies in support of carrier negotiations and rate proposals. Support EDI shipment level detail from our suppliers to our data warehouses. Reliably manage weekly/monthly reports for: service, bi-weekly updates, monthly business reviews, staff meetings, etc. Collaborate with third party freight payment company. Prepare analysis on shipment level bills to ensure contract compliance on all carriers. Development of new metrics to drive best practice methodology for cost, service and quality. Generate budget analysis and monthly reporting of operational and financial metrics. Performs other duties as assigned. Minimum Requirements/Qualifications: Excel, Access, SQL, Data warehouse familiarity. Advanced Excel techniques (pivot table, VBA Code, etc) are a plus PC, server and mainframe system familiarity. Bachelor’s degree in business related discipline required (logistics, quantitative business analysis, management information systems, or related field of study). 1-3 years experience, preferably in a high volume, multi-location distribution environment, concentrating in transportation optimization. Strong internship or co-op experience also considered. Detailed-oriented with the ability to analyze / understand a large volume of data. Experience preferred with Visio, MapPoint, CzarLite, Visual Basic, and Batchmark. APICS certification preferred. Non-Negotiable Hiring Criteria: Excel, Access, Data warehouse, and familiarity. Bachelor’s degree in business related discipline required (logistics, quantitative business analysis, management information systems, or related field of study). Advanced analytical and problem solving abilities. Demonstrated experience in analyzing significant amounts of data and turning it into actionable information. Demonstrated ability to independently take ownership of initiatives and drive execution. Sense of urgency and priority. Excellent interpersonal skills to apply in communications with business partners, corporate divisions and business units.

Keywords: Thermo Fisher Scientific, Pittsburgh , Transportation Analyst II, Other , Pittsburgh, Pennsylvania