Data Engineer | Active Top Secret clearance

Data Engineer

Transform technology into opportunity as a Data Engineer at GDIT. Shape what's next for mission-critical government projects while shaping what's next for your engineering career. Meaningful work and personal impact as a Data Engineer, the work you'll do at GDIT will be impactful by providing technical expertise on a mission-critical program whose purpose is to develop, modernize, enhance, operate, and maintain services for OIS mission critical systems.

As Data Engineer you will work on a team consisting of Data and Cloud Architects, Engineers, and Administrators and focus on designing, building, deploying, and maintaining data architectures and databases in the AWS GovCloud environment.

Develop, construct, test, and maintain high performance, scalable, and stable data architectures for OIS, such as databases and large-scale processing systems, and migrate data from on-premises databases to cloud-based solutions, transforming the data as required.

Develop and maintain scalable data pipelines and build out new API integrations, ensure that data pipelines are scalable, repeatable, and secure.

Implement and manage databases and data delivery systems and transform them into insights, analysis, and reporting.

Identify, research, design, develop, and promote solutions that enhance the modern development environment to ensure systems meet business requirements and industry best practices.

Implement the data extraction, data load, and database synchronization routines and functions ETL.

Implement data governance and quality controls and monitor ETL/ELT jobs to ensure performance and halt any potential issues.

Improve system performance by conducting tests, troubleshooting, and integrating new elements and ensure all data platform solutions adhere to confidentiality and privacy requirements.

Collaborate with data scientists, architects, and other stakeholders to ensure that the data infrastructure supports required functions and performance metrics.

Design, model, document, and guide the logical and conceptual relationship of data and database changes.

Document data architecture and systems for both technical teams and non-technical stakeholders.

Perform technical planning, system integration, verification and validation, cost and risk assessments.

What you'll need to succeed bring your engineering expertise along with a drive for innovation to GDIT. Our Data Engineer must have:

• Security Clearance Level: Active Top Secret clearance
• Experience: 10+ years of prior Data engineering experience
• Experience with implementing data warehousing concepts, ETL (Extract, Transform, Load) processes, and tools (e.g., Pentaho)
• Experience with developing and administrating in PostreSQL
• Strong proficiency in SQL and experience with other querying languages.
• Experience in decomposition of Oracle PL/SQL stored procedures and triggers to migrate to Amazon Aurora DB, Postgres, or MySQL
• Proven, hands-on expertise in data modeling, schema design, and database optimization, with the ability to design, implement, and optimize complex data structures in production environments.
• Knowledge of data security and compliance best practices.
• Experience with GitLab, Liquibase, CI/CD pipelines highly preferred
• Experience with big data technologies such as Apache Hadoop, Spark, Kafka, Debezium, RabbitMQ, etc.
• Demonstrated experience in network and cyber security design, engineering and operations with emphasis on Navy capabilities
• Prior Navy experience.
• Experience with cloud data services (e.g., AWS, Azure, GCP)
• Experience with Cloud Relational Database Services (e.g, AWS RDS, Aurora DB)
• SAFe experience and knowledge
• Experience with Data warehousing and Business Intelligence tools such as RedShift, MicroStrategy, Erwin Data Modeler, etc.
• Experience with one or more programming languages like Python, Java, Scala, or Go.
• Excellent verbal and written communication skills, with the ability to interact effectively with technical and non-technical stakeholders.
• Must be a self-starter and have the ability to work independently with little supervision.
• Certification Requirements:
• 8570/8140 - IAT II CompTIA Security+ CE.
• Computing Environment Certification: AWS Certified Solutions Architect or AWS Certified Data Engineer or similar equivalent Cloud environment certification or Oracle Database Certified Associate or equivalent Database Certification (highly preferred to have in hand upon applying; if not, must obtain within 3 months of start)
• Work Location: Mechanicsburg, PA or Yorktown, VA.
• US Citizenship Required

GDIT IS YOUR PLACE At GDIT, the mission is our purpose, and our people are at the center of everything we do.

• 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

Own your opportunity explore a career in software development at GDIT and you'll find endless opportunities to grow alongside colleagues who share your dedication to advancing innovation. The likely salary range for this position is $129,813 - $149,500. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range. Scheduled weekly hours: 40 travel required: less than 10% telecommuting options: onsite work location: USA VA Yorktown additional work locations: USA PA Mechanicsburg total rewards at GDIT: Our benefits package for all US-based employees includes a variety of medical plan options, some with health savings accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our total rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most. Our identity verification process: As part of the hiring process, we will ask you to complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. You are expected to be on camera during virtual interviews. We reserve the right to take your picture to verify your identity and prevent fraud. By proceeding, you authorize the collection, processing, and use of your biometric data for identity verification and security purposes.