Cloud Data Pipeline Engineer (AWS, ETL)

CACI; Atlanta (GA); On-site; USD 99,000 - 207,000; Full time

Job summary

CACI is seeking a Cloud Pipeline Data Engineer to support data ingest and transformation for a government financial reporting system. You will design and maintain ETL pipelines using AWS (S3, Glue, DMS) and ensure reliability of data loading processes. Strong CI/CD experience with Bitbucket/Jenkins is required.

Ideal candidates have 7+ years in data engineering, 5+ years AWS work, and familiarity with Redshift/Oracle environments. DoD clearance and U.S. citizenship are mandatory.

Qualifications

• DoD security clearance and U.S. citizenship required.
• Bachelor’s degree in a relevant field.
• 7+ years of data engineering or cloud data platform experience.
• 5+ years of hands-on AWS experience (Glue, Redshift, S3, DMS, IAM, Terraform).
• Experience designing and maintaining scalable ETL/data integration pipelines.
• Experience with CI/CD tools such as Bitbucket and Jenkins.
• Experience with Redshift and Oracle environments.

Responsibilities

• Automate ingestion of external partner data sources using predetermined formats and CSV.
• Design, implement, and maintain ETL pipelines using AWS services (S3, Glue, DMS).
• Provide operational support for AWS services, Glue jobs, Redshift tuning, DMS tasks, Lambda, S3, IAM, and troubleshooting.
• Offer Oracle database performance tuning, indexing strategies, and PL/SQL-based business rules.
• Assist maintenance and troubleshooting of validation and processing logic in Oracle stored procedures and .NET applications.
• Deliver O&M support and provide capacity for system reliability and enhancements.
• Contribute to CI/CD automation and infrastructure-as-code development using Bitbucket, Jenkins, and Terraform.

Skills

DoD security clearance

US citizenship

CI/CD processes

Data pipeline design

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field

Tools

AWS

Redshift

Oracle

Bitbucket

Jenkins

Terraform

S3

Glue

DMS

IAM

Job description

CACI is seeking a Cloud Pipeline Data Engineer to support data ingest and transformation for a government financial reporting system. You will design and maintain ETL pipelines using AWS (S3, Glue, DMS) and ensure reliability of data loading processes. Strong CI/CD experience with Bitbucket/Jenkins is required.

Ideal candidates have 7+ years in data engineering, 5+ years AWS work, and familiarity with Redshift/Oracle environments. DoD clearance and U.S. citizenship are mandatory.