The Planet Group
https://cdn.haleymarketing.com/templates/63515/logos/square.png
http://www.theplanetgroup.com
http://www.theplanetgroup.com
true
Excel Guru: Logistics Analyst
770 Cochituate Road Framingham, MA 01701 US
Posted: 01/20/2023
2023-01-20
2023-02-25
Employment Type:
Contract
Job Category: Accounting & Finance
Job Number: 540321-1
Country: United States
Is job remote?: Yes
Job Description
Logistics Analyst
Contract at least 6 months
Pay Rate: $30-35/hr
Must have:
Bachelor's degree
5 years+ Finance, Logistics, Data experience
Excel - VLookups, Formulas, Graphing, Building Dashboards
A Corporate level department that interacts with the operational Logistics and Sourcing Departments, as well as external partners, is looking for an experienced Analyst that has a strength with Excel and that analytical mindset.
The Excel skills are critical in this role as you will be extracting large volumes of data and will be asked to organize and analyze this information. Experience with Sum, If functions, Pivot Tables and Lookups will be some of the important skills for this work.
The data relates to logistics and sourcing via their partners and they are looking for the analytical mindset to help them who can help improve and streamline their processes for handling this data.
Specific work could include:
- Calculate and prepare rate adjustments to reflect desired future state structure.
- Build and maintain templates reflecting current location profiles, rates, contract expirations, space requirements, volumes etc.
- Perform research on rate discrepancies
- Evaluate current processes around purchase order maintenance, make recommendations for improvements.
- Build out transportation requirements for new RFP's; evaluate historical movements, revise to reflect stores in scope and expected volume
- Calculate impact of rate adjustment requests and make recommendations for leadership review
- Assist with the preparation of executive presentations
Contract at least 6 months
Pay Rate: $30-35/hr
Must have:
Bachelor's degree
5 years+ Finance, Logistics, Data experience
Excel - VLookups, Formulas, Graphing, Building Dashboards
A Corporate level department that interacts with the operational Logistics and Sourcing Departments, as well as external partners, is looking for an experienced Analyst that has a strength with Excel and that analytical mindset.
The Excel skills are critical in this role as you will be extracting large volumes of data and will be asked to organize and analyze this information. Experience with Sum, If functions, Pivot Tables and Lookups will be some of the important skills for this work.
The data relates to logistics and sourcing via their partners and they are looking for the analytical mindset to help them who can help improve and streamline their processes for handling this data.
Specific work could include:
- Calculate and prepare rate adjustments to reflect desired future state structure.
- Build and maintain templates reflecting current location profiles, rates, contract expirations, space requirements, volumes etc.
- Perform research on rate discrepancies
- Evaluate current processes around purchase order maintenance, make recommendations for improvements.
- Build out transportation requirements for new RFP's; evaluate historical movements, revise to reflect stores in scope and expected volume
- Calculate impact of rate adjustment requests and make recommendations for leadership review
- Assist with the preparation of executive presentations
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Framingham, MA
Ready for an exciting career in the vibrant community of Framingham, Massachusetts? Explore our job opportunities in this dynamic area that boasts rich history, stunning landscapes, and a thriving economy. Framingham is nestled in Middlesex County, just west of Boston, offering a perfect blend of urban conveniences and suburban charm. With landmarks like the Framingham History Center, amazing local cuisine ranging from classic New England fare to global flavors, and venues like the Amazing Things Arts Center and MetroWest Symphony Orchestra, Framingham is a hub of culture and creativity. Join the bustling job market, take advantage of top-notch education and healthcare facilities, and immerse yourself in the welcoming community spirit of Framingham. Let's kickstart your career journey together!