Lead Business Analyst - 90411466 - Philadelphia (Philadelphia, PA, US, 19104)

Amtrak

Philadelphia, PA

JOB DETAILS
SALARY
$94,300–$122,256 Per Hour
SKILLS
Analysis Skills, Ariba, Best Practices, Business Administration, Business Analysis, Business Development, Business Intelligence, Business Intelligence Software, Business Processes, Business Strategy, Candidate Screening, Candidate Testing, Code of Federal Regulations, Communication Skills, Computer Programming, Computer Science, Continuous Improvement, Cost Control, Cross-Functional, Customer Relations, Data Analysis, Data Mapping, Data Mining, Data Processing, Data Sets, Data Visualization Tools, Data Warehousing, Database Design, Database Optimization, Database Technology, Dental Insurance, Detail Oriented, Disability Insurance, Employee Assistance Plan, Expense Analysis, Federal Laws and Regulations, Finance, Financial Planning, Health Plan, Identify Issues, Leadership, Lean Six Sigma, Legal, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Multitasking, Performance Analysis, Performance Management, Performance Metrics, Presentation/Verbal Skills, Problem Solving Skills, Procedure Implementation, Process Improvement, Process Management, Project/Program Management, Public Transport, Purchasing/Procurement, Query Analysis, Query Optimization, Regulations, Relational Databases (RDBMS), Reporting Skills, SAP, SAP ECC (fka SAP R/3 and SAP ERP), SQL (Structured Query Language), Safety/Work Safety, Scripting (Scripting Languages), Staff Requirements, State Laws and Regulations, Statistics, Stored Procedures, Strategic Planning, Student Loans, Student Services, Supply Chain, System Integration (SI), Tableau, Test Program, Time Management, Trend Analysis, Vendor/Supplier Evaluation, Vision Plan, Willing to Travel, Writing Skills
LOCATION
Philadelphia, PA
POSTED
10 days ago

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

Members of Amtrak's Business Improvement & Analytics (BIA) team are leaders in formulating and executing business strategies, high-impact strategic solutions, and continuous improvement. BIA drives value creation by supporting functional Procurement & Supply Chain teams and greater departmental strategies by ensuring efficiency & excellence in execution of those strategies.

The Lead Business Analyst is responsible for driving the development and adoption of business intelligence, advanced analytics, and reporting solutions while supporting data cleansing and system integration initiatives. This role leads complex problem-solving efforts, identifies operational issues, executes performance improvement projects that deliver measurable business impact, manages multiple workstreams, and collaborates cross-functionally to analyze data and deliver executive-level insights and recommendations.

The role supports key Procurement & Supply Chain initiatives, including supplier performance, spend analytics, cost savings, and performance reporting, enabling informed decision-making and operational excellence. 

Essential Functions

  • Support department requests through technical development (SQL queries, data source creation, etc.) and implementing accompanying procedures/methods and solutions.
  • Use advanced quantitative methods to understand, identify trends, predict, and enhance Supply Chain & Procurement processes for key strategic initiatives.
  • Collaborate with colleagues in IT functions and subject matter experts in Procurement & Supply Chain on functional business requirements to support performance goals.
  • Create and facilitate financial and performance processes and reporting used by working teams to manage performance efforts that align with department and corporate strategy and key performance metrics (KPIs).
  • Lead and collaborate with working teams and senior management to implement reporting solutions and systems that impact strategic initiatives.
  • Recommend and facilitate business improvement opportunities through improved end-to-end process design and management to enhance performance, drive efficiencies, and reduce costs.
  • Assemble data, develop SQL queries and procedures, create custom reports using Enterprise Data Warehouse (EDW) sources 
  • Integrate database and write optimized SQL queries for applications and business intelligence reporting (mainly Tableau).
  • Produce data mapping from source to target database schemas, data cleansing, processing, writing data extract scripts for data conversion, and researching complex data problems.
  • Create program views, complex functions and stored procedures, analyze queries, and resolve problems. Design relational databases and write code that interacts with stored data to complete functional business requirements. 

Minimum Qualifications

  • Bachelor's Degree in Business Analytics, Computer Science, Statistics, Business Administration, or related field required and/or equivalent combination of training, education and relevant work experience may be considered in lieu of a degree.
  • 6+ years relevant work experience and progressive responsibility for data analysis, reporting, business analytics and business process implementation in Procurement and/or Finance; or equivalent combination of education, training, and/or work experience.
  • Proficient knowledge of Microsoft Excel.
  • Expert knowledge of data visualization software such as Tableau.
  • Proven experience with programming for data analysis, statistics and databases.
  • Strong communication skills (oral and written).
  • Ability to work in a fast-paced, deadline-driven environment.
  • Prior satisfactory job performance. 

Preferred Qualifications

  • Master’s Degree and certified courses in Business Analytics, SQL, Continuous Improvement, Lean Six Sigma, and/or Project Management.
  • 8+ years of relevant work experience and progressive responsibility in Business Analytics role.
  • Exceptional data analytical skills, proficiency in SQL, Excel, and statistics.
  • Proven experience with SAP ECC, SAP S4HANA, and Ariba on Demand.
  • Advanced proficiency in Microsoft Excel.
  • Proven experience in organizations with multi-functional departments and cross-functional work teams.
  • Development/programmer skills with Tableau (or similar analytical/visualization tool).
  • Expert knowledge of Supply Chain and Procurement data, systems, and best practices. 
  • Transportation industry experience. 

Knowledge, Skills, and Abilities

  • Strong data analysis skills including data mapping, data cleansing, processing, and researching complex data problems, and reporting skills.
  • Excellent written and oral communication skills.
  • Demonstrated ability to manage multiple projects in a dynamic environment with frequently changing priorities and produce successful deliverables within tight deadlines. 
  • Advanced expert knowledge/proficiency in SQL and Microsoft Excel, Word, and PowerPoint.
  • Comfortable analyzing and manipulating large data sets (including data mining) and ability to report on/communicate findings to leadership and/or internal customers.
  • High attention to detail and organizational aptitude.
  • Self-motivated and able to work independently.
  • Comfortable working in a fast-paced role and can learn new concepts and systems quickly.
  • Experience with SAP and Ariba on Demand systems. 
  • Working knowledge of Tableau (or similar analytical/visualization tool), and general project management skill 

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 WellbeingFinancial and RetirementWork and Family Life Support
Health, Dental, and Vision Insurance401K with Employer MatchGenerous Paid Time Off 
Wellness ProgramsRailroad Retirement BenefitsPaid Caregiving Days and Backup Care
Health Savings AccountPublic Service Student Loan ForgivenessFertility and Family Building Benefits
No-cost Personal Health AdvocateStudent Loan AssistanceAdoption and Surrogacy Assistance
Medical Plan Opt-out CreditTuition and Education ReimbursementPaid Family Leave
 Life InsuranceRail Pass Privileges
 Short- and Long-term Disability InsuranceEmployee Assistance Program
 No-cost Financial Advisor SessionsCommuter and Flexible Spending Accounts

Learn more about our benefits offerings here.

 

Requisition ID:166677

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.

About the Company

A

Amtrak