Data Engineer - ETL/SQL
First seen by Alion on Nov 11, 2026.
Key Responsibilities :
- Develop, test, and maintain ETL SQL code including stored procedures and views.
- Build and schedule jobs in Autosys to orchestrate data workflows.
- Design, implement, and enhance EDF jobs that move data through modules such as Data Processing Pipeline (D2P), Data Control and Anomaly Detection Framework (DCAF), and GeneralPurpose Data Reconciliation (GPR).
- Extract data from flat files and REST APIs, transform it per business rules, and load it into target platforms (Data Lake or Snowflake).
- Collaborate with source system owners and data consumers to ensure data quality, reliability, and performance.
- Provide documentation and support for production issues and ongoing pipeline improvements.
Required Skills :
- Strong SQL coding expertise; experience with DBeaver or similar SQL client tools.
- Handson experience with Autosys job scheduling.
- Proficiency in building and maintaining ETL processes (stored procedures, views).
- Ability to work with flat file formats and consume data via REST APIs.
- Familiarity with data lake concepts and Snowflake cloud data warehouse.
Skills
Data Engineering, SQL, ETL, Autosys, RESTful API, DataLake, Snowflake DB