Sr. Automation Data Integration Administrator
Apolis
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- AUTOMATION
- DATA INTEGRATION
- CYBERSECURITY
- CYBER SECURITY
- ETL
- ELT
- DATA PIPELINES
- PYTHON
- AIRFLOW
- PREFECT
Summary
Senior Automation Data Integration Administrator
Location: Remote- must be local to DMV area
Onsite expectation: Must be willing to go onsite if client asks
Clearance Level: EOD PT, can hold up to a TS/SCI
Must be able to obtain and/or maintain an EOD Public Trust security clearance as a condition and continuation of employment*
This is with a large federal client. 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.
LCAT:
BS & 15yrs
AS & 18yrs
21 yrs no degree
Project Details / Mission Supported:
- 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.
Qualified candidates will have the following experience and skills:
- 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, Google Cloud Platform)
- Dice Id: 10106862
- Position Id: 26-10519
- Posted 4 hours ago
Company Info
About Apolis
Founded 1996, RJT Compuquest, Inc. is an ERP and IT consulting services provider focused on providing innovative and successful business solutions. We are capable of working across all technology platforms, operating systems and infrastructures. RJT has experience in performing implementations, technical and functional upgrades, optimization projects, and full service staffing.
RJT consultants have real world experience across a broad spectrum of industries and can apply that knowledge to best face your business needs. Our recruiting process selects only the most highly qualified individuals for your project. If we cannot find the best consultant for your project, then we have a large pool of third-party consultants that we recruit from to ensure your business needs are met.
Our consultants have up to twenty years of business experience and an average of more than six years of IT and ERP experience. This means that the project team not only understands how systems work, they also understand how the technology impacts the business processes of organizations. We believe that the success of an engagement is determined by strong project management, as well as clear communication and mutual commitment working collaboratively. Our methodology begins with listening to the customer about their needs, then working with their team to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. The RJT team is committed to this goal.
When you leverage our exceptional recruiting and management capabilities and unparalleled client service skills, you take the most important step toward accomplishing your business goals. As a trusted advisor to companies of all sizes, we make it our business to become a specialized, physical extension of your team. We listen to your goals, assess your needs, and then take the steps necessary to achieve your objectives. Built on long-term, trusted client and employee relationships, RJT strives to consistently and efficiently plan, execute and deliver high quality services and results.
