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/SQLbased business rules.

• Assist maintain and troubleshoot validation and processing logic embedded in Oracle stored procedures 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.

Qualifications:

Required: (Must meet required skills below to qualify. Please be sure ALL skills are listed on resume)

• Willing and able to obtain a DoD Security Clearance. U.S. Citizenship is required.

• Bachelors 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 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 youll be part of a high-performing group dedicated to our customers 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. Youll 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 nations 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.

Pay Range:

There are a host of factors that can influence final salary including but not limited to geographic location Federal Government contract labor categories and contract wage rates relevant prior work experience specific skills and competencies education and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI you will receive comprehensive benefits such as; healthcare wellness financial retirement family support continuing education and time off benefits.

Since this position can be worked in more than one location the range shown is the national average for the position.

The proposed salary range for this position is:

CACI is anEqualOpportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex pregnancy sexual orientation age national origin disability status as a protected veteran or any otherprotectedcharacteristic.