Junior Data Engineer (DEA)

Hatchit; Arlington (VA); On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

401k matching

Medical insurance

Education reimbursement

Life insurance

PTO and holidays

Office gym access

Commuter benefits

Job summary

Expression is seeking a Junior Data Engineer to support the DEA ICDE modernization, focusing on ingesting, transforming, validating, migrating, and integrating datasets under guidance from senior engineers. This entry‑level role offers hands‑on experience in a large federal modernization program and requires willingness to pursue TS/SCI, with Arlington, VA onsite.

Qualifications

• Bachelor's degree in STEM fields and 0–1 years of professional experience.
• Foundational exposure to data analysis, ETL concepts, or data migration.
• Working knowledge of SQL, including basic queries, joins, and aggregations.
• Familiarity with Python for data manipulation or automation tasks.
• 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.
• Support migration of legacy data into the modernized DEA ecosystem.
• Analyze data structures, source-to-target mappings, and data-quality checks.
• Execute validation queries and data profiling to ensure quality.
• Contribute to data migration activities and mapping source data to targets.
• Support data cleaning, standardization, and tagging.
• Collaborate with analysts, data scientists, engineers, and stakeholders.
• Monitor pipeline performance and troubleshoot issues.
• Document migration results and data-quality issues.
• Participate in Agile ceremonies and sprints.
• Document data flows and transformation logic for maintainability.

Skills

SQL

Python

Cloud platforms

ETL concepts

Data migration

Data profiling

Git

Agile

Education

Bachelor's degree in STEM fields

Tools

Apache Airflow

Talend

Power BI

Tableau

Looker

Hadoop

Spark

Job description

hatch I.T. is partnering with Expression to find a Junior Data Engineer (DEA). See details below:

About The Role:

Expression is seeking a Junior Data Engineer to support the Drug Enforcement Administration (DEA) Investigative Case and Data Ecosystem (ICDE) modernization effort. The program is focused on replacing fragmented legacy investigative and case management capabilities with a centralized, secure, scalable, and integrated ecosystem.

Working alongside experienced data engineers and other technical team members, the Data Engineer 2 will support data ingestion, transformation, validation, migration, and integration activities. This is an early-career opportunity for an individual with foundational data engineering knowledge who is interested in developing hands-on experience supporting a large-scale Federal technology modernization program.

Clearance:

Secret level required and willingness to pursuit TS/SCI.

Location:

Arlington, VA. The program is primarily onsite at DEA Headquarters.

About the Company:

Founded in 1997 and headquartered in Washington DC, Expression provides data fusion, data analytics, software engineering, information technology, and electromagnetic spectrum management solutions to the U.S. Department of Defense, Department of State, and national security community. Expression’s “Perpetual Innovation” culture focuses on creating immediate and sustainable value for their clients via agile delivery of tailored solutions built through constant engagement with their clients. Expression was ranked #1 on the Washington Technology 2018's Fast 50 list of fastest growing small business Government contractors and a Top 20 Big Data Solutions Provider by CIO Review.

• 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.

• Bachelor's degree in STEM fields and 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.

• Hands‑on or coursework experience with AWS, Azure, or Google Cloud Platform.
• Exposure to Hadoop, Spark, or other distributed‑processing technologies.
• Familiarity with Power BI, Tableau, Looker, or similar visualization tools.
• Familiarity with Git or similar version‑control systems.
• Experience building or supporting automated data workflows using orchestration tools or scheduled scripting.
• Exposure to Agile development methodologies.
• Coursework, internship, project, or professional exposure to data migration or system-modernization activities.

Benefits:

Expression offers competitive salaries and benefits, such as:

• 401k matching
• PPO and HDHP medical/dental/vision insurance
• Education reimbursement
• Complimentary life insurance
• Generous PTO and holiday leave
• Onsite office gym access
• Commuter Benefits Plan