Norfolk Southern Corp. is seeking to improve the efficiency of its railroad operations by optimizing crew staffing, streamlining processes, and enhancing crew productivity and availability.
Requirements
- Advanced Excel skills are required.
- You should be very comfortable with Excel functions, pivot tables, and data analysis tools.
- Ability to organize and manipulate data efficiently in spreadsheets is essential.
- Experience with creating charts, using VLOOKUP/index-match, or writing macros/VBA is a bonus.
- Familiarity with data visualization or business intelligence tools such as Tableau or Power BI is a plus.
- Ability to create clear charts or dashboards to communicate data findings will be valued.
- Strong analytical and problem-solving abilities.
Responsibilities
- Use productivity and workload data to evaluate crew staffing at various locations.
- Recommend adjustments – such as adding or removing positions – to ensure each location is optimally staffed for safe and efficient operations.
- Conduct audits of crew management processes and data (e.g. crew scheduling efficiency, time-off allocations, rule compliance) to uncover opportunities for improvement.
- Examine attendance records for conductors and engineers to identify patterns, trends, and potential attendance issues.
- Maintain and develop Excel-based reports to track key performance indicators (KPIs) related to crew operations (e.g. attendance rates, staffing levels, productivity metrics).
- Streamline recurring tasks by leveraging Excel features (such as formulas, pivot tables, maybe macros) to automate data processing and reporting.
- Document standard operating procedures for these processes to help the team work faster and more consistently.
Other
- Currently enrolled in an undergraduate or graduate program.
- Sophomore, Junior, or Senior undergraduates, as well as graduate students, are welcome to apply.
- Comfort working with large datasets and extracting meaningful conclusions.
- Experience with analyzing operational or workforce data is a plus.
- Communicate key insights and recommendations to supervisors and other stakeholders in a clear, professional manner.
