Norfolk Southern's Crew Management Optimization team is seeking to improve the efficiency of railroad operations by addressing workforce challenges and streamlining processes related to 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.
- 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.
- Experience with analyzing operational or workforce data is a plus.
- Experience with creating charts, using VLOOKUP/index-match, or writing macros/VBA is a bonus.
Responsibilities
- Use productivity and workload data to evaluate crew staffing at various locations.
- 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.
- Work with the crew management team to track attendance performance and assist in preparing documentation or summaries for use in the disciplinary process, ensuring consistent application of the attendance policy.
- Maintain and develop Excel-based reports to track key performance indicators (KPIs) related to crew operations (e.g. attendance rates, staffing levels, productivity metrics).
- Present findings through clear charts or dashboards; if skilled in tools like Tableau or Power BI, use them to create insightful visualizations that aid decision-making.
- Streamline recurring tasks by leveraging Excel features (such as formulas, pivot tables, maybe macros) to automate data processing and reporting.
Other
- Currently enrolled in an undergraduate or graduate program.
- Sophomore, Junior, or Senior undergraduates, as well as graduate students, are welcome to apply.
- Strong analytical and problem-solving abilities.
- Comfort working with large datasets and extracting meaningful conclusions.
- Communicate key insights and recommendations to supervisors and other stakeholders in a clear, professional manner.
