Senior Data Engineer

the-swift-group; Herndon (VA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Referral bonus

Job summary

The Swift Group in Herndon, VA, seeks a Senior Database Developer to design, develop, and manage scalable data pipelines and infrastructure with a focus on AWS, PostgreSQL, and SQL databases. You will collaborate with cross-functional teams in an Agile setting to support data-driven applications.

Key responsibilities include API development, data loading, and leveraging Power BI for reporting, with a strong emphasis on relational data management and optimization.

Qualifications

• 5+ years of relevant database experience, preferably PostgreSQL and SQL databases.
• Proficiency with views, triggers, and stored procedures.
• Strong SQL scripting, indexing, and optimization knowledge.
• Experience developing and interfacing with APIs.
• Experience loading and transforming structured data for business use.
• Familiar with AWS environments.
• Experienced in an Agile project management environment.
• Collaborates with diverse stakeholders including client staff.

Responsibilities

• Designing, developing, and managing database systems focusing on AWS RDS for PostgreSQL and SQL databases.
• Managing data structures and load routines to support application development and users.
• Working with reporting tools like Power BI.
• Developing and interfacing with APIs, supporting application teams in AWS environments.
• Thrives in an Agile project management setting and strong background in data management and processing.

Skills

SQL scripting

Agile

Data modeling

API development

Collaboration

Relational data

Tools

PostgreSQL

Power BI

AWS

Job description

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
• The ideal candidate will thrive in an Agile project management setting and possess a strong background in data management and processing

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

Desired Experience:

• Experience designing, developing, and deploying AI and Generative AI models and algorithms
• Experience collaborating with cross-functional teams to identify and solve business challenges using AI technologies
• Researching and staying up-to-date with the latest advancements in AI and GenAI
• 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.

We are not working with outside staffing agencies to fill this position, and we will not be accepting unsolicited resumes. All inquiries must go through the recruiting team.

#LI-VM1

#Onsite