Lead Data Analyst - 90341478 - Washington

Your success is a train ride away!

As we move America’s workforce toward the future, Amtrak connects businesses and communities across the country. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority, and the success of our railroad is due to our employees.

Are you ready to join our team?

Our values of ‘Do the Right Thing, Excel Together and Put Customers First’ are at the heart of what matters most to us, and our Core Capabilities, ‘Building Trust, Accountability, Effective Communication, Customer Focus, and Proactive Safety & Security’ are what every employee needs to know and do to be most impactful at Amtrak. By living the Amtrak values, focusing on our capabilities, and actively embracing and fostering diverse ideas, backgrounds, and perspectives, together we will honor our past and make Amtrak a company of the future.

SUMMARY OF DUTIES:

The Lead Data Analyst - Forecasting is a member of the Revenue Products and Business Planning team within the Pricing and Revenue Management (PRM) department at Amtrak. This role will assist the Director Revenue Products and Business Planning in continuous forecasting of ticket revenue and ridership, measuring and communicating variance to forecasts based on various driving factors. This role requires a nuanced understanding of complex business processes and how they impact various performance metrics. Exceptional analytical and data visualization skills are necessary to draw actionable insights from complex datasets and communicate effectively.

ESSENTIAL FUNCTIONS:

• Data Analysis and Transformation: Conduct in-depth analysis of complex business processes within Amtrak’s Commercial Organization. Utilize advanced SQL, Excel, and Python skills to transform and prepare large datasets for analysis.
• Forecast Model Development: Lead the development, calibration, and validation of forecast models to continuously predict revenue and ridership by various routes and services. Utilize statistical methods and machine learning algorithms to enhance forecast accuracy and reliability.
• Automate forecast generation process: Ensure timely updates to forecast models, incorporating recent data and accounting for operational disruptions, seasonal variations, and other influencing factors.
• Quantify variance due to past events and potential future initiatives:  Conduct diagnostic analytics to quantify impact due to operational changes. Estimate impact and integrate insights from marketing initiatives, product launches, and service enhancements into forecasting processes.
• Data Visualization and Presentation: Create compelling data visualizations to effectively  communicate forecast insights to various business stakeholders in the broader commercial team.
• Continuous Learning: Collaborate with subject matter experts across various functions in the commercial team to continually expand the knowledge base. Stay abreast of emerging trends and best practices in forecasting, data analytics, and data visualization. Continuously improve forecasting methodologies and tools to enhance accuracy, adaptability, and efficiency.

MINIMUM QUALIFICATIONS:

• Bachelor's Degree in Statistics, Economics, Mathematics, Computer Science, Industrial Engineering, Operations Research, or a related field with a minimum of 6 years’ experience in advanced analytical roles in transportation, supply chain management or related field. (or 3 years with a master’s degree in data science)
• Minimum 3 years of hands-on experience building and maintaining predictive analytical m