Automation Data Integration Engineer

UltraViolet Cyber; Washington; On-site; USD 90,000 - 110,000; Full time

Benefits offered by this job

401(k) matching

Medical, Dental, Vision

DTO Program

11 Paid Holidays

Job summary

UltraViolet Cyber in Washington, DC is seeking an Automation Data Integration Engineer to advance DHS cyber operations. You will design and maintain automations, data pipelines, and dashboards that reduce manual effort and improve risk visibility across tools and workflows, partnering with cybersecurity professionals and data analysts to safeguard mission-critical systems.

This role requires end-to-end pipeline work from APIs, databases, and IoT to data warehouses or lakes; you will implement

Qualifications

• US citizenship with active Secret clearance is required.
• DHS EOD suitability or current DHS suitability preferred.
• BS/BA + 8 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

• Design and maintain cybersecurity automations, data pipelines, and dashboards that reduce manual effort and improve risk visibility across tools and workflows.
• Perform Data Pipeline Automation by creating and managing end-to-end pipelines that ingest data from diverse sources (APIs, databases, IoT) and deliver it to data warehouses or lakes.
• Perform ETL/ELT Optimization by automating the extraction, transformation, and loading process to ensure data is clean, standardized, and ready for analysis.
• Perform Data Quality & Observability by implementing automated tests, anomaly detection, and real-time alerts to validate data integrity and identify issues.
• Perform Workflow Orchestration by scheduling and managing dependencies for data jobs using tools like Apache Airflow or Prefect.
• Perform System Reliability & Maintenance by building self-healing pipelines that can automatically retry failed tasks and scale resources based on demand.
• Perform Data Cleansing & Validation by running automated scripts to detect data anomalies, impute missing values, or mask sensitive information.
• Perform CI/CD Integration by implementing continuous integration and deployment for data pipelines.

Skills

Python

SQL

Apache Airflow

Prefect

ETL/ELT

APIs

Data quality

Education

BS/BA in a related field

Tools

Terraform

CloudFormation

Jenkins

GitHub Actions

Job description

Make a difference here.

UltraViolet Cyber is a leading platform-enabled unified security operations company providing a comprehensive suite of security operations solutions. Founded and operated by security practitioners with decades of experience, the UltraViolet Cyber security-as-code platform combines technology innovation and human expertise to make advanced real-time cybersecurity accessible for all organizations by eliminating risks of separate red and blue teams.

By creating continuously optimized identification, detection, and resilience from today’s dynamic threat landscape, UltraViolet Cyber provides both managed and custom-tailored unified security operations solutions to the Fortune 500, Federal Government, and Commercial clients. UltraViolet Cyber is headquartered in McLean, Virginia, with global offices across the U.S. and in India.

UltraViolet Cyber (UVC) is searching for an Automation Data Integration Engineer to support DHS in Washington, D.C. As an Automation Data Integration Engineer, you will play a crucial role in enhancing the efficiency and effectiveness of DHS’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 DHS’s mission-critical systems and data through advanced automation and integration. The Automation Data Integration Engineer 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 Engineer 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.

$90,000 - $110,000 a year

What You’ll Do:

• Design and maintain cybersecurity automations, connectors, data pipelines, and dashboards that reduce manual effort and improve risk visibility across tools and workflows.
• Perform Data Pipeline Automation by creating and managing end-to-end pipelines that ingest data from diverse sources (APIs, databases, IoT) and deliver it to data warehouses or lakes.
• Perform ETL/ELT Optimization by automating the extraction, transformation, and loading process to ensure data is clean, standardized, and ready for analysis.
• Perform Data Quality & Observability by implementing automated tests, anomaly detection, and real-time alerts to validate data integrity and identify issues.
• Perform Workflow Orchestration by scheduling and managing dependencies for data jobs using tools like Apache Airflow or Prefect.
• Perform System Reliability & Maintenance by building self-healing pipelines that can automatically retry failed tasks and scale resources based on demand.
• Perform Data Cleansing & Validation by running automated scripts to detect data anomalies, impute missing values, or mask sensitive information.
• Perform CI/CD Integration by implementing continuous integration and deployment for data pipelines.

What You Have:

• U.S. Citizenship required with Active Secret Security Clearance
• DHS EOD suitability or Current DHS or DHS EOD preferred
• BS/BA + 8 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:

• Previous DHS or DoD experience with classified systems
• 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

What We Offer:

• 401(k), including an employer match of 100% of the first 3% contributed and 50% of the next 2% contributed
• Medical, Dental, and Vision Insurance (available on the 1st day of the month following your first day of employment)
• Group Term Life, Short-Term Disability, Long-Term Disability
• Voluntary Life, Hospital Indemnity, Accident, and/or Critical Illness
• Participation in the Discretionary Time Off (DTO) Program
• 11 Paid Holidays Annually

UltraViolet Cyber maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect our company’s differing products, services, industries and lines of business. Candidates are typically placed into the range based on the preceding factors.

We sincerely thank all applicants in advance for submitting their interest in this position. We know your time is valuable.

UltraViolet Cyber welcomes and encourages diversity in the workplace regardless of race, gender, religion, age, sexual orientation, gender identity, disability, or veteran status.

If you want to make an impact, UltraViolet Cyber is the place for you!