Lead Data Analyst - Forecasting - 90402617 - Washington/Philadelphia

Amtrak; Washington (District of Columbia); On-site; USD 94,000 - 122,000; Full time

Benefits offered by this job

Health Insurance

401K with Employer Match

Paid Time Off

Rail Pass Privileges

Job summary

Amtrak invites applications for the Lead Forecasting Analyst role based in Washington DC or Philadelphia, focusing on travel demand forecasting and revenue modeling. You will guide operating decisions through econometric forecasts and scalable analytics, partnering with various teams to drive strategic choices.

The role involves mentoring junior analysts and delivering dashboards using SQL, Tableau, and Power BI, with a strong emphasis on data-driven decision making.

Qualifications

• Bachelor’s Degree in engineering, data science, economics, statistics or a related field.
• Plus 6 years of relevant work experience.

Responsibilities

• Lead the development of ridership and ticket revenue projections and market demand information.
• Develop dashboards, reports, and visualizations using BI tools (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

Skills

SQL

Tableau

Statistical tools

BI frameworks

Business acumen

Communication

Project leadership

Collaboration & mentorship

Education

Bachelor’s degree in engineering, data science, economics, statistics or related field

Tools

Tableau

Power BI

SQL

Job description

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.

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.

This position can be based out of Washington DC or Philadelphia, PA.

Job Summary

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 BI tools (e.g., 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 or equivalent combination of education, training and/or relevant experience.
• Plus 6 years of relevant work experience.

Preferred Qualifications

• Master’s Degree or equivalent combination of education, training and/or relevant experience.
• Plus 8 years of relevant work experience.

Knowledge, Skills, And Abilities

• Data Analysis Expertise: Proficient in SQL, Tableau, and statistical tools; strong understanding of BI frameworks and data modeling.
• 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.
• 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.

The salary/hourly range is $94,300.00 – $122,256.00. Pay is based on several factors including but not limited to education, work experience, certifications, 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.

Health and Wellbeing Financial and Retirement Work and Family Life Support

• Health, Dental, and Vision Insurance
• 401K with Employer Match
• Generous Paid Time Off
• Wellness Programs
• Railroad Retirement Benefits
• Paid Caregiving Days and Backup Care
• Health Savings Account
• Public Service Student Loan Forgiveness
• Fertility and Family Building Benefits
• No-cost Personal Health Advocate
• Student Loan Assistance
• Adoption and Surrogacy Assistance
• Medical Plan Opt-out
• Credit Tuition and Education Reimbursement
• Paid Family Leave
• Life Insurance
• Rail Pass Privileges
• Short- and Long-term Disability Insurance
• Employee Assistance Program
• No-cost Financial Advisor Sessions
• Commuter and Flexible Spending Accounts

Requisition ID:167060

Work Arrangement: 06-Onsite 4/5 Days Click here for more information about work arrangements at Amtrak.

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.