Junior Data Engineer - DEA ICDE (Onsite Arlington)

Hatch IT; Arlington (VA); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

401k matching

Medical/dental/vision insurance

Education reimbursement

Life insurance

Generous PTO and holidays

Onsite gym access

Commuter benefits

Job summary

hatch I.T. is partnering with Expression to support a Junior Data Engineer role for the DEA ICDE modernization in Arlington, VA.

You will join a team of data engineers to design, build, and maintain ETL pipelines under guidance, focusing on ingestion, transformation, and migration tasks for a large federal program. You will develop foundational data engineering skills, collaborate with analysts and stakeholders, and contribute to data quality and validation efforts in a primarily onsite

Qualifications

• Bachelor's degree in STEM fields with 0–1 years of professional experience.
• Foundational exposure to data analysis, ETL concepts, or data migration through coursework, internships, personal projects, or early professional experience.
• Working knowledge of SQL, including basic queries, joins, and aggregations.
• Familiarity with Python for data manipulation or automation tasks; introductory-level experience is acceptable.
• Introductory experience with ETL or workflow tools such as Apache Airflow, Talend, or similar technologies.
• Understanding of basic data warehousing concepts, including staging, fact/dimension models, or schema structures.
• Exposure to cloud-based data storage or compute platforms such as AWS S3/Redshift, Google BigQuery, Azure Storage, or similar environments.
• Foundational understanding of data profiling, validation, and data quality.
• Strong communication and documentation skills.
• Ability and willingness to learn in a fast-paced, evolving technical environment.

Responsibilities

• Assist in designing, developing, and maintaining ETL pipelines for ingesting, transforming, and loading datasets under the guidance of more experienced engineers.
• Support migration of legacy data into the modernized DEA investigative and case management ecosystem.
• Assist with analyzing data structures, source-to-target mappings, and data-quality checks to identify issues or gaps.
• Help ensure data accuracy, consistency, and integrity by executing validation queries, profiling datasets, and supporting data-cleaning efforts.
• Contribute to data migration activities, including mapping source data to target systems and executing migration scripts.
• Support data cleaning, standardization, classification, and tagging activities.
• Collaborate with analysts, data scientists, engineers, and business stakeholders to translate requirements into data transformations and pipeline updates.
• Monitor pipeline performance and assist with troubleshooting operational issues, escalating complex issues as appropriate.
• Participate in validation activities and help document migration results and identified data-quality issues.
• Participate in Agile ceremonies and support data engineering activities throughout development sprints.
• Help document data flows, transformation logic, mappings, and operational processes to support maintainability and knowledge sharing.

Skills

SQL

Python

ETL concepts

Data migration

Data ingestion

Data transformation

Strong communication

Cloud basics

Data quality checks

Education

Bachelor's degree in STEM fields

Tools

Apache Airflow

Talend

Git

Hadoop

Spark

Power BI

Tableau

Job description

hatch I.T. is partnering with Expression to support a Junior Data Engineer role for the DEA ICDE modernization in Arlington, VA.

You will join a team of data engineers to design, build, and maintain ETL pipelines under guidance, focusing on ingestion, transformation, and migration tasks for a large federal program. You will develop foundational data engineering skills, collaborate with analysts and stakeholders, and contribute to data quality and validation efforts in a primarily onsite