Senior Data Engineer

The Swift Group, LLC; Herndon (VA); On-site; USD 50,000 - 290,000; Full time

Benefits offered by this job

Healthcare

Wellness benefits

Retirement plan

Education benefits

Time off

Job summary

The Swift Group, LLC seeks a Senior Database Developer in Herndon, VA to design, develop, and manage 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 in an Agile setting.

Responsibilities include designing and managing database systems (AWS RDS for PostgreSQL and SQL databases), optimizing data structures and load routines, and supporting Power BI dashboards.

Qualifications

• 5+ years of relevant experience in database development and data management.
• Demonstrated PostgreSQL and SQL database experience with views, triggers, and stored procedures.
• Proficiency in SQL scripting, indexing, and query optimization.
• Experience developing and interfacing with APIs and data structures/load routines.
• Strong AWS knowledge and Agile project management experience.
• U.S. citizenship with an active TS/SCI clearance with Polygraph.

Responsibilities

• Design, develop, and manage scalable database systems, focusing on AWS RDS for PostgreSQL and SQL databases.
• Manage data structures and load routines to support application development and users.
• Work with Power BI and other reporting tools for analytics and visualization.
• Develop interfaces with APIs and support cross-functional development teams in AWS environments.
• Operate in an Agile project management setting with strong data management focus.

Skills

PostgreSQL

SQL

APIs

Data modeling

AWS

Agile

Security clearance

Tools

Power BI

Jira

Docker

Kubernetes

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 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. 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

Onsite

The Swift Group and Subsidiaries are an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

Pay Range: $49,996.80 - $290,004.00

Pay ranges are a general guideline and not intended as a guaranteed and/or implied final compensation or salary for this job opening. Determination of official compensation or salary relies on several different factors including, but not limited to: level of position, complexity of job responsibilities, geographic location, work experience, education, certifications, Federal Government contract labor categories, and contract wage rates.

At The Swift Group and Subsidiaries, you will receive comprehensive benefits including but not limited to: healthcare, wellness, financial, retirement, education, and time off benefits.