Junior Data Engineer (ETL/GIS)

About the Role

Peraton is seeking a Junior Data Engineer with ETL development and geospatial data experience to support the data engineering workstream on a federal data migration program. This is a fully remote position.

Key Responsibilities

• Develop, test, and deploy ETL pipelines using Databricks Delta Live Tables within a cloud data lakehouse staging environment.
• Execute range data aggregation and normalization activities, collecting data from multiple authoritative source systems and normalizing spatial formats and coordinate reference systems.
• Implement source-to-target transformation logic within ETL pipelines, applying field-level mapping rules, data type conversions, and null-handling logic.
• Execute prototype data ingestion workflows using representative taxa, evaluating results against completeness, accuracy, consistency, and spatial integrity quality criteria.
• Document prototype ingestion results, defects, and remediation actions.
• Produce the Prototype Ingest Results Report, documenting ingestion outcomes, data quality findings, defect severity classifications, and remediation actions for each representative taxa batch.
• Log all data quality defects with severity classifications and remediation tracking.
• Maintain all ETL pipeline code in a version-controlled repository with mandatory peer review documentation.
• Support spatial data validation activities in coordination with GIS Engineers.
• Support interoperability testing by providing test datasets, pipeline execution support, and data validation assistance.

Requirements & Tech Stack

• Hands-on experience with Databricks and Delta Live Tables or equivalent cloud ETL frameworks.
• Experience with data quality validation, source-to-target mapping, and data transformation.
• Experience with data modeling or schema design documentation.
• Experience documenting test/ingest results and logging defects with severity classifications.
• Proficiency in Python or Scala for ETL pipeline development.
• Proficiency in SQL for querying, validating, and transforming data within the cloud data lakehouse environment.
• Familiarity with geospatial data formats and coordinate reference systems.
• Experience with AWS GovCloud or equivalent FedRAMP-authorized cloud environments (Preferred).
• Familiarity with GIS tools such as ArcGIS or QGIS (Preferred).
• Experience with federal data governance and metadata standards (Preferred).

Qualifications

• Bachelor's degree and 0 years of professional experience, OR an Associate's degree and 2 years of professional experience, OR a high school diploma/equivalent and 4 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.
• Databricks Associate certification or equivalent (Preferred).