Portfolio Analytics Analyst: Asset & Fleet Optimization

Trinity Industries, Inc.; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

Trinity Industries seeks a practical, data-driven Portfolio Analyst to transform fleet, maintenance, and financial data into actionable insights for optimizing railcar performance and profitability. You will partner across Portfolio Management, Maintenance Operations, Structured Finance, IT, and BI teams to strengthen decision-making and drive continuous improvement.

Responsibilities include building dashboards for ~150,000 railcars, monitoring asset health, supporting lease analytics, and

Qualifications

• Bachelor's degree in Data Analytics, Business Analytics, Finance, Engineering, Statistics, or related field.
• 5+ years in a data analyst or business intelligence role, preferably in asset-intensive industries (rail, logistics, manufacturing, leasing, or fleet management)
• Proficiency in SQL for querying and transforming large datasets
• Advanced Microsoft Excel skills; experience with Power BI, Tableau, or equivalent BI platforms
• Strong written and verbal communication skills with ability to translate complex data into executive-ready insights
• Detail-oriented with demonstrated ability to manage multiple deliverables in a fast-paced environment

Responsibilities

• Develop and maintain dashboards tracking utilization, availability, and revenue across ~150,000 railcars
• Monitor asset health trends and identify at-risk inventory requiring proactive intervention
• Support lease-term analytics for renewals and remarketing in partnership with Portfolio Management leadership
• Partner with Structured Finance on blend and extend opportunities to replace old equipment with new optimal railcars
• Analyze termination and assignment expense and capital expenditure budget to actuals
• Identify cost variance drivers and support root-cause analysis for out-of-budget maintenance events
• Own the design and delivery of recurring executive-level reports for portfolio performance review cycles (Shift to DataBricks)
• Consolidate data from multiple source systems (ERP, AMS, Salesforce, etc.) into a unified reporting layer
• Partner with IT and BI teams to ensure data governance, accuracy, and scalability
• Respond to ad hoc analytical requests from VPs and SVP leadership in support of business decisions
• Provide analytical support for initiative tracking, capital planning, and operational improvement programs
• Assist in building the metrics framework necessary to evaluate economic profit contribution of the maintenance and leasing portfolio

Skills

SQL

Excel

Power BI

Tableau

Data storytelling

Attention to detail

Multi-tasking

Education

Bachelor's degree or higher in data analytics, business analytics, finance, engineering, statistics, or related field

Tools

Databricks

Qlik

ERP systems

Job description

Trinity Industries seeks a practical, data-driven Portfolio Analyst to transform fleet, maintenance, and financial data into actionable insights for optimizing railcar performance and profitability. You will partner across Portfolio Management, Maintenance Operations, Structured Finance, IT, and BI teams to strengthen decision-making and drive continuous improvement.

Responsibilities include building dashboards for ~150,000 railcars, monitoring asset health, supporting lease analytics, and