Transportation Rates Analyst

Stevens Transport•Dallas, TX

5d•Onsite

About The Position

The Transportation Rates Analyst partners cross‑functionally with fellow analysts and the executive sales team to support business growth through data analysis and insight generation. This role requires strong analytical skills, advanced Excel proficiency, robust reporting capabilities, and the ability to interpret and communicate trends from complex data sets. In order to be considered for this position, candidates must complete an Excel‑based assessment. We will only contact individuals who complete the assessment. Access the assessment here: https://www.ondemandassessment.com/o/JB-65WDU2I62/landing?u=1092983 This is an onsite position based at our Dallas, TX (75227) office. Candidates must reside within the DFW area. Relocation assistance is not provided.

Requirements

Bachelor's degree from an accredited 4-year university with a concentration that leans heavy on numbers/analytics
2+ years of analyst experience
Proactive approach to researching
Structurally organized and notes centric
Experience summarizing results and producing reports using advanced Microsoft Excel functions
Composed under pressure despite changing priorities and occasional interruptions
Critical thinking and effective communication
Highly organized and communicative
Extremely personable and comfortable working closely with executive management

Nice To Haves

Passion for numbers and understanding business
Process-oriented
KPI Reporting
Power BI, Tableau or other data warehousing tools

Responsibilities

Analyzing and implementing pricing based on current market prices vs historical trends, company cost structure, business growth objectives and profitability targets
Utilizing overall knowledge of company bid-rate structure to complete pricing submissions against critical (and often narrow) deadlines set by customers
Writing complex queries and formulas
Researching pricing discrepancies and reporting findings
Monitoring schedule of outstanding proposals through multiple rounds of pricing updates
Updating database with new and revised contract rate terms for both spot and fixed term pricing, and maintaining detailed records of completed agreements
Responsibilities include day-to-day management of all pricing activities, troubleshooting, managing exceptions, as well as performing ad-hoc analyses to support strategic initiatives
Generating recurring and ad-hoc reporting on national high-profile accounts, plus ability to summarize trends