Junior Data Engineer, ETL, GIS

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, test, and implement ETL pipelines utilizing Databricks Delta Live Tables within a cloud-based data lakehouse staging environment.

• Conduct data aggregation and normalization processes across various authoritative source systems.

• Standardize spatial formats and coordinate reference systems.

• Apply source-to-target transformation logic, which includes field-level mapping rules, data type conversions, and handling of null values.

• Execute prototype data ingestion workflows using representative taxa.

• Assess ingestion outcomes for completeness, accuracy, consistency, and spatial integrity criteria.

• Record results from prototype ingestion, including defects and corrective measures.

• Generate the Prototype Ingest Results Report.

• Report data quality defects with severity classifications and monitor remediation efforts.

• Maintain ETL pipeline code in a version-controlled repository, ensuring all necessary peer review documentation is included.

• Assist in spatial data validation in collaboration with GIS Engineers.

• Aid in interoperability testing with test datasets, pipeline execution, and data validation support.

⛳️ Requirements

• A Bachelor’s degree with no professional experience, an Associate’s degree with 2 years of professional experience, or a high school diploma/equivalent with 4 years of professional experience.

• U.S. Citizenship is mandatory.

• Capability to obtain and maintain a Public Trust clearance.

• All work must be conducted within the United States.

• Practical experience with Databricks and Delta Live Tables or similar cloud ETL frameworks.

• Background in data quality validation, source-to-target mapping, and data transformation processes.

• Experience in data modeling or schema design documentation.

• Proven experience in documenting test/ingest results and logging defects with severity classifications.

• Proficiency in Python or Scala for the development of ETL pipelines.

• Proficiency in SQL for querying, validating, and transforming data within a cloud data lakehouse environment.

• Familiarity with geospatial data formats and coordinate reference systems.

• Preferred: Experience with AWS GovCloud or a comparable FedRAMP-authorized cloud environment.

• Preferred: Familiarity with GIS tools such as ArcGIS or QGIS.

• Preferred: Knowledge of federal data governance and metadata standards.

• Preferred: Databricks Associate certification or equivalent.

🏝️ Benefits

• Overtime eligibility may apply.

• Shift differential may apply.

• Discretionary bonus may apply.