Rates - Senior Rates Analyst at Stevens Transport in Dallas, TX

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:

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

Requirements

• 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
• 6+ years work experience
• Passion for numbers and understanding business
• Process-oriented
• KPI Reporting
• Power BI, Tableau or other data warehousing tools

Skills

Required

• Advanced Microsoft Excel
• Analytical skills
• Critical thinking
• Effective communication
• Organizational skills
• Research skills
• Composure under pressure

Preferred

• Power BI
• Tableau
• KPI Reporting
• Data warehousing tools

Benefits

• Medical, Vision, Dental, Supplemental, Life Insurances available + 401(k) retirement plan and quarterly match.