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
