Data Engineer
Job Overview
We’re ALTEN Technology USA, an engineering company helping clients bring groundbreaking ideas to life—from advancing space exploration and life-saving medical devices to building autonomous electric vehicles. With 3,000+ experts across North America, we partner with leading companies in aerospace, medical devices, robotics, automotive, commercial vehicles, EVs, rail, and more.
As part of the global ALTEN Group—57,000+ engineers in 30 countries—we deliver across the entire product development cycle, from consulting to full project outsourcing.
When you join ALTEN Technology USA, you’ll collaborate on some of the world’s toughest engineering challenges, supported by mentorship, career growth opportunities, and comprehensive benefits. We take pride in fostering a culture where employees feel valued, supported, and inspired to grow.
We are seeking a Data Engineer to join a high-impact, execution-focused project supporting a Pharma manufacturing site. The goal is to replace legacy tools (Statistica, Spotfire, enterprise PI) with a new Snowflake-based data pipeline that integrates MES Werum, PI Historian, LIMS, and MDE systems. You will design, build, and validate production-ready ETL pipelines in Python, map data sources, create discrete and time-series datasets, and configure PI event frames, all under GxP-compliant processes. The end goal is to build production-ready data pipelines and datasets in Snowflake to support Manufacturing Science engineers (trending, CPV, troubleshooting).
Responsibilities:
- Design, develop, and deploy ETL pipelines in Snowflake using Python to integrate MES Werum, PI Historian, LIMS, and MDE data sources.
- Create mapping documents, perform data validation, and ensure complete and accurate ingestion of all required product datasets.
- Build discrete data tables and time-series datasets to meet Manufacturing Science engineers’ trending and reporting needs.
- Configure PI event frames for process event tracking and align with Snowflake architecture.
- Maintain version-controlled code in GitHub; follow CI and code review best practices.
- Collaborate with engineering teams for dataset validation, troubleshooting, and weekly progress updates.
- Deliver all work in compliance with GxP standards and within security and infrastructure framework (VPN/VDI).
Qualifications:
- 3–5 years hands-on data engineering experience.
- Snowflake: schema design, performance tuning, loading strategies (staging, bulk/CDC patterns).
- Python: production ETL experience (pandas, pyarrow, db connectors, scripting, scheduling).
- GitHub: branching, PRs, CI basics, code reviews.
- Direct experience integrating at least one of: PI Historian (OSIsoft/AVEVA PI), MES (Werum), LIMS, ideally in a regulated environment.
- Strong SQL skills for complex queries, data transformations, and optimizations. Ability to design discrete & time-series tables.
- Experience working under GxP / pharma compliance or similar regulated data governance.
Bonus Qualifications:
- Ability to run Python notebooks in cloud environments.
- Experience with Dataiku, Power BI, or homegrown front-ends.
- Knowledge of CPV (Continued Process Verification) dataset requirements.
- Experience creating PI event frames or working with PI AF.
- Familiarity with Werum MES data models (or similar MES schemas) and LIMS sample metadata.
- Docker / basic infrastructure-as-code (helpful, not required).
Salary Range: $80,000 - $90,000
The actual salary offered is dependent on various factors including, but not limited to, location, the candidate’s combination of job-related knowledge, qualifications, skills, education, training, and experience.
ALTEN Technology is an Equal Opportunity Employer. Our Policy is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual’s age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity/expression or veteran status.
Please beware of job seeker scams and see this important notice on our careers page for more information about our recruiting process.
Compliance Notice: Alten USA is a federal contractor subject to the requirements of the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRAA) and Executive Order 11246. We are an Equal Opportunity Employer and consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
Drug Screening Requirement: As a federal contractor, Alten USA maintains a drug-free workplace. All candidates selected for employment will be required to successfully complete a pre-employment drug screening as a condition of hire.