Data Engineer

General Dynamics Information Technology offers a mission-driven environment with strong growth opportunities for experienced data engineers. You will contribute to mission-critical government programs by designing and maintaining robust data architectures in AWS GovCloud, on-site in Mechanicsburg, PA or in Yorktown, VA.

Benefits

• Growth opportunities with an AI powered career tool that helps map learning paths and future steps
• Internal mobility team dedicated to helping you achieve your career goals
• Comprehensive benefits and wellness packages, 401(k) with company match, competitive pay and paid time off
• A culture of innovation and a military friendly workplace

Responsibilities

• Collaborate with a team of data and cloud architects, engineers, and administrators to design, build, deploy, and maintain data architectures and databases on the AWS GovCloud platform
• Create and sustain high performance, scalable data architectures for OIS, including databases and large-scale processing systems; migrate on-premises data to cloud based solutions and transform data as required
• Design and maintain scalable data pipelines and integrate new APIs, ensuring pipelines are repeatable, scalable, and secure
• Implement and manage databases and data delivery systems to convert data into insights, analysis, and reporting
• Identify and develop solutions that modernize the development environment to meet business needs and industry best practices
• Implement ETL routines for data extraction, loading, and database synchronization
• Establish data governance and quality controls and monitor ETL/ELT jobs to maintain performance and address issues
• Improve system performance through testing, troubleshooting, and integration of new components while upholding confidentiality and privacy requirements
• Collaborate with data scientists, architects, and stakeholders to ensure the data infrastructure supports required functions and performance metrics
• Design and document data models and the logical and conceptual relationships of data and database changes
• Document data architectures and systems for technical and non-technical audiences
• Lead technical planning, system integration, verification and validation, and cost and risk assessments

Requirements

• Active Top Secret clearance
• 10+ years of data engineering experience
• Experience implementing data warehousing concepts, ETL processes and tools such as Pentaho
• Experience developing and administering PostgreSQL
• Strong SQL proficiency and experience with additional querying languages
• Experience migrating Oracle PL/SQL stored procedures and triggers to Amazon Aurora DB, PostgreSQL, or MySQL
• Hands-on expertise in data modeling, schema design, and database optimization in production environments
• Knowledge of data security and compliance best practices
• Experience with GitLab, Liquibase, and CI/CD pipelines preferred
• Experience with big data technologies such as Hadoop, Spark, Kafka, Debezium, RabbitMQ
• Background in network and cyber security design, engineering and operations with emphasis on Navy capabilities; prior Navy experience
• Experience with cloud data services (AWS, Azure, GCP) and Cloud Relational Database Services (AWS RDS, Aurora)
• SAFe knowledge and experience
• Experience with data warehousing and BI tools such as RedShift, MicroStrategy, Erwin Data Modeler
• Programming experience in Python, Java, Scala, or Go
• Excellent communication skills for interaction with technical and non-technical stakeholders
• Self-starter with the ability to work independently
• 8570/8140 IAT II CompTIA Security+ CE
• Cloud certification such as AWS Solutions Architect or AWS Data Engineer, or Oracle Database Certified Associate; highly preferred or must be obtained within 3 months of start
• Work location: Mechanicsburg, PA or Yorktown, VA; US citizenship required
• Travel: Less than 10%

Technologies

• AWS GovCloud, AWS RDS, Aurora DB, RedShift
• PostgreSQL, PostgreSQL variants, Oracle PL/SQL, MySQL
• SQL and other querying languages
• Amazon Aurora DB, AWS, Azure, GCP
• BI and modeling tools: MicroStrategy, Erwin Data Modeler
• Programming: Python, Java, Scala, Go
• GitLab, Liquibase, CI/CD
• Big data: Hadoop, Spark, Kafka, Debezium, RabbitMQ