Data Engineer — Scalable ETL for Modern Investigations

Hatchit; Arlington (VA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

401k matching

PPO and HDHP medical/dental/vision

Education reimbursement

Complimentary life insurance

Generous PTO and holiday leave

Onsite office gym access

Commuter Benefits Plan

Job summary

Expression seeks a Data Engineer to support the DEA ICDE modernization, designing and maintaining scalable data pipelines for ingestion, transformation, and migration of structured and unstructured data.

You will ensure data quality, security, and readiness for analytics and AI/ML, collaborating with analysts, developers, and stakeholders in a primarily onsite role at DEA Headquarters in Arlington, VA, with Top Secret (SCI) clearance required.

Qualifications

• Bachelor's degree in STEM fields and 2+ years of professional experience.
• Hands-on experience with data analysis, ETL development, and data migration.
• Proficiency in SQL with complex queries and performance tuning.
• Familiarity with Python for data manipulation and automation.
• Experience with ETL frameworks or orchestration tools like Airflow or dbt.
• Understanding of data warehousing, dimensional modeling, and staging.
• Exposure to cloud data platforms (AWS/Azure/Google) and data visualization tools.

Responsibilities

• Design, develop, and maintain scalable data pipelines for ingestion and transformation.
• Support large-scale migration of legacy data into modernized ecosystems.
• Analyze data structures and mappings to optimize workflows and automation.
• Implement data cleaning, validation, and transformation to improve quality.
• Monitor pipelines, troubleshoot issues, and improve reliability and scale.
• Collaborate with analysts, developers, and stakeholders to translate requirements.
• Document data flows, mappings, and transformation logic.

Skills

SQL proficiency

Python for data manipulation

Data analysis

Data migration

Data modeling

Documentation

Collaboration

Agile development

Education

Bachelor's degree in STEM fields

Tools

Apache Airflow

dbt

ETL frameworks

AWS Redshift

BigQuery

Azure SQL

Git

Power BI

Tableau

Looker

Job description

Expression seeks a Data Engineer to support the DEA ICDE modernization, designing and maintaining scalable data pipelines for ingestion, transformation, and migration of structured and unstructured data.

You will ensure data quality, security, and readiness for analytics and AI/ML, collaborating with analysts, developers, and stakeholders in a primarily onsite role at DEA Headquarters in Arlington, VA, with Top Secret (SCI) clearance required.