Senior Data Engineer with Security Clearance

Senior Data Engineer The Swift Group is a privately held, mission-driven and employee-focused services and solutions company headquartered in Reston, VA. Our capabilities include Software Development, Engineering & IT, Data Science, Cyber Enablement, Logistics, and Training. Founded in 2019, Swift supports Civilian, Defense, and Intelligence Community customers across the country and around the globe. We are looking for a skilled Senior Data Engineer to join our dynamic team.

In this role, you will be responsible for designing, developing, and managing scalable data pipelines and infrastructure, with a focus on AWS cloud services. You will collaborate with cross-functional teams to support data-driven applications and analytics, ensuring efficient data flow and accessibility. The ideal candidate will thrive in an Agile project management setting and possess a strong background in data management and processing. The position is in Herndon, VA.

Responsibilities:

• Design and implement robust data pipelines and ETL processes to ingest, transform, and load data from diverse sources into data warehouses
• Develop and maintain data models and schemas to support analytics and reporting needs
• Collaborate with software engineers, data scientists, and analysts to integrate data solutions into applications and workflows
• Optimize data storage and retrieval for performance and scalability
• Ensure data quality and integrity through validation, testing, and monitoring
• Implement data security and compliance measures in accordance with organizational policies
• Utilize AWS services such as S3 and RDS for data storage and processing
• Develop APIs and interfaces to facilitate data access and integration
• Participate in Agile development processes, contributing to sprint planning and reviews
• Document data engineering processes, architectures, and best practices Requirements:
• 5+ years of experience in data engineering, software development, or related fields.
• Strong experience with SQL and relational databases, particularly PostgreSQL
• Expertise with SQL scripting, database indexing, and optimization techniques
• Proficient in working with views, triggers, and stored procedures
• Experience in developing, creating, and modifying data structures and load routines for business use
• Hands-on experience with AWS data services (e.g., S3, RDS, Glue, Redshift)
• Familiarity with data modeling, ETL development, and data warehousing concepts
• Experience with API development and integration
• Knowledge of data security and compliance standards
• Ability to work collaboratively in a team environment and communicate effectively with stakeholders
• US Citizenship and an active TS/SCI with Polygraph security clearance required Desired Experience:
• Experience with AWS Cloud Data Migration Services
• Familiarity with Jira for project tracking and management
• Familiarity with containerization and orchestration tools like Docker and Kubernetes
• Knowledge of infrastructure-as-code tools such as Terraform or CloudFormation
• Experience with data visualization tools like Power BI or Tableau
• AWS certifications related to data engineering or architecture Do you know anyone for this position, or other positions open at The Swift Group? We offer a $5,000 bonus for any referral candidate we hire, paid out at the new hire's 90-day mark.