Lead Data Engineer

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.

COMPANY: National Railroad Passenger Corporation (Amtrak)

TITLE: Lead Data Engineer

LOCATION: Washington, D.C. and various unanticipated locations throughout the U.S. (remote position)

DUTIES: Monitors, administers, oversees, and incrementally enhances Amtrak's transportation platform and applications. Directs team to execute the following tasks: respond to change and trouble tickets; monitor the platform for failures, exceptions, and threshold issues; tune and optimize applications performance; test applications for product upgrades and patches; communicate with customers and upper management about platform and/or ticket status; and work on minor enhancements. Provides subject matter expertise and technical direction on major projects and is responsible for overseeing systems analysis, design, development, integration, and enhancement. Works closely with customers, business analysts, and team members to understand the business requirements that drive the analysis and design of quality technical solutions. Ensures solutions are aligned with business and IT strategies and follow the organization's architectural standards.

REQUIREMENTS:Must have a Bachelor's Degree (or equivalent) in Engineering, Computer Science, Information Systems, Data Science, or a related quantitative field, followed by five (5) years of progressive, post-baccalaureate experience as a Data Engineer or any occupation related to Data Science. Employer will also accept a Master's Degree (or equivalent) in Engineering, Computer Science, Information Systems, Data Science, or a related quantitative field followed by three (3) years of progressive, post-baccalaureate experience as a Data Engineer or any occupation related to Data Science. Experience must include three (3) years with the following: 1) Optimizing analytics performance by writing SQL queries on data residing in relational databases using Amazon Redshift, Oracle, Microsoft SQL Server, and Azure relational databases; 2) Developing data pipelines using Informatica and Databricks to move and transform data from multiple data sources into an enterprise data warehouse to ensure data is suitable for Business Objects, Tableau, and Power BI reporting and analytics; 3) Implementing continuous integration and continuous development using CI/CD tools, including Bitbucket, Git Hub, and Azure DevOps; and 4) Implementing SAFe Agile development practices by working with product owners and scrum masters and using Jira to track issues and defects. All experience may be acquired concurrently. Remote work permitted in accordance with company policy. All positions require pre-employment background check verification and a preemployment drug screen.

SALARY: $147,784 - $149,400 per year

CONTACT: To apply, https://bit.ly/3G330t1. Please reference Job Code: 7432423.

Requisition ID:164390

Posting Location(s):District of Columbia; Maryland; Virginia

Job Family/Function:Information Technology

Relocation Offered:No

Travel Requirements:0 - 5%

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.

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