Talent.com
Sr ETL Specialist / ETL Engineer / ETL Developer

Sr ETL Specialist / ETL Engineer / ETL Developer

IMAGINEEER LLCWashington, DC, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Job Description

Job Description

Benefits :

  • 401(k) matching
  • Competitive salary
  • Health insurance
  • Paid time off

About this Role :

The Senior ETL Specialist / ETL Engineer will support enterprise data integration and modernization efforts for the U.S. Department of Health and Human Services (HHS). The role is responsible for designing, developing, and maintaining Extract, Transform, Load (ETL) processes that enable secure, accurate, and reliable data movement across federal systems and mission-critical programs. The ETL Specialist will work as part of a data engineering and analytics team to support data warehousing, business intelligence (BI), and enterprise reporting initiatives.

The ideal candidate will possess deep ETL development expertise, strong SQL and data modeling skills, and experience in enterprise data management solutions. This role requires the ability to build scalable data pipelines, optimize data flows, and ensure data integrity across multiple platforms. Experience in a federal environment and knowledge of HHS mission priorities are highly desirable.

Key Responsibilities :

ETL Development & Data Integration

  • Design, build, and maintain scalable ETL / ELT pipelines to support enterprise data warehouse (EDW) and analytics environments.
  • Develop data ingestion and transformation routines from multiple structured and unstructured data sources.
  • Implement ETL solutions using tools such as Informatica, Talend, SSIS, Azure Data Factory, AWS Glue, or ODI .
  • Create reusable components, frameworks, and data integration templates to accelerate delivery.
  • Ensure ETL workflows are optimized for performance, maintainability, and reliability.

    • Data Engineering & Architecture Support

  • Collaborate with data architects and analysts to define data models (conceptual, logical, physical).
  • Support integration across enterprise applications including financial, HR, grants, and program systems.
  • Implement data quality rules, validation logic, and exception handling procedures.
  • Support Master Data Management (MDM) and metadata initiatives.
  • Implement best practices for ETL / data integration architecture aligned with enterprise data strategy.

    • Testing, Optimization & Production Support

  • Conduct data profiling and validation to ensure ETL output accuracy.
  • Perform unit testing, integration testing, and UAT validation for ETL solutions.
  • Troubleshoot ETL failures, investigate root causes, and deploy corrective measures.
  • Optimize ETL workflows for high performance and reduced processing time.
  • Provide production support and participate in on-call rotation as necessary.

    • Documentation & Collaboration

  • Develop and maintain ETL documentation including design specifications, data flow diagrams, and data lineage documentation.
  • Collaborate with analysts, developers, database administrators, and federal stakeholders.
  • Participate in Agile ceremonies including sprint planning, reviews, and retrospectives.
  • Support data governance, data security, and compliance initiatives.

    • Qualifications and Skills :

  • U.S. Citizen with ability to obtain and maintain a Public Trust clearance .
  • Bachelors degree in Computer Science, Data Engineering, Information Systems, or related field.
  • 7+ years of experience in ETL development, data engineering, or enterprise data integration.
  • Hands-on experience with ETL tools such as Informatica PowerCenter / IDQ, Talend, SSIS, ADF, AWS Glue, or DataStage.
  • Strong proficiency in SQL and relational databases (Oracle, SQL Server, PostgreSQL, or Snowflake).
  • Experience with data warehousing concepts (star schema, slowly changing dimensions, data marts).
  • Proven experience creating high-performance, secure ETL processes.
  • Experience working in Agile or SDLC-driven environments.
  • Excellent communication and problem-solving skills.

    • Desired Skills and Competencies :

  • Prior experience supporting HHS or other federal agencies (CMS, NIH, HRSA, ACF, FDA).
  • Experience building ETL solutions in cloud environments (AWS, Azure, or GCP).
  • Familiarity with data governance, metadata management, and data catalog tools .
  • Experience with Python, Shell scripting, or PowerShell for automation.
  • Knowledge of API-based integrations, Kafka, or streaming data pipelines .
  • Experience with DevOps tools (Git, Jenkins, Azure DevOps).
  • Certifications such as Informatica Developer, Talend Data Integration, AWS Data Analytics, Azure Data

    • Flexible work from home options available.

    serp_jobs.job_alerts.create_a_job

    Etl Developer • Washington, DC, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    ETL Developer

    ETL Developer

    Leidos IncBethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Principal ETL Developer

    Principal ETL Developer

    Leidos IncBethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Bridge Engineers (all levels - EI / EIT, PE, Sr-level / PM)

    Bridge Engineers (all levels - EI / EIT, PE, Sr-level / PM)

    CTL EngineeringChantilly, VA, United States
    serp_jobs.job_card.full_time
    Structural | Bridge Engineers (.OH, IN, WV, KY, NC, SC, and VA with a rich history over our (97) years in business.We provide civil / site design and land surveying, environmental, geotechnical, cons...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Electrical Engineer

    Senior Electrical Engineer

    Oceaneering International, Inc.Hanover, MD, United States
    serp_jobs.job_card.full_time
    Oceaneering Technologies (OTECH) develops, manufactures, and operates customized marine systems, shipboard equipment, subsea vehicles, and engineered solutions for commercial and U.Oceaneering Aero...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    ETL Developer

    ETL Developer

    Cloud BC LabsReston, VA, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    MessageBody"> Position : ETL Developer Location : Remote Term : C2C / W2 / Full Time Role&...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    AWS Python ETL Developer

    AWS Python ETL Developer

    Cloud BC LabsReston, VA, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    MessageBody"> Role : AWS Python ETL Developer Location : Reston, VA (Hybrid) Duration : Long term &...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    B-Level Technician

    B-Level Technician

    Pro-VacManassas, VA, United States
    serp_jobs.job_card.full_time
    Come join the most talented, knowledgeable team in the hydro-excavation industry! Kinetic is part of the Pro-Vac Family of Companies with locations throughout the United States offering significan...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Electrical Engineer

    Senior Electrical Engineer

    Leonardo DRSGermantown, MD, United States
    serp_jobs.job_card.full_time
    DRS RADA Technologies, a subsidiary of Leonardo DRS, is focused on proprietary radar solutions and legacy avionics systems supporting the defense industry globally. The company is a global pioneer o...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior ETL Software Engineer

    Senior ETL Software Engineer

    Capital OneMcLean, VA, United States
    serp_jobs.job_card.full_time +1
    Senior ETL Software EngineerFull Stack Software Engineers who are passionate about marrying data with emerging technologies. As a Capital One Software Engineer, you’ll have the opportunity to be on ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Data / ETL Developer

    Data / ETL Developer

    TriTech Enterprise Systems, Inc.Baltimore, MD, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    TriTech Enterprise Systems, Inc.TriTech) is seeking a "Data / ETL Developer" to support a State of Maryland contract.This is a hybrid position that is location in Baltimore, Maryland.The candidate wi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Solutions Analyst I

    Senior Solutions Analyst I

    Oceaneering International, Inc.Hanover, MD, United States
    serp_jobs.job_card.full_time
    Oceaneering Technologies (OTECH) develops, manufactures, and operates customized marine systems, shipboard equipment, subsea vehicles, and engineered solutions for commercial and U.Oceaneering Aero...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    ETL Developer (SME)

    ETL Developer (SME)

    Leidos IncBethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Deputy Manager - Prototype Manufacturing

    Deputy Manager - Prototype Manufacturing

    Johns Hopkins Applied Physics LaboratoryMarlboro, MD, US
    serp_jobs.job_card.temporary
    Description Are you enthusiastic about contributing to Space Exploration and National Security missions? Are you a creative thinker who loves solving difficult engineering challenges? If so, we are...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Sr. ETL Developer

    Sr. ETL Developer

    Leidos IncBethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    ETL Developer

    ETL Developer

    Two95 International Inc.Tysons, VA, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Design, implement, and support ETL processes from embedded sources to data warehouse.Design and support ETL processes for data cleansing, data auditing, and data profiling.Develop moderately comple...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Oracle ETL Software Developer

    Oracle ETL Software Developer

    Barrow Wise ConsultingMD, USA
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you under...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Emergency Vehicle Operator / EMT MS Transport

    Emergency Vehicle Operator / EMT MS Transport

    MEDSTAR HEALTHUpper Marlboro, MD, United States
    serp_jobs.job_card.full_time
    MedSTAR Transport within MedStar Health is actively seeking Emergency Vehicle Operators / Emergency Medical Techs to provide basic patient medical care during interfacility ambulance transport.You w...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Unified Communications Engineer

    Unified Communications Engineer

    LeidosUpper Marlboro, MD, US
    serp_jobs.job_card.full_time
    Unified Communications Engineer.Leidos Dig Mod Health IT division is seeking a skilled and collaborative Unified Communications Engineer to support a highly visible Technology (IT) services effort ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Senior ETL Developer

    Senior ETL Developer

    ManTechChantilly, VA, United States
    serp_jobs.job_card.full_time
    Responsibilities include but are not limited to : .Designing and implementing large-scale ingest systems in a Big Data environment. Optimizing all stages of the data lifecycle, from initial planning, ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Sr. Electrical Plan Reviewer (Engineer IV)

    Sr. Electrical Plan Reviewer (Engineer IV)

    Fairfax County GovernmentFairfax, VA, United States
    serp_jobs.job_card.full_time
    This position includes a sign-on bonus of $5,000 for new county hires.Fairfax County boasts a top-notch school system, safe neighborhoods, thousands of acres of parkland, and bustling town centers....serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days