AddressYour 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.
Work Arrangement: Hybrid Based out of DC
Summary of Duties
The Lead Data Analyst - Forecasting is a member of the Revenue Management Products team within the Pricing and Revenue Management (PRM) department at Amtrak. This role will assist the Senior Manager Revenue Management Products 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 models.
- Advanced proficiency in SQL or Excel and demonstrated ability to work with large complex datasets. Hands-on experience using Python libraries such as NumPy, Pandas and Scikit Learn in practical applications.
- Strong analytical and problem-solving skills, with the ability to relate multiple datasets from complex business processes, simplify and transform them into meaningful features, ready to be consumed in forecast models.
- Ability to apply supply and demand concepts in problem solving.
- Demonstrated experience in data visualization tools such as Tableau, Power BI, or similar.
- Excellent oral and written communication skills, with the ability to succinctly convey the forecast insights to diverse audiences.
- Ability to work independently and collaboratively in a fast-paced, dynamic environment.
Preferred Qualifications
- Advanced degree in Business Analytics, Statistics, or a certification in Data Science.
- Experience with advanced statistical modeling techniques such as multivariate regression and machine learning algorithms – regression, classification, and clustering.
- Proficiency in programming languages such as Python or R for advanced data analysis and modeling.
- Demonstrated progressive improvement of accuracy, reliability, and efficiency of predictive analytical models.
- Understanding Pricing philosophies and Revenue Management concepts and their relationship to travel demand.
- Familiarity with data engineering principles, ETL and tools for data integration and quality assurance.
Work Environment
- Hybrid work schedule – 2 days in-person collaboration per week.
- Supervisory Responsibilities: No
- Travel: 5%
The hourly/salary rate is $78,600 - $101,844 for the Sr. Data Analyst and $94,300 - $122,256 for the Lead Data Analyst. Pay is based on several factors including but not limited to education, work experience, certifications, internal equity, etc. Depending on an employee’s assigned worksite or location, Amtrak may consider a geo-pay differential to be applied to the employee’s base salary. Amtrak may offer additional incentive and pay programs to recognize and reward our employees, including a short-term incentive bonus based upon factors such as individual and company performance that is commensurate with the level of the position and/or long-term incentive plan compensation. In addition to your salary, Amtrak offers a comprehensive benefit package that includes health, dental, and vision plans; health savings accounts; wellness programs; flexible spending accounts; 401K retirement plan with employer match; life insurance; short and long term disability insurance; paid time off; back-up care; adoption assistance; surrogacy assistance; reimbursement of education expenses; Public Service Loan Forgiveness eligibility; Railroad Retirement sickness and retirement benefits; and rail pass privileges. Learn more about our benefits offerings here.
Requisition ID:161364
Posting Location(s):District of Columbia; N/A
Job Family/Function:Marketing
Relocation Offered:Yes
Travel Requirements:0 - 5%
You power our progress through your performance.
We want your work at Amtrak to be more than a job. We want your career at Amtrak to be a fulfilling experience where you find challenging work, rewarding opportunities, respect among colleagues, and attractive compensation. Amtrak maintains a culture that values high performance and recognizes individual employee contributions.
Amtrak is committed to a safe workplace free of drugs and alcohol. All Amtrak positions requires a pre-employment background check that includes prior employment verification, a criminal history check and a pre-employment drug screen.
Candidates who test positive for marijuana will be disqualified, regardless of any state or local statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use. Amtrak's pre-employment drug testing program is administered in accordance with DOT regulations and applicable law.
In accordance with DOT regulations (49 CFR § 40.25), Amtrak is required to obtain prior drug and alcohol testing records for applicants/employees intending to perform safety-sensitive duties for covered Department of Transportation positions. If an applicant/employee refuses to provide written consent for Amtrak to obtain these records, the individual will not be permitted to perform safety-sensitive functions.
In accordance with federal law governing security checks of covered individuals for providers of public transportation (Title 6 U.S.C. §1143), Amtrak is required to screen applicants for any permanent or interim disqualifying criminal offenses.
Note that any education requirement listed above may be deemed satisfied if you have an equivalent combination of education, training and experience.
Amtrak is an EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, disability (intellectual, mental and physical), veteran status, marital status, ancestry, sexual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.
