Principal Technologist Ent App Supp null

Job Summary

Work Environment:
Work will be onsite in Washington DC, Philadelphia PA, or Wilmington DE. Requests for remote work will be reviewed, not guaranteed.

The Principal Data Engineer will lead the design, development, and optimization of our large‑scale data infrastructure and data pipelines. They will serve as a technical leader, highly proficient in modern cloud data platforms, data governance tools, and business intelligence (BI) solutions. This role requires deep expertise in data architecture, data modeling, and performance tuning to ensure reliable, scalable, and high‑quality data assets that drive business‑critical decisions.

• Architect and Design:
  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.
• Technical Leadership:
  Act as a subject‑matter expert and mentor for junior and mid‑level data engineers, setting best practices for code quality, testing, and deployment.
• Data Governance & Management:
  Utilize tools like IDMC (Informatica Data Management Cloud) for data integration, quality, governance, and cataloging across the enterprise.
• Data Processing and Analysis:
  Develop, optimize, and manage large‑scale data processing jobs using Databricks (Spark/Delta Lake) for ETL/ELT workflows and advanced analytics.
• Coding and Scripting:
  Write high‑quality, efficient, and well‑documented code primarily in Python for data manipulation, automation, and pipeline orchestration.
• Deployment and Automation:
  Implement and maintain robust CI/CD pipelines and infrastructure‑as‑code (e.g., Terraform/Cloud Formation) for automated deployment and management of data solutions.
• Business Intelligence:
  Ensure data readiness for reporting and analytics and possess working knowledge/experience with BI tools like Tableau and Power
  
  BI to facilitate data consumption.
• Performance and Optimization:
  Monitor, troubleshoot, and tune existing data infrastructure and pipelines to ensure optimal performance and cost efficiency.

• 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, Git Lab, Power BI, SQL, No
  
  SQL.

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

• Strong communication and interpersonal skills; collaborative team player; self‑motivated.
• Advanced knowledge of relevant technologies, systems, and methodologies; stays updated on emerging trends.
• Skilled in analyzing complex technical issues, making sound decisions, and implementing effective problem resolution strategies.

The salary/hourly range is $ – $. 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;…