Lead Data Engineer - 90335430 - Philadelphia | Philadelphia, PA

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. SUMMARY OF DUTIES: The Systems Engineering

group—comprised of the Infrastructure GIS team, the engineering asset management (EAM) team, and the data analytics team—is responsible for delivering and implementing the tools and technology required to achieve Amtrak’s enterprise asset management strategy for the Infrastructure Maintenance & Construction Services (IMCS) disciplines.

The Lead Data Engineer identifies additional data points required for predictive analytics that are not yet collected to assist IMCS Division Maintenance and Production and the Engineering Disciplines in enhancing their data collection processes. The Lead Data Engineer works to build data pipelines that enable better quality data collection and analysis,

working with non-typical sources and helping develop parameters for standardization of the extract, transfer, and load process that considers the nuances of the existing data infrastructure.

The Lead Data Engineer’s work allows IMCS to proactively plan infrastructure maintenance activities—reducing asset downtime, extending equipment life, and optimizing system performance—reducing the overall cost of asset management. ESSENTIAL FUNCTIONS: Lead development of pipelines for data collection and storage to be used in backssment of asset condition, useful life, and predictive failure models. Identify new data points that would be useful in enhancing predictive analytics models.

Automate calculations and analysis used for asset backssment. Integrate asset and maintenance information, data collection, and history through Amtrak’s EAM system and make it available to those who need it for decision making. The format of the data must be suitable for the audience, i. e. field technicians will need more granularity than executive management. Work with all levels of IMCS management to identify and thoroughly understand the Department’s work and asset management needs and ensure data collection and analytics are in alignment with those needs. Gather requirements, analyzing data sets and ensuring delivery of reporting to support strategic decision-making.

Administer a governance model for identifying, approving, and managing requests for data tools and reporting. Lead ongoing quality control activities for data systems and interfaces and develop quality assurance processes to drive continuous improvement in use of predictive analytics to support infrastructure asset management. MINIMUM QUALIFICATIONS: Bachelor Degree in Statistics, Computer Science, Data Analytics, or related field, or the equivalent combination of education, training and/or experience with a minimum of 6 years’ experience.

In lieu of education, a minimum of 10 years of relevant work experience, or equivalent combination of education, training, and work experience. Must have five years (5) experience in data engineering roles, preferably with infrastructure, transportation, or railroad industries. Demonstrated skill and experience manipulating and analyzing data utilizing advanced Structured Query Language (SQL) patterns, R or Python-Statistical Programming. Experienced with statistical analysis, building statistical models, and machine learning. Ability to navigate new data domains quickly, understand the underlying business problems, and take appropriate actions to ensure data access and availability.

Ability to effectively communicate with all levels of technological experience, including field and staff with no prior experience in using computer and mobile systems, to enable them to make the best use of data. Highly developed organizational and issue management and resolution activities. Demonstrated ability work as part of a team and independently, and build rapport with co-workers, managers, and supervisors. Demonstrated ability to apply strong analytical skills.

Working knowledge of database and data warehouse design. PREFERRED QUALIFICATIONS: Advanced Degree in Data Science, Mathematics, Computer Science, Engineering, or Technology management with a minimum of 8 years of experience. In lieu of education, a minimum of 12 years of relevant work experience, or equivalent combination of education, training, and work experience. Experience with object-oriented programming and developing applications Understanding of railroad infrastructure asset management and use of predictive analytics for asset management decision making. Working knowledge of asset management systems and Geospatial Information Systems (GIS).

WORK ENVIRONMENT: Office and field work environment. Travel up to 20%. Travel to other Amtrak offices and right-of-way sites that are not accessible by train travel. COMMUNICATIONS AND INTERPERSONAL SKILLS: Must have excellent oral and written communication skills. The salary/hourly range is $103,700 - $124,500. 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 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: 160624 Posting Location(s): Pennsylvania Job Family/Function: Engineering 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 EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, interaction (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, disability (intellectual, mental and physical), veteran status, marital status, ancestry, interactionual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.