Cloud Pipeline Data Engineer

The Opportunity

The Cloud Pipeline Engineer will support data ingest and transformation for a government financial reporting system. You will support cloud-based data intake and storage, data ingestion automation, and ensuring the reliability of processes responsible for data loading and data transformation. The role will require you to have the pipeline engineering expertise and the ability to maintain pipeline parameters, configuration, and transformation functions / code.

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 maintain and troubleshoot validation and processing logic embedded 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.

Required Qualifications

• Willing and able to obtain a DoD Security Clearance. U.S. Citizenship is required.
• 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.
• 5+ years of hands-on AWS experience, including Glue, Redshift, S3, DMS, IAM, and Terraform.
• Proven experience designing and maintaining scalable ETL/data integration pipelines.
• Hands-on experience with CI/CD processes and tools such as Bitbucket and Jenkins.
• Working knowledge of Redshift and Oracle environments.

Desired Experience

• Supporting or modernizing .NET and Java applications within data processing environments.
• Oracle database performance optimization experience with PL/SQL, indexing, etc.
• Experience with Oracle PL/SQL including stored procedures, packages, and business rule logic.
• Experience supporting server environments and troubleshooting with Splunk or Zabbix.
• Background in large-scale data platform modernization or cloud migration initiatives.

What You Can Expect

• A culture of integrity. At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.
• An environment of trust. CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
• A focus on continuous growth. Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.