Req ID: RQ174972 Type of Requisition: Regular Clearance Level Must Be Able to Obtain: Secret Job Family: Database Analysis/Design Skills: Database Architecture,ETL Processing,Oracle Database Migration,Structured Query Language (SQL) Certifications: Security + – CompTIA Experience: 6 + years of related experience US Citizenship Required: Yes Job Description: Data Engineer NAVSUP OIS – Remote Overview/ Job Responsibilities GDIT is looking for a Data Engineer for the Naval Supply Systems Command (NAVSUP) Ordnance Information System (OIS) to provide 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. This position can be performed remotely; however , approximately 10% travel will be required for client and team meetings 5 times a year in Mechanicsburg, PA or Yorktown, VA. Primary Responsibilities: The Data Engineer will be responsible for the following: 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. Minimum Qualifications: Must have DOD Secret level clearance to start; U.S. Citizen required only for Federal Clearance Requirement Certification Requirements: Directive 8570.1/8140 – IAT II: Baseline Certification: Security+ 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) BA/BS or equivalent experience and 6+ years of prior relevant experience, or a Masters degree with 4+ years of prior relevant experience. Experience with big data technologies such as Apache Hadoop, Spark, Kafka, etc. Familiarity with data warehousing concepts, ETL (Extract, Transform, Load) processes, and tools. Proficiency in SQL and experience with other querying languages. Experience in migration from on-prem data center to public cloud (AWS, Azure) Experience in decomposition of Oracle PL/SQL stored procedures and triggers to migrate to Amazon Aurora DB, Postgres, or MySQL Experience with one or more programming languages like Python, Java, Scala, or Go. Understanding of data modeling, schema design, and database optimization. Knowledge of data security and compliance best practices. 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. Preferred Qualifications: Demonstrated experience in network and cyber security design, engineering and operations with emphasis on Navy capabilities 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 The likely salary range for this position is $120,700 – $163,300. 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. 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. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employees date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.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. We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology. We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nations most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real. GDIT is 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.
data-modeling Go Scala SQL Python Apache Spark AWS Certified Solutions Architect Java data-security Apache Kafka Data Engineering SAFe