Sign upLog in
See more jobs

Data Engineer (DEA)

Hatch IT
  • Arlington, VA
    3 days ago

    Job Description

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

    About The Role:

    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.

    Location and Clearance:

    • Clearance: Top Secret (SCI) required.
    • 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.

    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.

    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

    • Complimentary life insurance

    • Generous PTO and holiday leave

    • Onsite office gym access

    • Commuter Benefits Plan

    Numbers & Facts

    LocationArlington, VA

    Skills

    • Agile Programming Methodologiesunmatched
    • Amazon Web Services (AWS)unmatched
    • Apacheunmatched
    • Apache Hadoopunmatched
    • Apache Sparkunmatched
    • Artificial Intelligence (AI)unmatched
    • Automationunmatched
    • Big Dataunmatched
    • Business Growthunmatched
    • Case Managementunmatched
    • Cloud Computingunmatched
    • Compensation and Benefitsunmatched
    • Data Analysisunmatched
    • Data Cleaningunmatched
    • Data Fusionunmatched
    • Data Managementunmatched
    • Data Migrationunmatched
    • Data Processingunmatched
    • Data Profilingunmatched
    • Data Qualityunmatched
    • Data Scienceunmatched
    • Data Setsunmatched
    • Data Structuresunmatched
    • Data Visualization Toolsunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Dental Insuranceunmatched
    • Dimensional Modelingunmatched
    • Ecosystemsunmatched
    • Electromagnetismunmatched
    • Federal Governmentunmatched
    • Gitunmatched
    • Government Contractsunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Interoperabilityunmatched
    • Law Enforcementunmatched
    • Lookerunmatched
    • Microsoft Windows Azureunmatched
    • Migration Strategyunmatched
    • Multiplatform/Cross-Platformunmatched
    • Operational Improvementunmatched
    • Operations Processesunmatched
    • Performance Analysisunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Preferred Provider Organization (PPO)unmatched
    • Process Improvementunmatched
    • Python Programming/Scripting Languageunmatched
    • Quality Managementunmatched
    • Reliability Engineeringunmatched
    • Requirements Managementunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Scalable System Developmentunmatched
    • Scripting (Scripting Languages)unmatched
    • Small Businessunmatched
    • Software Administrationunmatched
    • Software Engineeringunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Sprint Planningunmatched
    • Standup Meetingsunmatched
    • Structured Dataunmatched
    • System Integration (SI)unmatched
    • Tableauunmatched
    • Team Playerunmatched
    • Technical Writingunmatched
    • Training Data Setsunmatched
    • United States Department of Defense (DoD)unmatched
    • United States Drug Enforcement Agency (DEA)unmatched
    • Unstructured Dataunmatched
    • Use Casesunmatched
    • Vision Planunmatched
    • Workflow Analysisunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder