Senior Data Engineer

About the role

Swift 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 Database Developer 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

• Designing, developing, and managing database systems, particularly focusing on AWS RDS for PostgreSQL and SQL databases
• Managing data structures and load routines to support application development and support application users
• Working with reporting tools like Power BI
• Developing and interfacing with Application Program Interfaces (APIs), supporting application development teams, and leveraging AWS environments for database and application support

Requirements

• 5+ years of relevant experience
• Demonstrated database experience preferably with PostgreSQL and SQL databases
• Proficiency in working with views, triggers, and stored procedures
• Strong knowledge of SQL scripting, database indexing, and optimization techniques
• Experience in developing and interfacing with APIs
• Experience in developing, creating, and modifying data structures and load routines for business use
• Expertise in working with relational data, including cleansing, transforming, and processing structured data
• Knowledge of Amazon Web Services (AWS) environments
• Experience working within an Agile project management framework
• Proven experience collaborating with diverse teams, including client staff, IT customers, and technical and non-technical stakeholders
• US Citizenship and an active TS/SCI with Polygraph security clearance required

Qualifications

• Experience designing, developing, and deploying AI