Junior Data Engineer, ETL, GIS
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Junior Data Engineer building Databricks ETL and GIS validation pipelines for Peraton’s federal endangered-species data integration program. Supporting cloud lakehouse ingestion, data quality, and interoperability testing.
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 from multiple authoritative source systems
- Normalize spatial formats and coordinate reference systems
- Implement source-to-target transformation logic, including field-level mapping rules, data type conversions, and null-handling logic
- Execute prototype data ingestion workflows using representative taxa
- Evaluate ingestion results against completeness, accuracy, consistency, and spatial integrity criteria
- Document prototype ingestion results, defects, and remediation actions
- Produce the Prototype Ingest Results Report
- Log data quality defects with severity classifications and remediation tracking
- Maintain ETL pipeline code in a version-controlled repository with mandatory peer review documentation
- Support spatial data validation in coordination with GIS Engineers
- Support interoperability testing with test datasets, pipeline execution, and data validation assistance
Requirements:
- 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
- Ability to obtain and maintain a Public Trust clearance
- All work must be 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
- 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
- Preferred: 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: Databricks Associate certification or equivalent
Benefits:
- Overtime eligibility may apply
- Shift differential may apply
- Discretionary bonus may apply
Similar Jobs
Junior Data Engineer – ETL, Data Quality
Junior Data Engineer supporting Peraton’s federal data migration program through ETL pipelines, database operations, and data quality validation. Maintaining ingestion workflows, security controls, and production migration readiness.
Senior Associate, Data Solutions Engineering
Senior Associate building robust data pipelines and modern data solutions for Fortitude Re, a global legacy reinsurance provider. Optimizing data flows, architectures, automation, and governance.
Senior Analytics Engineer
Analytics Engineer advising industrial customers on Seeq’s process analytics software. Designing scalable use cases, driving adoption, and shaping product capabilities across EMEA.
Data and Analytics Engineer
Data and Analytics Engineer designing Fabric and Databricks lakehouse platforms and enterprise Power BI analytics. Advising Collectiv’s enterprise clients through scalable data engineering and decision-focused dashboards.
Senior Analytics Engineer – Finance
Senior Analytics Engineer building trusted financial data products for Kraken, a global crypto platform. Automating reconciliations, pipelines, dashboards and finance close processes.
Senior Analytics Engineer – Finance
Senior Analytics Engineer building trusted financial data products for Kraken, a global crypto trading platform. Automating reconciliations, pipelines, dashboards, and finance close processes.
Senior Product Analytics Engineer
Senior Product Analytics Engineer building governed product data pipelines and analytics models for Horizon3’s autonomous cybersecurity platform. Supporting Federal compliance, self-service metrics, and product-led growth.
Analytics Engineer
Analytics Engineer transforming federal healthcare data into trusted analytics-ready datasets. Supporting reporting, business intelligence, governance, and cloud modernization initiatives.
Senior Analytics Engineer – Commercial Intelligence
Senior Analytics Engineer building profitability and funnel data models for Emma, the global direct-to-consumer sleep-products company. Using SQL, dbt, Python, Redshift, and Kimball modelling principles.
Analytics Engineer
Analytics Engineer building trusted data models, pipelines, and dashboards for Joyce University’s healthcare education programs. Supporting institutional reporting, self-service analytics, and data-driven student success.
Senior Analytics Engineer
Senior Analytics Engineer building dbt data models for Numan’s AI-powered digital health platform. Driving analytics across commercial, marketing, clinical operations, and patient outcomes.
ETL Developer
ETL Developer building Azure, Fabric, Dataverse, and Lakehouse pipelines for Vaya Partners’ Rural Health Transformation Program. Supporting secure healthcare analytics and reporting.
Analytics Engineering – Tech Lead
Tech Lead de Analytics Engineering liderando padrões, qualidade e automação da plataforma analítica da fintech Asaas. Evolução de dbt, CI/CD, governança e observabilidade para mais de 200 mil clientes.
Senior Analytics Engineer
Senior Analytics Engineer designing dbt data models and pricing analytics solutions. Supporting CI&T’s enterprise AI transformation with Azure, Databricks, Python, and Power BI.
Senior AI Data and Analytics Engineer
Senior AI data engineer architecting Databricks pipelines, semantic models, and AI agents. Powering analytics for Samsara’s Connected Operations IoT platform across physical industries.
ETL Developer, Python, PostgreSQL
ETL Developer building Python ETL components for DATAGROUP Polska's technology refresh. Migrating Oracle to PostgreSQL and supporting cloud and application modernization initiatives.
Analytics Engineer
Analytics Engineer building dbt and BigQuery data infrastructure for LangChain’s AI agent platform. Enabling self-serve analytics, KPI dashboards, and insights into customer health, adoption, and revenue.
Senior Data Analytics Specialist
Data Developer building Azure Data Factory and OneLake pipelines for CI&T’s enterprise AI transformation solutions. Integrating ERP and CRM systems while ensuring reliable Bronze-layer ingestion.
Freelance Mid/Senior Analytics Engineer
Freelance Analytics Engineer modernizing manufacturing ERP analytics through Dynamics 365 migration. Building Microsoft Fabric, Power BI, Lakehouse, and S&OP solutions for planning insights.
Senior Analytics Engineer – DBT
Senior Analytics Engineer building DBT, Airflow, BigQuery, and Looker solutions. Supporting Rox Partner’s growing data consultancy through analytics engineering and governance.