Data Engineer

Entarian

$110K — $130K *
Aerospace & Defense
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • DOD Secret clearance required; Top Secret preferred.
  • Security+ certification required; AWS or Oracle certifications preferred.
  • BA/BS in Engineering, Computer Science, or related with 10 years relevant experience or Master's with 8 years relevant experience.
  • Experience in ETL processes and data warehousing concepts.
  • Proficient in SQL and experience with PostgreSQL administration.
  • Hands-on expertise in data modeling and database optimization.
  • Excellent communication skills for technical and non-technical interaction.

Responsibilities

  • Develop and maintain high-performance data architectures for OIS and migrate data to cloud solutions.
  • Create scalable data pipelines and build new API integrations.
  • Manage databases and transform them into actionable insights.
  • Design solutions to enhance the development environment.
  • Implement data extraction, load routines, and maintain ETL processes.
  • Ensure data governance and quality controls are in place.
  • Collaborate with stakeholders on infrastructure performance needs.

Benefits

  • Work in a secured area on-site five days a week in Mechanicsburg, PA, or Yorktown, VA.
  • Collaborative environment with a focus on mission-critical programs.
  • Opportunity to develop and enhance cloud-based data solutions.
  • Engagement with cutting-edge technologies and data methodologies.
Full Job Description
Overview/ Job Responsibilities

Entarian 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 is on-site in a secured space 5 days/week and can be filled in either 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 (with willingness and ability for T3 upgrade to T5 background investigation); 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; if not, must obtain within 3 months of start)
  • BA/BS (in Engineering, Computer Science or related field) or equivalent experience and 10+ years of prior relevant experience or master's with 8+ years or prior relevant 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.
  • 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.


Desired Qualifications

  • Highly preferred DOD Top Secret level clearance to start (fully adjudicated T5 background investigation)
  • 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
  • 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.


Join the Mission and Start your Career Journey: Apply Directly via our Careers Portal Connect,Referrals & Inquiries? Email the team: [email protected]

Similar Jobs

More Jobs at Entarian

  • MLOps Engineer
    $120K — $145K *
    Arlington, VA 22204 (Arlington County)
    Information Technology
    In-Person
  • Data Engineer
    $110K — $130K *
    Mechanicsburg, PA 17055 (Cumberland County)
    Aerospace & Defense
    In-Person
  • Audio Visual Engineer
    $120K — $135K *
    Remote
    Aerospace & Defense
    Remote in United States
  • Sr Cybersecurity ISSO
    $110K — $130K *
    Denver, CO 80219 (Denver County)
    Aerospace & Defense
    In-Person
  • NOC Technician
    $85K — $95K *
    Colorado Springs, CO 80918 (El Paso County)
    Information Technology
    In-Person

More Aerospace & Defense Jobs

Find similar Data Engineer jobs: