Note: The job is a remote job and is open to candidates in USA. The company supports government and national security missions through technology and professional services. The Cloud Pipeline Data Engineer will support data ingestion and transformation for a government financial reporting system by designing and maintaining cloud ETL pipelines, operating AWS data services, tuning databases, and contributing to system reliability and CI/CD automation.
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
Skills
- 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
- 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
Benefits
- A unique flexible time off benefit
- Access to robust learning resources
- Competitive benefits and learning and development opportunities
- Healthcare benefits
- Wellness benefits
- Financial benefits
- Retirement benefits
- Family support benefits
- Continuing education benefits
- Time off benefits
- Flexibility at CACI that allows employees to balance quality work and their personal lives
Company Overview