Junior Data Engineer (ETL/Data Quality)

Peraton; USA; Remote; USD 66.000 - 106.000; Vollzeit

Benefits dieser Stelle

Medical, dental, vision benefits

401(k) with company match

PTO and paid holidays

EAP and parental leave

Zusammenfassung

Peraton is seeking a Junior Data Engineer to support ETL pipeline implementation, data quality validation, and database operations on a federal data migration program. This fully remote position requires US citizenship and the ability to obtain a Public Trust clearance.

You will collaborate with the Database Engineer SME to implement transformation logic, run ingestion workflows, document defects, and help ensure data quality and security compliance across the migration lifecycle.

Qualifikationen

• Bachelor’s degree and 2 years of professional experience, or a Master’s degree and 0 years of professional experience, or a high school diploma and 6 years of professional experience.
• U.S. Citizenship required; must have the ability to obtain and maintain a Public Trust clearance; all work must be performed within the United States.
• 1+ years of database engineering experience with hands-on ETL development experience.
• Experience with Databricks, Delta Live Tables, or equivalent cloud ETL frameworks.
• Proficiency in SQL and at least one scripting language (Python, Scala, or equivalent).
• Experience with data quality validation, RBAC configuration, and database performance testing.
• Experience documenting prototype ingestion results and defect remediation findings.
• Familiarity with FIPS 140 encryption requirements and NIST SP 800-171 database security controls.
• Familiarity with federal data governance and security standards.

Aufgaben

• Support the Database Engineer SME in implementing ETL pipeline transformation logic, data quality checks, and schema validation rules
• Execute prototype data ingestion workflows, running representative data through ETL pipelines and evaluating results against quality criteria
• Document data quality defects in the Defect and Risk Log, including severity classification, root cause analysis, and remediation recommendations
• Support the Prototype Ingest Results Report by documenting database-layer ingestion outcomes, data quality defects, severity classifications, and remediation recommendations for each prototype ingestion cycle
• Populate and maintain the Metadata and Authoritative Source Registry, researching and documenting data source attributes, refresh cadences, and data stewardship contacts
• Support database performance testing prior to production cutover, executing query performance benchmarks and identifying optimization opportunities
• Implement and validate RBAC configurations on all database objects
• Support interoperability testing by providing test datasets, executing database-layer test cases, and documenting results
• Maintain all database scripts and pipeline code in the version‑controlled repository
• Support post‑migration data validation during production cutover

Kenntnisse

SQL

ETL development

Databricks/Delta Live Tables

Python/Scala

RBAC configuration

Data quality validation

Database performance testing

Ausbildung

Bachelor’s degree

Master’s degree

Tools

Databricks

Delta Live Tables

Jobbeschreibung

About Peraton

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees solve the most daunting challenges that our customers face. Visit peraton.com to learn how we"re keeping people around the world safe and secure.

Program Overview

The program is an IDIQ contract for an AWS-based cloud hosting system. Currently, Peraton is supporting the Cloud Security, IoT, and AIML use cases for the environment in a hybrid work environment with Federal employees. Peraton also supports the following applications as part of the environment: Dremio, Tableau, Globus, Posit/RStudio, Atlassian, ThingLogix, Alteryx and CloudCheckr.

About The Role

Peraton is seeking a Junior Data Engineer to support ETL pipeline implementation, data quality validation, and database operations on a federal data migration program. You will work closely with the Database Engineer SME to implement transformation logic, execute ingestion workflows, and support production migration activities. This is a fully remote position.

The Department of the Interior (DOI), U.S. Fish and Wildlife Service (FWS), and NOAA’s National Marine Fisheries Service (NMFS) have identified a critical gap in the federal government’s ability to conduct comprehensive Endangered Species Act (ESA) research. While FWS operates an authoritative web-based platform for managing data for terrestrial and freshwater species, it does not currently include NMFS marine and anadromous species data forcing agencies to rely on separate, manual processes. This program closes that gap by integrating marine and anadromous species data into the existing FWS platform, creating a single, unified experience for all ESA‑listed species.

Work Location

Remote

Day to Day Work Responsibilities

• Support the Database Engineer SME in implementing ETL pipeline transformation logic, data quality checks, and schema validation rules
• Execute prototype data ingestion workflows, running representative data through ETL pipelines and evaluating results against quality criteria
• Document data quality defects in the Defect and Risk Log, including severity classification, root cause analysis, and remediation recommendations
• Support the Prototype Ingest Results Report by documenting database-layer ingestion outcomes, data quality defects, severity classifications, and remediation recommendations for each prototype ingestion cycle
• Populate and maintain the Metadata and Authoritative Source Registry, researching and documenting data source attributes, refresh cadences, and data stewardship contacts
• Support database performance testing prior to production cutover, executing query performance benchmarks and identifying optimization opportunities
• Implement and validate RBAC configurations on all database objects
• Support interoperability testing by providing test datasets, executing database-layer test cases, and documenting results
• Maintain all database scripts and pipeline code in the version‑controlled repository
• Support post‑migration data validation during production cutover

Qualifications

Basic Qualifications

• Bachelor’s degree and 2 years of professional experience, or a Master’s degree and 0 years of professional experience, or a high school diploma and 6 years of professional experience.
• U.S. Citizenship required; must have the ability to obtain and maintain a Public Trust clearance; all work must be performed within the United States.
• 1+ years of database engineering experience with hands‑on ETL development experience.
• Experience with Databricks, Delta Live Tables, or equivalent cloud ETL frameworks.
• Proficiency in SQL and at least one scripting language (Python, Scala, or equivalent).
• Experience with data quality validation, RBAC configuration, and database performance testing.
• Experience documenting prototype ingestion results and defect remediation findings.
• Familiarity with FIPS 140 encryption requirements and NIST SP 800-171 database security controls.
• Familiarity with federal data governance and security standards.

Preferred Qualifications

• Experience with AWS GovCloud or equivalent FedRAMP-authorized cloud environments.
• AWS Certified Cloud Practitioner or AWS Certified Database Specialty certification.
• Familiarity with NIST SP 800-171 database security controls.
• Experience supporting federal data migration programs.
• Databricks Associate certification or equivalent.

Details

Target Salary Range: $66,000 - $106,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

Benefits Statement: Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at https://www.careers.peraton.com/benefits.

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.