Automation Data Integration Administrator

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

Job summary

CI/CD-enabled Automation Data Integration Administrator at CACI International will design and operate automated data pipelines across APIs, databases, and IoT sources to support FEMA’s cybersecurity operations in Washington, D.C.

You will implement ETL/ELT processes, data quality checks, and real-time alerts while collaborating with cybersecurity professionals and data owners to safeguard mission-critical data and systems.

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.
• 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 data pipelines ingesting data from diverse sources (APIs, databases, IoT) to data warehouses or lakes.
• Automate extraction, transformation, and loading to ensure clean, standardized data for analysis.
• Implement automated tests, anomaly detection, and real-time alerts to validate data integrity.
• Schedule and manage data job dependencies using Apache Airflow or Prefect to ensure reliable data flows.
• Build self-healing pipelines that retry failed tasks and scale resources as needed.
• Input missing values, mask sensitive information, and sanitize data as required.
• Implement CI/CD for data pipelines to ensure safe, consistent code changes.

Skills

Apache Airflow

Prefect

ETL/ELT

APIs

Databases

Data warehousing

Python

SQL

Data quality

Observability

CI/CD

IaC

Cloud platforms

Education

BS/BA with 15 years experience

Tools

Terraform

CloudFormation

Jenkins

GitLab

GitHub Actions

Job description

Job Title: Automation Data Integration Administrator

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: None

Type of Travel: None

* * *

The Opportunity:

CACI is searching for an Automation Data Integration Administrator to support the FEMA Office of the Chief Information Security Officer (OCISO) in Washington, D.C. As an Automation Data Integration Administrator, you will play a crucial role in enhancing the efficiency and effectiveness of FEMA’s cybersecurity operations. You will work in a dynamic environment, collaborating with cybersecurity professionals, data analysts, and system owners to design and implement automated solutions that reduce manual effort and improve risk visibility. Your efforts will directly contribute to safeguarding FEMA’s mission‑critical systems and data through advanced automation and integration. The Automation Data Integration Administrator will be responsible for maintaining cybersecurity automations, connectors, data pipelines, and dashboards that reduce manual effort and improve risk visibility across tools and workflows. This position requires creating and managing end-to-end pipelines ingesting data from diverse sources (APIs, databases, IoT) and delivering data to data warehouses or lakes. The Automation Data Integration Administrator will automate extraction, transformation, and loading processes to ensure data is clean, standardized, and ready for analysis. This role is critical for implementing automated tests, anomaly detection, and real‑time alerts to validate data integrity.

Responsibilities:

The Automation Data Integration Administrator will 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 and building automated data integration solutions. This position requires automating extraction, transformation, and loading processes to ensure data is clean, standardized, and ready for analysis while optimizing data workflows for performance. The Automation Data Integration Administrator will implement automated tests, anomaly detection, and real‑time alerts to validate data integrity and identify issues such as schema drift before they impact downstream systems. Responsibilities include scheduling and managing dependencies for data jobs using Apache Airflow or Prefect to ensure consistent, reliable data flows, as well as building self‑healing pipelines that automatically retry failed tasks and scale resources based on demand to maintain operational resilience. The position involves running automated scripts to detect data anomalies, inputting missing values, and masking sensitive information through sanitization. The Automation Data Integration Administrator will implement continuous integration and deployment of data pipelines to ensure safe and consistent code changes and will design, develop, or recommend integrated system solutions ensuring proprietary and confidential data and systems are protected in accordance with mandated standards.

Qualifications:

Required:

• U.S. Citizenship required
• FEMA EOD suitability or Current DHS or 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

Desired:

• Active Secret security clearance
• Previous DHS or DoD experience
• Experience with Infrastructure as Code (IaC) tools (Terraform, CloudFormation)
• Knowledge of data catalog and metadata management solutions
• Experience with CI/CD pipelines (Jenkins, GitLab, GitHub Actions)
• Familiarity with cloud platforms (AWS, Azure, GCP)
• Cloud security experience with AWS, Azure, or other platforms
• Experience with cybersecurity data sources and GRC tools

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.

The proposed salary range for this position is:

$120,800 - $265,800

CACI is anEqualOpportunity 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 otherprotectedcharacteristic.