[Hiring] Senior Automation Data Integration Administrator @Apolisrises

Role Description

This is a 6 month contract to hire position for a Senior Automation Data Integration Administrator. The role is remote but candidates must be local to the DMV area and willing to go onsite if requested by the client. The position requires an EOD PT clearance, with the ability to obtain and/or maintain a TS/SCI clearance as a condition of employment.

As a Senior Automation Data Integration Administrator, you will play a crucial role in enhancing the efficiency and effectiveness of 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.

• Design, build, and maintain automated data integration pipelines that pull data from multiple sources, including APIs, databases, and IoT systems.
• Develop and support ETL/ELT processes to extract, transform, and load data into enterprise data warehouses and data lakes.
• Monitor data pipelines to ensure data quality, consistency, and accuracy through automated validation, testing, and anomaly detection.
• Troubleshoot and resolve data flow issues, schema changes, and pipeline failures before they impact downstream reporting and analytics.
• Schedule, manage, and optimize data workflows using orchestration tools such as Apache Airflow or Prefect.
• Build resilient, self-healing automation that can automatically recover from failures and scale based on workload demands.
• Create and maintain scripts that identify data anomalies, handle missing data, and ensure sensitive information is properly sanitized and protected.
• Implement CI/CD processes for data pipelines to support reliable deployments and ongoing enhancements.
• Collaborate with technical teams to design integrated data solutions that improve accessibility, performance, and operational efficiency.
• Document data integration processes, workflows, and best practices to support long-term maintainability.
• Ensure all data management activities comply with organizational security, privacy, and governance requirements.
• Continuously evaluate and recommend improvements to data architecture, pipeline performance, and automation capabilities.

Qualifications

• BS/BA and 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.
• 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).