Lead Data Analyst - Forecasting - 90402617 - Washington
Washington, DC, US, 20001
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.
Job Summary
Partner with stakeholders in IT and the company's business divisions to define requirements and develop solutions for scalable and reliable applications and platforms designed to meet business growth. Contribute to the creation, maintenance, and management of Business Intelligence reports and dashboards for clients in the business, while supporting end users with data analysis and report creation, and troubleshooting. Maintain a strong knowledge of BI tools and programming languages used by the organization, as well as experience in systems design and a strong understanding of development, testing, and integration methodologies. Possess required knowledge of current and emerging IT products, services, and processes.
The Lead Forecasting Analyst transforms complex data into actionable insights that inform business decisions and improve operational performance. As a subject matter expert, this role leads demand forecasting projects, partners with cross-functional teams, and develops scalable reporting tools. The analyst blends internal and external data sources to identify trends, evaluate strategic options, and support decision-making across the organization. This role operates with limited oversight and may coach junior analysts.
Duties include supporting the maintenance and application of travel demand forecasting models and tools along with business analytics pertaining to demand, addressing Amtrak ridership, ticket revenue, passenger miles, service levels, and high-level pricing changes as well as competing modes of travel.
Essential Functions
- Lead the development of ridership and ticket revenue projections and market demand information to guide operating decisions and capital investments, utilizing Amtrak’s econometric forecasting analytics / models
- Develop dashboards, reports, and visualizations using customized scripts and BI tools (e.g., Python, R, Tableau, Power BI, SQL)
- Integrate and analyze internal and external data sources to assess market, customer, and/or operational trends.
- Collaborate with business partners to model outcomes of proposed strategies and provide data-driven recommendations.
- Contribute to data governance, may mentor junior analysts, and promote analytical best practices.
- Collaborate closely with team members and other Amtrak groups
- Other duties as assigned
Minimum Qualifications
- Bachelor’s degree in engineering, data science, economics, statistics or a related field plus 6 years of relevant work experience or equivalent combination of education, training and/or relevant experience
Preferred Qualifications
- Master’s degree in engineering, data science, economics, statistics or a related field plus 6 years of relevant work experience
Knowledge, Skills, and Abilities
- Data Analysis Expertise: Proficient in travel demand analysis and forecasting, including experience with survey sampling, data analytics modeling, and multivariate analytical techniques such as conjoint analysis, regression analysis, segmentation, and cluster analysis.
- Programming skills/experience with Python/R, SQL, VB, and/or other languages
- Business Acumen: Ability to connect data insights to business strategy and operational goals.
- Communication: Skilled in presenting complex findings to non-technical audiences and influencing stakeholders.
- Comfort with large amounts of complex data from multiple sources coupled with the ability to see linkages and relationships within and between sources.
- Project Leadership: Capable of managing analysis projects independently and coordinating across teams.
- Collaboration & Mentorship: Works effectively with cross-functional teams and may support development of junior staff.
Preferred
- Experience with visualization tools such as Business Objects, Tableau or similar
- Experience working with network forecasting models (such as TransCAD, Cube/Voyager, and/or other similar packages) and GIS systems (such as ArcView).
- Experience with one or more statistical programming languages (e.g., SAS, Stata, SPSS, R).
Work Environment
Physical Demands:
- Constantly or frequently uses a computer keyboard, monitor, and mouse to perform a variety of tasks.
- Constantly or frequently sits, stands, or walks; may lift, carry, push, or pull objects of various weights; may reach, kneel, crouch, bend, or twist in order to in order to perform administrative tasks (e.g., filing, retrieving materials from desks and bookcases, moving around an office setting).
Mental Demands:
- Constantly communicates, comprehends, and responds to verbal statements and instructions both orally and in writing.
- Frequently acquires new knowledge, skills, and tasks, both complex and simple, in order to maintain effectiveness in position.
- Frequently reads and analyzes hard copy and or computer screen material and writes reports as appropriate.
- Conducts in person and/or telephone dialogues as appropriate in order to manage and conduct the flow of work.
Working Conditions:
- Additional working hours and travel will be required periodically.
- Works in a fast-paced, time sensitive environment with frequently changing priorities.
- Frequently handles multiple projects concurrently.
The hourly range is $94,300.00 – $135,900.00 (with opportunity for increases, as per the applicable collective bargaining agreement, after beginning employment). Amtrak offers a comprehensive benefit package that includes health, dental and vision plans; wellness programs; flexible spending accounts; 401K retirement plan; life insurance; paid time off; reimbursement of education; Public Service Loan Forgiveness eligibility; Railroad Retirement sickness and retirement benefits; and rail pass privileges. Some benefits are subject to the collective bargaining agreement. Learn more about our benefits offerings here.
Requisition ID:165600
Posting Location(s):District of Columbia
Relocation Offered:No
Travel Requirements:Up to 25%
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 equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race/color, to include traits historically associated with race, including but not limited to, hair texture and hairstyles such as braids, locks and twists, religion, sex (including pregnancy, childbirth and related conditions, such as lactation), national origin/ethnicity, 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.
