Junior Data Engineer, Federal Data Modernization (Secret)

hatch I.T.; Arlington (VA); On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

401k matching

Medical/dental/vision insurance

Job summary

hatch I.T. is partnering with Expression to recruit a Junior Data Engineer to support the DEA ICDE modernization project in Arlington, VA. The role focuses on designing and maintaining ETL pipelines, data migration, and ensuring data quality under guidance from senior engineers.

Ideal candidates have foundational data engineering knowledge, exposure to SQL and Python, and a willingness to learn in a fast-paced federal modernization program onsite at DEA Headquarters.

Qualifications

• Bachelor's degree in STEM fields or equivalent.
• Foundational exposure to data analysis, ETL concepts, or data migration through coursework, internships, or early 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/workflow tools such as Apache Airflow or Talend.
• Understanding of data warehousing concepts (staging, fact/dimension models).
• Exposure to cloud platforms (AWS S3/Redshift, Google BigQuery, Azure Storage).
• Foundational data profiling, validation, and data quality knowledge.
• Strong communication and documentation skills.
• Willingness to learn in a fast-paced environment.

Responsibilities

• Assist in designing, developing, and maintaining ETL pipelines.
• Support migration of legacy data into the modernized DEA ecosystem.
• Analyze data structures and data-quality checks to identify issues.
• Execute validation queries and data profiling to ensure accuracy.
• Contribute to data migration activities and mapping source to target datasets.
• Support data cleaning, standardization, and tagging efforts.
• Collaborate with analysts, data scientists, engineers, and stakeholders to implement data transformations.
• Monitor pipeline performance and assist with troubleshooting.
• Document data flows, mappings, and operational processes.
• Participate in Agile ceremonies and development sprints.

Skills

SQL

Python

Data analysis

ETL concepts

Data migration

Communication

Documentation

Education

Bachelor's degree in STEM fields

Tools

Apache Airflow

Talend

AWS S3/Redshift

Azure Storage

Google BigQuery

Power BI

Tableau

Looker

Git

Job description

hatch I.T. is partnering with Expression to recruit a Junior Data Engineer to support the DEA ICDE modernization project in Arlington, VA. The role focuses on designing and maintaining ETL pipelines, data migration, and ensuring data quality under guidance from senior engineers.

Ideal candidates have foundational data engineering knowledge, exposure to SQL and Python, and a willingness to learn in a fast-paced federal modernization program onsite at DEA Headquarters.