Transportation Sr. Rates Analyst

Department

Pricing & Analytics

Job Description

JOB SUMMARY: The Senior Rates Analyst works with a team of analysts in tandem with the executive sales team to support the growth of new and existing business through statistics and data. The role requires advanced reporting and analytical skills with the ability to interpret data.

Job Description

Key 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
  
  

Qualifications

Minimum Qualifications

• Bachelor's degree from an accredited 4-year university with a concentration that leans heavy on numbers/analytics
• 5 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
  
  

Preferred Qualifications

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

Skills And Abilities

• Power BI
• KPI Reporting
• Analysis
• Tableau
• Excel
• Pricing
• Datawarehouse
  
  

Work Experience

• 5 years’ work experience
  
  

Education

Workshift:

In compliance with Federal and State equal employment opportunity laws, qualified candidates are considered for all positions without regard to race, color, religion, sex, national origin, age, marital status, veteran status, non-job-related disability, or any other protected group status.