Data Analyst Freight Rate Studies and CSP
Data Analyst Freight Rate Studies and CSP
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
Job Description
Position : Data Analyst – Freight Rate Studies and CSP
Work Hours (Client) : Full time 8:304:30 pm F CST timezone
Holidays : Will Observe US holidays: New Year’s Day Good Friday Memorial Day Independence Day Labor Day Thanksgiving dayChristmas Eve and Christmas day
Pay Range : $USD/month (depending on interview assessment and client's approval) Please take note that pay will be given in USD
Company/Client Overview:
Client is a leading logistics company specializing in freight optimization and delivering costeffective solutions to our clients. We are dedicated to providing exceptional value through datadriven strategies and fostering innovation in the freight and logistics industry.
We are seeking a highly skilled and detailoriented Data Analyst to manage Freight Rate Studies and CustomerSpecific Pricing (CSP) processes. This role is pivotal in ensuring accurate pricing carrier optimization and delivering actionable insights to both internal teams and our clients.
Duties and Responsibilities:
As a Data Analyst you will leverage your expertise in data manipulation analysis and visualization to conduct LTL freight rate studies and streamline CSP bid processes. You will work closely with various stakeholders to format and analyze data create insightful presentations and contribute to datadriven decisionmaking. This role requires a strong foundation in Microsoft Excel and/or Google Sheets and experience with Power BI or similar data visualization tools is a significant advantage.
Key Responsibilities:
- Conduct detailed freight rate studies to analyze costs identify trends and support strategic pricing initiatives.
- Prepare and manipulate large datasets in Excel or Google Sheets to meet TMS (Transportation Management System) requirements for quoting.
- Create compelling data visualizations pivot tables and charts to support client presentations and internal decisionmaking.
- Manage CSP bid processes ensuring accurate data formatting and clear presentation for carrier negotiations.
- Collaborate with teams to align rate studies and CSP insights with business goals and customer needs.
- Ensure data accuracy and integrity across all analysis and reporting activities.
- Continuously refine processes and tools to improve efficiency and accuracy in freight rate studies and CSP analysis.
Minimum Requirements:
- Advanced proficiency in Microsoft Excel and/or Google Sheets is a strict requirement including complex formulas pivot tables and macros (VBA experience is a plus).
- Strong analytical skills and the ability to efficiently manage and interpret large datasets.
- Experience creating clear actionable data visualizations and reports.
- Excellent written and verbal communication skills to present data insights effectively to both technical and nontechnical audiences.
- Proven ability to prioritize multiple projects in a fastpaced environment.
- A mindset of curiosity and adaptability with a willingness to learn new tools (e.g. Power BI or similar visualization software).
- Preferred: Experience in freight logistics or pricing analysis and familiarity with carrier selection strategies.
Employment Type
Full Time
