Remote ETL & GIS Data Engineer (Junior)

Peraton; Herndon (VA); Remoto; USD 51.000 - 82.000; Tempo pieno

Descrizione del lavoro

Peraton is seeking a Junior Data Engineer (ETL/GIS) to support a federal data migration program in a fully remote US-based role. You will build and test ETL pipelines, perform data normalization across spatial data formats, and ensure data quality in a cloud lakehouse environment.

The position requires Databricks experience, Python/Scala proficiency, SQL skills, and knowledge of geospatial data concepts. U.S. citizenship and the ability to obtain a Public Trust clearance are essential.

Competenze

• U.S. Citizenship required; must be able to obtain and maintain a Public Trust clearance; all work performed within the United States.
• 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
• Proficiency in Python or Scala for ETL pipeline development
• Proficiency in SQL for querying, validating, and transforming data in a cloud data lakehouse environment
• Familiarity with geospatial data formats and coordinate reference systems

Mansioni

• 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.

Conoscenze

Databricks Delta Live Tables

Python

SQL

Data validation

Data modeling

Geospatial concepts

Formazione

Bachelor's degree or higher

Strumenti

Databricks

Delta Live Tables

ArcGIS

QGIS

Git

Descrizione del lavoro

Peraton is seeking a Junior Data Engineer (ETL/GIS) to support a federal data migration program in a fully remote US-based role. You will build and test ETL pipelines, perform data normalization across spatial data formats, and ensure data quality in a cloud lakehouse environment.

The position requires Databricks experience, Python/Scala proficiency, SQL skills, and knowledge of geospatial data concepts. U.S. citizenship and the ability to obtain a Public Trust clearance are essential.