Data Engineer

The Data Engineer will design, build, deploy, and maintain data architectures, pipelines, and databases within the AWS GovCloud environment to support mission-critical government programs.

Location

Mechanicsburg, PA (onsite)

Compensation

USD 129,813 - 166,750 per yearly

Role Overview

Working within a multidisciplinary team of Data and Cloud Architects, Engineers, and Administrators, this role focuses on creating, deploying, and sustaining robust data architectures and databases in the AWS GovCloud setting to meet government program requirements.

Responsibilities

• Collaborate with a team of data and cloud professionals to design, build, deploy, and maintain data architectures and databases in AWS GovCloud.
• Develop, test, and maintain high performance, scalable data architectures and large-scale processing systems, migrate data from on-premises databases to cloud-based solutions, and transform data as needed.
• Build and maintain scalable data pipelines and API integrations, ensuring pipelines are scalable, repeatable, and secure.
• Deploy and manage databases and data delivery systems and translate them into insights, analysis, and reporting.
• Identify and promote solutions that enhance the modern development environment to align with business needs and industry best practices.
• Implement data extraction, load, and synchronization routines and ETL processes.
• Establish data governance and quality controls and monitor ETL/ELT jobs to maintain performance and address issues promptly.
• Improve system performance through testing, troubleshooting, and integration of new components while ensuring confidentiality and privacy requirements are met.
• Collaborate with data scientists, architects, and stakeholders to ensure the data infrastructure supports required functions and performance metrics.
• Design, model, document, and manage the logical and conceptual relationships of data and database changes.
• Document data architecture and systems for both technical teams and non-technical stakeholders.
• Conduct technical planning, system integration, verification and validation, and cost and risk assessments.

Requirements

• Security Clearance Level: Active Top Secret clearance
• Experience: 10+ years of prior data engineering experience
• Experience implementing data warehousing concepts, ETL processes and tools (for example, Pentaho)
• Experience developing and administrating in PostreSQL
• Strong proficiency in SQL and experience with other querying languages
• Experience in decomposing Oracle PL/SQL stored procedures and triggers to migrate to Amazon Aurora DB, Postgres, or MySQL
• Hands-on expertise in data modeling, schema design, and database optimization for production environments
• Knowledge of data security and compliance best practices
• Experience with GitLab, Liquibase, and CI/CD pipelines is highly preferred
• Experience with big data technologies such as Apache Hadoop, Spark, Kafka, Debezium, or RabbitMQ
• Demonstrated experience 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)
• Experience with Cloud Relational Database Services (AWS RDS, Aurora DB)
• SAFe experience and knowledge
• Experience with data warehousing and BI tools such as RedShift, MicroStrategy, Erwin Data Modeler, etc.
• Experience with one or more programming languages such as Python, Java, Scala, or Go
• Excellent verbal and written communication skills for interaction with technical and non-technical stakeholders
• Self-starter with the ability to work independently with minimal supervision
• 8570/8140 IAT II CompTIA Security+ CE
• Computing Environment Certification: AWS Certified Solutions Architect or AWS Certified Data Engineer or similar cloud certification, or Oracle Database Certified Associate or equivalent (highly preferred to have at start; if not, must obtain within 3 months of start)
• Work Location: Mechanicsburg, PA or Yorktown, VA
• U.S. Citizenship Required

Technologies

• AWS GovCloud
• Pentaho
• PostreSQL
• Postgres
• SQL
• Oracle PL/SQL
• Amazon Aurora DB
• MySQL
• AWS
• Azure
• GCP
• AWS RDS
• Aurora DB
• RedShift
• MicroStrategy
• Erwin Data Modeler
• Python
• Java
• Scala
• Go
• GitLab
• Liquibase
• CI/CD
• Apache Hadoop
• Spark
• Kafka
• Debezium
• RabbitMQ

Benefits

• Growth: AI-powered career tool that identifies career steps and learning opportunities
• Support: An internal mobility team focused on helping you achieve your career goals
• Rewards: Comprehensive benefits and wellness packages, 401K with company match, and competitive pay and paid time off
• Community: Award-winning culture of innovation and a military-friendly workplace

Work Requirements

• 10+ years of related experience
• May vary based on technical training, certification(s), or degree
• CompTIA Security+ CE
• AWS Certified Solutions Architect - Associate or AWS Certified Data Engineer, or similar cloud certification
• Less than 10%
• U.S. Citizenship Required