Principal Data Engineer - 90400961 - Washington DC, Philadelphia PA, or Wilmington DE. null jobs in United States
cer-icon
Apply on Employer Site
company-logo

Amtrak · 1 week ago

Principal Data Engineer - 90400961 - Washington DC, Philadelphia PA, or Wilmington DE. null

Amtrak is a leading transportation company connecting businesses and communities across the United States. The Principal Data Engineer will lead the design, development, and optimization of large-scale data infrastructure and pipelines, serving as a technical leader in cloud data platforms and data governance tools.

Service IndustrySoftwareTourismTravel
check
Comp. & Benefits
check
H1B Sponsor Likelynote

Responsibilities

Define and implement the architectural strategy for our enterprise data platform, focusing on scalability, security, and performance
Design and build robust, high-volume, and performant data pipelines using cloud-native services like AWS Data Pipelines (Glue, EMR, S3, Redshift, etc.) or Azure Data Factory/Synapse Analytics
Act as a subject matter expert and mentor for junior and mid-level data engineers, setting best practices for code quality, testing, and deployment
Utilize tools like IDMC (Informatica Data Management Cloud) for data integration, quality, governance, and cataloging across the enterprise
Develop, optimize, and manage large-scale data processing jobs using Databricks(Spark/Delta Lake) for ETL/ELT workflows and advanced analytics
Write high-quality, efficient, and well-documented code primarily in Python for data manipulation, automation, and pipeline orchestration
Implement and maintain robust CI/CD pipelines and infrastructure-as-code (e.g., Terraform/CloudFormation) for automated deployment and management of data solutions
Ensure data readiness for reporting and analytics and possess working knowledge/experience with BI tools like Tableau and PowerBI to facilitate data consumption
Monitor, troubleshoot, and tune existing data infrastructure and pipelines to ensure optimal performance and cost efficiency

Qualification

Data architectureCloud data platformsData governance toolsBusiness intelligence solutionsPythonAWSAzureDatabricksCI/CD pipelinesProblem resolutionCommunicationTeam player

Required

Bachelor's Degree or equivalent combination of education, training and/or relevant experience
Plus 7 years of relevant work experience
Proficiency and hands on experience designing and implementing end-to-end data solutions in AWS (e.g., S3, EMR, Glue, Redshift, Kinesis) and/or Azure (e.g. Azure Data Factory, Synapse Analytics, Azure Data Lake Storage)
Experience with some of the following technologies, Databricks, Python, Apache Spark, IDMC, Talend, CI/CD pipelines, Jenkins, Gitlab, Power BI, SQL and NoSQL

Preferred

Masters degree in computer science, data engineering, or related quantitative field
9+ years of relevant work experience
Cloud certifications (AWS Certified Data Analytics - Specialty, Azure Data Engineer Associate)
Experience with real-time data streaming technologies, (Kafka, Kinesis)
Experience with IDMC tooling

Benefits

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
Rail pass privileges

Company

Amtrak is a provider of intercity passenger rail services across the country, connecting major cities and regions.

H1B Sponsorship

Amtrak has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (57)
2024 (40)
2023 (50)
2022 (52)
2021 (42)
2020 (34)

Funding

Current Stage
Late Stage
Total Funding
$125.7M
Key Investors
Federal Railroad AdministrationU.S. Department of Transportation
2024-09-03Grant· $63.9M
2023-09-25Grant· $8.8M
2022-08-18Grant· $45M

Leadership Team

leader-logo
John McSorley
Director of Critical Infrastructure Protection
linkedin
Company data provided by crunchbase