Cloud Pipeline Data Engineer

About the role

CACI is hiring a Cloud Pipeline Data Engineer to support data ingest and transformation for a government financial reporting system. The role covers cloud-based data intake and storage, data ingestion automation, and the reliability of data loading and transformation processes. It requires pipeline engineering expertise and the ability to maintain pipeline parameters, configuration and transformation code. The position is full time, remote, and requires a Secret clearance.

Key responsibilities

• Automate ingestion of external partner data sources using predetermined formats and CSV.
• Design, implement and maintain ETL pipelines using AWS S3, AWS Glue and AWS Data Management Services (DMS).
• Provide operational support for AWS services and 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 in maintaining and troubleshooting validation and processing logic in Oracle stored procedures and .NET applications.
• Deliver operations and maintenance support and contribute to system reliability and enhancements.
• Contribute to CI/CD automation and infrastructure-as-code development using Bitbucket, Jenkins and Terraform.

Required profile

• U.S. citizenship and willingness to obtain a DoD security clearance.
• Bachelor's degree in computer science, information systems, engineering or a related field.
• 7+ years of experience in data engineering or cloud data platform roles.
• Proven experience designing and maintaining scalable ETL/data integration pipelines.

Required skills

• 5+ years of hands-on AWS experience, including Glue, Redshift, S3, DMS, IAM and Terraform.
• Hands-on experience with CI/CD tools such as Bitbucket and Jenkins.
• Working knowledge of Redshift and Oracle environments.
• Desired: experience with .NET and Java applications, Oracle PL/SQL stored procedures and packages, Splunk or Zabbix, and large-scale data platform modernization or cloud migration.

What we offer

• Proposed pay range of $98,500-$206,800, depending on location, experience and skills.
• Healthcare, wellness, financial, retirement, family support, continuing education and time-off benefits.
• A flexible time-off benefit and access to learning resources.