Design, implement, and maintain data pipelines and ETL processes supporting ingestion, transformation, and validation of mission data.
Develop and optimize data models and schemas across relational and non-relational databases to support system integrations and analytics.
Collaborate with system architects, integration developers, and data analysts to ensure data consistency, security, and integrity across cloud environments.
Implement data migration and synchronization between legacy systems, applications, and modern cloud platforms.
Utilize AWS services (Glue, Lambda, S3, RDS, Redshift, Kinesis) to build and sustain scalable and fault-tolerant data infrastructure.
Support data validation and reconciliation, performing quality checks and developing reports to ensure accuracy.
Integrate data from APIs, streaming sources, and file-based systems into centralized repositories or data lakes.
Automate data workflows using infrastructure-as-code and CI/CD principles to ensure repeatability and efficiency.
Monitor and troubleshoot data pipeline performance, ensuring adherence to SLAs and operational reliability.
Implement data encryption, masking, and access controls in compliance with DoD cybersecurity policies and RMF requirements.
Support development of dashboards and analytics products, enabling data-driven insights for mission stakeholders.
Maintain documentation and metadata repositories, including data dictionaries, lineage, and technical specifications.
Participate in Agile sprints, contributing to backlog refinement, testing, and cross-functional collaboration.
Requirements
Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
Minimum 5 years of experience in data engineering, integration, or analytics enablement.
Experience building and optimizing data pipelines in enterprise or federal environments.
Familiarity with Agile software development and DevSecOps delivery frameworks.
Proficiency with Python, SQL, and ETL frameworks (e.g., Apache NiFi, Talend, or AWS Glue).
Experience with cloud data services, preferably AWS GovCloud (RDS, S3, Lambda, Glue, Redshift).
Knowledge of database management systems (PostgreSQL, SQL Server, DynamoDB, MongoDB).
Familiarity with RESTful API integration and data exchange standards (JSON, XML, CSV).
Understanding of DoD data security and compliance standards, including encryption, RMF, and STIG adherence.
Experience developing and maintaining data validation, profiling, and transformation scripts.
Exposure to data visualization and analytics tools (Power BI, Tableau, QuickSight).
Benefits
Must hold an active Top Secret clearance.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data pipelinesETL processesdata modelsdata schemasdata migrationdata validationinfrastructure-as-codeCI/CD principlesdata encryptiondata profiling