CACI International Inc is seeking a Senior AWS Data Engineer who plays a key role in sustaining and modernizing a mission system that supports HHS grant award management, reporting, and compliance. The role involves providing technical leadership in cloud-based data intake and storage, automating complex data ingestion workflows, and ensuring system reliability.
Responsibilities:
- Design, implement, and maintain scalable ETL pipelines across AWS Glue, DMS, Redshift, and supporting services
- Automate ingestion of external data sources, including Assistance Listings and aggregate award datasets
- Improve system operational efficiency and support data quality processes related to reporting and USASpending submissions
- Provide daily operational support for AWS infrastructure: Glue jobs, Redshift tuning, DMS tasks, Lambda, S3, IAM, and troubleshooting
- Offer assistance with 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
Requirements:
- Must be a U.S. Citizen
- 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
- Strong proficiency in Python and/or Java for ETL development and automation
- 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, PostgreSQL and Oracle environments
- Experience with HHS award data structures, compliance rules, and reporting workflows
- Familiarity with federal data submission standards, including USASpending requirements
- 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 Windows Server environments and troubleshooting with Splunk or Zabbix
- Background in large-scale data platform modernization or cloud migration initiatives