Lead Business Analyst - 90411466 - Philadelphia

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.

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).
• 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.
• 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.

Salary/Hourly Range

$94,300.00 – $122,256.00. Pay is based on several factors including but not limited to education, work experience, certifications, etc.

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%