15 days ago
Arlington, VA, USAMid Level
Responsibilities
- Maintain, monitor, and optimize automated ETL/ELT pipelines spanning 10 to 20 data sources and 1 to 20+ TB of data.
- Build and modify pipelines using AWS Glue, Step Functions, Lake Formation, Athena, and RDS.
- Write modular, parameterized pipeline code supporting changing data structures and refresh frequencies.
- Support scheduled batch, interval micro-batch, and user-triggered on-demand data refreshes.
- Ingest and export Parquet, CSV, and JSON data.
- Perform data cleansing, validation, and quality assurance for new data sources.
- Resolve Tier 3 pipeline failures, refresh errors, and database performance issues.
- Implement row-level and column-level security controls in coordination with the Data Architect.
- Document pipeline configurations, data lineage, and operating procedures.
Requirements
- Active DoD Secret or higher security clearance is required.
- Demonstrated experience building and maintaining cloud-based ETL/ELT pipelines.
- Proficiency in Python and SQL.
- Experience cleansing and validating data and integrating structured and unstructured data from multiple sources.
- DoDM 8140.03 qualifying certification, such as CompTIA Security+ CE, is required before starting.
- Preferred qualifications include AWS Glue, Step Functions, Lake Formation, Athena, and RDS experience.
- Preferred qualifications include Terraform or CloudFormation Infrastructure as Code experience applied to data pipelines.
- Experience in AWS GovCloud or DoD IL4/IL5 environments is preferred.
- Familiarity with Advana/Jupiter, Qlik, or Power BI data sources is preferred.
- AWS certification, such as AWS Certified Data Engineer - Associate, is preferred.
- Experience supporting federal financial or acquisition data is preferred.
Benefits
- On-site role based in Arlington, Virginia.
- Competitive compensation, strong benefits, vacation package, and a fast-paced work environment.
About Zantech
Zantech is a privately held IT services firm delivering digital modernization, application development, cybersecurity, and cloud services to U.S. federal agencies across defense, intelligence, and civilian sectors. The company also provides program management and systems engineering, often executing work via prime contracts and government contract vehicles. Founded in 2007 and headquartered in Reston, Virginia, it operates as a Women-Owned Small Business with CMMI- and ISO/ITIL-aligned practices.