Automation & Data Integration Engineer

CACI International Inc; Washington (District of Columbia); On-site; USD 121,000 - 266,000; Full time

Job summary

CACI International Inc. in Washington, DC is seeking an Automation Data Integration Administrator to design and maintain automated data pipelines that ingest from APIs, databases, and IoT sources and deliver to data warehouses or lakes.

You will implement ETL/ELT processes, data quality checks, and anomaly detection to ensure reliable data for security operations. The role requires strong Python/SQL skills, familiarity with Airflow or Prefect, and experience building scalable, automated data

Qualifications

• U.S. Citizenship required
• FEMA EOD suitability or current DHS/FEMA EOD preferred
• BS/BA + 15 years of applicable experience in data integration and automation
• Demonstrated expertise in Apache Airflow, Prefect, or similar orchestration tools
• Experience with ETL/ELT processes and automation tools
• Knowledge of data quality frameworks and observability systems
• Experience with APIs, databases, and data warehouse/lake technologies
• Strong programming skills in Python, SQL, or similar languages

Responsibilities

• Create and manage end-to-end pipelines ingesting data from diverse sources including APIs, databases, and IoT while delivering data to data warehouses or lakes
• Automate extraction, transformation, and loading processes to ensure data is clean, standardized, and ready for analysis
• Implement automated tests, anomaly detection, and real-time alerts to validate data integrity and identify issues
• Schedule and manage dependencies for data jobs using Apache Airflow or Prefect to ensure consistent, reliable data flows
• Build self-healing pipelines that automatically retry failed tasks and scale resources based on demand
• Support CI/CD pipelines for data workloads and ensure protection of proprietary data per standards

Skills

US Citizenship

EOD clearance

Airflow

Prefect

Python

SQL

APIs

Data quality

Education

BS/BA + 15 yrs exp

Tools

Apache Airflow

Prefect

Terraform

CloudFormation

Jenkins

GitHub Actions

Job description

CACI International Inc. in Washington, DC is seeking an Automation Data Integration Administrator to design and maintain automated data pipelines that ingest from APIs, databases, and IoT sources and deliver to data warehouses or lakes.

You will implement ETL/ELT processes, data quality checks, and anomaly detection to ensure reliable data for security operations. The role requires strong Python/SQL skills, familiarity with Airflow or Prefect, and experience building scalable, automated data