Business Analyst II

PROTRANS INTERNATIONAL LLC•Indianapolis, IN

About The Position

The Business Analyst II performs financial and operational analysis of transportation services provided to customers. The role analyzes account performance, identifies opportunities to improve profitability, supports pricing and revenue initiatives, manages the annual General Rate Increase (GRI) process, and prepares financial documentation and presentations for customer and internal business decisions. The position works closely with Finance, Sales, Commercial, Procurement, Supply Chain Management, and other internal teams to help ensure customer accounts meet financial objectives and pricing and revenue initiatives are managed and executed effectively.

Requirements

Bachelor’s degree from an accredited four-year college or university.
At least four years of relevant experience in transportation, financial analysis, pricing, or a related field.
Demonstrated experience analyzing account financial performance and identifying profitability opportunities.
Demonstrated ability to independently manage complex financial or pricing activities.
Ability to read, write, and speak English fluently.
Ability to perform the essential duties satisfactorily; reasonable accommodations may be made for individuals with disabilities.

Responsibilities

Work with Sales, Procurement, and Supply Chain Management to address below-goal margin items on customer accounts and develop strategies to improve profitability.
Manage the annual General Rate Increase (GRI) process for assigned customer accounts from beginning to end, including maintaining detailed tracking throughout each account's GRI cycle.
Analyze account financial performance and determine rate increases or other financial improvements needed to meet established goals.
Track each account's progress through the GRI process, including financial analysis, required increases, customer strategy, internal approvals, documentation, and completion status.
Prepare GRI calculations, supporting financial analysis, customer documentation, and GRI letters for assigned accounts.
Coordinate with internal teams to ensure GRI information and supporting documentation are accurate, complete, and available on time.
Provide completed GRI materials and supporting financial analysis to the Commercial Team for review and customer presentations; assist with follow-up questions and additional analysis.
Create General Rate Increase letters and create and load new rates into the 3GTMS system.
Participate in weekly financial meetings covering EDI-related items, collections-related items, and pricing approval requests.
Provide financial and account-level analysis during weekly meetings, identify issues requiring follow-up, and work with appropriate teams to resolve them.
Support pricing approval meetings with financial analysis, account performance information, margin impact, and other information needed to evaluate pricing requests.
Analyze current shipments with negative margins and identify cost-saving initiatives and opportunities that benefit both the customer and ProTrans.
Analyze individual tracks to identify potential revenue loss or overpayment and identify system gaps that may cause either issue.
Review account financial performance and identify opportunities to improve revenue, margins, and overall profitability.
Amend service agreements as needed or required.
Review exception reports for potential incorrect billings and work with appropriate teams to resolve billing discrepancies.
Help maintain data integrity across internal and external sources.
Update hierarchy for activities such as carrier changes, OD-pair changes, and mode, type, or service adjustments.
Identify and implement continual improvement initiatives to enhance the performance of the position, team, and company.
Develop and maintain effective working relationships with Commercial, Sales, Procurement, Supply Chain Management, Operations, and other internal teams to support customer and company financial objectives.