Automation Data Pipelines Engineer

CACI; Washington; On-site; USD 121,000 - 266,000; Full time

Benefits offered by this job

Flexible time off

Learning resources

Job summary

CACI is seeking an Automation Data Integration Administrator to support FEMA OCISO in Washington, DC. You will design and implement automated data pipelines, integrate diverse sources, and deliver clean, analytics-ready data to data warehouses.

Join a cybersecurity-focused team delivering real-time alerts, data quality assurances, and scalable automation. Requires Python/SQL, ETL/ELT expertise, and Airflow/Prefect experience; U.S. citizenship is required.

Qualifications

• U.S. Citizenship required.
• FEMA EOD suitability or DHS/FEMA EOD preferred.
• BS/BA + 15 years of applicable experience in data integration and automation.
• 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.

Responsibilities

• Create and manage end-to-end pipelines ingesting data from APIs, databases, and IoT to data warehouses or lakes.
• Automate extraction, transformation, and loading processes for clean, standardized data.
• Implement automated tests, anomaly detection, and real-time alerts to validate data integrity.
• Schedule and manage data jobs using Apache Airflow or Prefect; build self-healing pipelines.
• Run automated scripts to detect data anomalies and mask sensitive information via sanitization.
• Implement CI/CD for data pipelines and design integrated system solutions to protect data.

Skills

Python

SQL

APIs

Education

BS/BA + 15 years experience in data integration and automation

Tools

Apache Airflow

Prefect

Terraform

CloudFormation

Jenkins

GitLab

GitHub Actions

Job description

CACI is seeking an Automation Data Integration Administrator to support FEMA OCISO in Washington, DC. You will design and implement automated data pipelines, integrate diverse sources, and deliver clean, analytics-ready data to data warehouses.

Join a cybersecurity-focused team delivering real-time alerts, data quality assurances, and scalable automation. Requires Python/SQL, ETL/ELT expertise, and Airflow/Prefect experience; U.S. citizenship is required.