• Job Description

  Req#: 161193

  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.

  National Railroad Passenger Corporation (Amtrak)

  TITLE: Senior Data Engineer

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

  DUTIES: Supports projects that may span a broad range of systems which require expertise in multiple technical environments and an increased level of business knowledge. Creates and maintains optimal data pipeline architecture. Assembles large, complex data sets that meet functional/non-functional business requirements. Identifies, designs, and implements automation to manual processes; optimizes data delivery; and re-designs infrastructure for greater scalability. Builds the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Cloud technologies. Builds analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics. Creates data tools for analytics and data science team members that assist them in building and optimizing our products into an innovative industry leader. Works with data and analytics experts to strive for greater functionality in our data systems. Reviews modules for quality assurance (QA) and checks compliance with application architecture standards and Service Level Agreements (SLAs). Defines development guidelines and standards to be utilized in software development and integration. Provides ongoing maintenance to applications.

  REQUIREMENTS: Bachelor’s degree or equivalent in Engineering, Computer Science, Information Systems, or a related field followed by five (5) years of progressive, post-baccalaureate experience as a Senior Data Engineer or any occupation related to software development Must also have three (3) years of experience: 1) Optimizing analytics performance by writing SQL queries on the data that resides in a relational database, including Amazon Redshift, Oracle, Microsoft SQL Server, and Snowflake; 2) Ensuring quality of the data assets through regression testing, user acceptance testing, and performance testing; 3) Driving data and information adoption through use of Cloud technologies, including Azure cloud, Salesforce Cloud, and Amazon cloud; 4) Ingesting and transforming data to load into the Data warehouse using ETL tools, including Informatica and Data Stage; 5) Resolving data quality issues by logging and tracking defects and testing cases using test management tools, including HP quality center and HP Application Lifecycle Manager; 6) Reporting key performance metrics for the organization utilizing reporting tools, including Business Objects and Tableau; and 7) Deploying applications using Agile and Waterfall methodologies for faster time to market. All experience may be acquired concurrently. Remote work permitted in accordance with standard company policy. All positions require pre-employment background check verification and

  a pre-employment drug screen.

  SALARY: $149,594 per year

  CONTACT: To apply, https://bit.ly/3TkKbpv. Please reference Job Code: 7207720.

  Requisition ID:161193
  Posting Location(s):District of Columbia
  Job Family/Function:Engineering
  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 EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, 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

  House Rules: On our Facebook page, we want our riders to get to know us, but more importantly, we want to hear about your experiences aboard Amtrak and how we may help to make your journey more enjoyable. Tune in for deals, tips and the latest Amtrak ...

Notice