Data Engineer (DEA)

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

Benefits offered by this job

401k matching

PPO and HDHP insurance

Education reimbursement up to $10,000/

Life insurance

Generous PTO and holidays

Onsite gym facility

Commuter Benefits

In-office Cold Brew

Job summary

Expression Networks is seeking a Data Engineer to support the DEA ICDE modernization, building scalable ETL pipelines and migrating legacy data to a modern, secure ecosystem for analytics and AI/ML tasks.

The role focuses on ingesting, transforming, validating, and integrating data across platforms, with a tight emphasis on data quality, governance, and collaboration with analysts and developers. Onsite work at DEA Headquarters in Arlington, VA is required.

Qualifications

• Bachelor's degree in STEM and 2+ years of professional experience.
• Hands-on experience with data analysis, ETL development, and data migration.
• Proficiency in SQL, including complex queries and performance tuning.
• Familiarity with Python for data manipulation and automation.
• Experience with ETL frameworks or orchestration tools (Airflow, Talend, dbt).
• Understanding of data warehousing, dimensional modeling, and staging.
• Experience with cloud platforms (AWS Redshift, BigQuery, Azure SQL).
• Ability to document data mappings, transformations, and processes.
• Ability to collaborate with engineers, analysts, and business stakeholders.

Responsibilities

• Design, develop, and maintain scalable ETL pipelines for structured and unstructured data.
• Support large-scale migration of legacy data into the modernized DEA ecosystem.
• Analyze data structures and mappings to optimize workflows and automation.
• Implement data cleaning, standardization, validation, and transformation.
• Monitor data quality and integrity across systems and platforms.
• Develop data migration strategies across platforms and clouds.
• Create data validation checkpoints during migration activities.
• Collaborate with analysts, data scientists, and developers on requirements.
• Support data interoperability across integrated systems.
• Monitor pipeline performance and troubleshoot issues to improve reliability.
• Prepare data for analytics and AI/ML use cases.
• Participate in Agile sprint planning and reviews.
• Document data flows, mappings, and transformation logic.

Skills

SQL proficiency

Python for data manipulation

ETL development

Data migration

Airflow/Talend/dbt

Data warehousing concepts

Cloud platforms (AWS/GCP/Azure)

Data profiling and validation

Documentation of processes

Collaboration with stakeholders

Agile development

Education

Bachelor's degree in STEM fields

Tools

Apache Airflow

Talend

dbt

AWS Redshift

Google BigQuery

Azure SQL

Git

Job description

Expression is seeking a Data Engineer to support the Drug Enforcement Administration (DEA) Investigative Case and Data Ecosystem (ICDE) modernization effort. This program is focused on modernizing DEA's case management capabilities and creating a centralized, secure, scalable ecosystem supporting law enforcement, investigative, forensic, and intelligence missions.

The Data Engineer will design, develop, and maintain scalable data pipelines supporting the ingestion, transformation, migration, validation, and integration of structured and unstructured data. This position will contribute to the modernization and migration of DEA legacy data while helping ensure data is accurate, consistent, secure, and prepared to support analytics and emerging AI/ML capabilities.

Clearance: Top Secret (SCI) required.

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

Key Responsibilities

• Design, develop, and maintain scalable ETL pipelines for ingesting, transforming, and loading structured and unstructured datasets.
• Support large-scale migration of legacy data into the modernized DEA investigative and case management ecosystem.
• Analyze complex data structures and source-to-target mappings to identify opportunities for workflow optimization and automation.
• Implement data cleaning, standardization, validation, classification, and transformation processes to improve data quality and consistency.
• Monitor and ensure data accuracy, completeness, consistency, and integrity across systems and platforms.
• Implement data migration strategies supporting application modernization and transitions across platforms and cloud environments.
• Develop and execute data validation processes and checkpoints throughout data migration activities.
• Collaborate with analysts, data scientists, developers, and business partners to translate requirements into effective data engineering solutions.
• Support data interoperability and exchange across integrated systems.
• Monitor pipeline performance, troubleshoot operational issues, and improve reliability, scalability, and efficiency.
• Support data preparation and tagging activities needed for analytics and AI/ML use cases.
• Participate in Agile development activities, including sprint planning, stand-ups, reviews, and retrospectives.
• Document data flows, source-to-target mappings, transformation logic, validation processes, and operational procedures.

Required Qualifications

• Bachelor's degree on STEM fields and 2+ years of professional experience.
• Hands-on experience with data analysis, ETL development, and data migration.
• Proficiency in SQL, including complex queries, data transformations, and performance tuning.
• Familiarity with Python for data manipulation, scripting, and workflow automation.
• Experience with ETL frameworks or orchestration tools such as Apache Airflow, Talend, dbt, or similar technologies.
• Understanding of data warehousing principles, including dimensional modeling and staging architectures.
• Exposure to cloud-based data platforms such as AWS Redshift, Google BigQuery, Azure SQL, or similar environments.
• Ability to perform data profiling, validation, troubleshooting, and root-cause analysis.
• Ability to clearly document technical processes, data mappings, and transformation logic.
• Ability to collaborate effectively with engineers, analysts, developers, and business stakeholders.

Preferred Qualifications

• Experience with AWS, Azure, or Google Cloud Platform.
• Knowledge of big-data technologies such as Hadoop, Spark, or other distributed-processing frameworks.
• Experience with data visualization tools such as Power BI, Tableau, or Looker.
• Familiarity with Git or similar version-control systems.
• Experience designing automated data workflows or integrating workflow-orchestration tools.
• Experience supporting large-scale data migration or application-modernization initiatives.
• Experience working in Agile development environments.
• Experience supporting Federal Government programs or systems.

Benefits

Expression offers competitive salaries and benefits, such as:

• 401k matching
• PPO and HDHP medical/dental/vision insurance
• Education reimbursement up to $10,000/yr
• Complimentary life insurance
• Generous PTO and 11 days of holiday leave
• Onsite gym facility
• Commuter Benefits Plan
• In-office Cold Brew Coffee

About Expression:

Founded in 1997 and headquartered in Washington DC, Expression provides data fusion, data analytics, AI/ML, 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 culture focuses on creating immediate and sustainable value for our clients via agile delivery of tailored solutions built through constant engagement with our 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.

We make sure to provide everyone with the tools and opportunities to grow while working on some of the newest technologies in the industry. We get excited about celebrating our professionals' milestones, accomplishments, promotions, overcoming challenges, and many other aspects that make an engaging collaborative environment.

Equal Opportunity Employer/Veterans/Disabled

Expression is an Equal Opportunity Employer. If you require a reasonable accommodation during the application or interview process, please submit your request to our Human Resources department through the application portal.