Junior Data Engineer - Federal Data Modernization ETL

Expression Networks; Washington (District of Columbia); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

401k matching

PPO and HDHP medical/dental/vision

Education reimbursement up to $10,000/

In-office Cold Brew Coffee

Job summary

Expression Networks seeks a Junior Data Engineer to support the DEA ICDE modernization effort, focusing on ingesting, transforming, and validating data for a centralized ecosystem. You will work with experienced data engineers to design ETL pipelines and migrate legacy data under guidance.

This entry-level role emphasizes foundational data engineering skills, collaboration with cross-functional teams, and hands-on exposure to large-scale federal modernization projects.

Qualifications

• Bachelor's degree in a STEM field with 0–1 years of professional experience.
• Foundational exposure to data analysis, ETL concepts, or data migration through coursework or internships.
• Working knowledge of SQL with basic queries, joins, and aggregations.
• Introductory Python for data manipulation or automation tasks.
• Introductory experience with ETL/workflow tools such as Apache Airflow or Talend.
• Understanding of data warehousing concepts and cloud storage/compute platforms.
• Exposure to data profiling, validation, and data quality.
• Strong communication and documentation skills; ability to learn in a fast-paced environment.

Responsibilities

• Assist in designing, developing, and maintaining ETL pipelines for ingesting, transforming, and loading datasets.
• Support migration of legacy data into the modernized DEA ecosystem.
• Analyze data structures, mappings, and data-quality checks to identify issues.
• Execute validation queries, profile datasets, and support data-cleaning efforts.
• Contribute to data migration activities, including mapping source data to targets.
• Support data cleaning, standardization, classification, and tagging.
• Collaborate with analysts, data scientists, engineers, and stakeholders on requirements.
• Monitor pipeline performance and troubleshoot operational issues; escalate as needed.
• Participate in validation activities and document migration results and issues.
• Participate in Agile ceremonies and support data engineering during sprints.
• Document data flows, transformation logic, mappings, and processes for maintainability.

Skills

SQL

Python

ETL concepts

Data migration

Data profiling

Data quality

Documentation

Communication

Agile

Education

BSc in STEM fields

Tools

Apache Airflow

Talend

AWS

Azure

Google Cloud

Git

Power BI

Tableau

Looker

Hadoop

Spark

Job description

Expression Networks seeks a Junior Data Engineer to support the DEA ICDE modernization effort, focusing on ingesting, transforming, and validating data for a centralized ecosystem. You will work with experienced data engineers to design ETL pipelines and migrate legacy data under guidance.

This entry-level role emphasizes foundational data engineering skills, collaboration with cross-functional teams, and hands-on exposure to large-scale federal modernization projects.