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.
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.
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.
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,800CACI is an Equal Opportunity 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 other protected characteristic.