Job Title: Cloud Pipeline Data Engineer
Job Category: Engineering
Time Type: Full time
Minimum Clearance Required to Start: Secret
Employee Type: Regular
Percentage of Travel Required: None
Type of Travel: None
* * *
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 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.
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 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.
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:
$98,500-$206,800