Mid-Level ETL Specialist-ETL Engineer-ETL Developer
IMAGINEEER LLCWashington, DC, US2 days ago
Job type
- Full-time
Job descriptionDesign, 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. 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. 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. 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. 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. 3-5+ 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. 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
Job Description
Job Description
Benefits :
- 401(k) matching
- Competitive salary
- Health insurance
- Paid time off
About this Role :
The Mid-Level 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
Data Engineering & Architecture Support
Testing, Optimization & Production Support
Documentation & Collaboration
Qualifications and Skills :
Desired Skills and Competencies :
Flexible work from home options available.
Create a job alert for this search
Etl Developer • Washington, DC, US
Related jobs
At CMiT, we do more than provide real-world solutions.We deliver transformative results.Through cutting-edge technology and process innovations, we are changing how federal and commercial clients w...Show moreLast updated: 30+ days ago
A company is looking for a CSV Engineer based in Raleigh, NC.Key Responsibilities Develop and execute validation protocols (IQ / OQ / PQ) for GxP systems Ensure compliance with FDA regulations and r...Show moreLast updated: 1 day ago A company is looking for a Logic Monitor SME.Key Responsibilities Implement and manage Logic Monitor SaaS environment Oversee collector installation, device onboarding, and configuration mainten...Show moreLast updated: 1 day ago A company is looking for a Systems Integration Tester to support state-level healthcare and eligibility projects in a remote setting.
Key Responsibilities Design, develop, and execute test cases a...Show moreLast updated: 4 hours ago A company is looking for a Salesforce QA / Test Engineering Lead.Key Responsibilities : Lead the Salesforce QA team to define test strategies and execute testing to meet stakeholder requirements De...Show moreLast updated: 2 days ago A company is looking for an IT Data Quality Senior Engineer to ensure data quality and compliance across various projects.
Key Responsibilities Automate and optimize data validations, implement bu...Show moreLast updated: 30+ days ago A company is looking for an IGA Engineer with Active Secret Clearance.Key Responsibilities Design and implement Identity Governance and Administration (IGA) solutions within federal organizations...Show moreLast updated: 1 day ago A company is looking for a ServiceNow Automated Test Framework QA Engineer / Tester (Remote).Key Responsibilities Drive ATF QA efforts across ServiceNow implementations and enhancements Develop an...Show moreLast updated: 30+ days ago A company is looking for an ETL Data Architect to design and develop enterprise-wide application systems.Key Responsibilities Collaborate with business partners and teams to identify technical an...Show moreLast updated: 1 day ago A company is looking for a Senior Engineer II, API.Key Responsibilities Develop gRPC APIs in Go Lang and full stack applications including front end UI (React) Collaborate with the team to defin...Show moreLast updated: 30+ days ago A company is looking for a LMS System Administrator.Key Responsibilities Administer and maintain the LMS platform, manage user accounts, and coordinate with vendors for system updates Monitor da...Show moreLast updated: 1 day ago A company is looking for a Tech Lead with AI & Data expertise (Remote, LATAM).Key Responsibilities Lead the technical effort for the Delivery Team, ensuring clarity and confidence with clients an...Show moreLast updated: 16 hours ago A company is looking for an ETL Implementation Engineer to develop and maintain ETL pipelines and ensure data quality within financial services.
Key Responsibilities Design, build, and maintain ro...Show moreLast updated: 12 hours ago A company is looking for an ETL Developer Lead / Consultant.Key Responsibilities Design, build, and maintain ETL pipelines for data ingestion into the TradingHub platform Configure and integrate ...Show moreLast updated: 12 hours ago 
Overview : Develop software and system integrations based on Microsoft Dynamics AX (X++).ABOUT FULL CIRCLE SOLUTIONS, INC.
We take pride in having helped clients and customers, in both the public and...Show moreLast updated: 30+ days ago A company is looking for a Deep Learning Software Engineer, Inference and Model Optimization - New College Grad 2025.Key Responsibilities Train, develop, and deploy generative AI models using the...Show moreLast updated: 12 hours ago A company is looking for a CVML Engineer.Key Responsibilities Develop and advance computer vision and machine learning solutions Implement and evaluate algorithms in large-scale databases for pe...Show moreLast updated: less than 1 hour ago A company is looking for an IT Data Solutions Developer Associate.Key Responsibilities Analyze, develop, and improve BI solutions to meet business needs Collaborate with operations teams to desi...Show moreLast updated: 28 days ago A company is looking for an Information Delivery & Visualization Engineer.Key Responsibilities Design, develop, and implement end-to-end data integration workflows using Informatica IICS Develop...Show moreLast updated: 14 hours ago A company is looking for a Senior Consultant AI.Key Responsibilities Utilize Azure AI Services to build and optimize OpenAI solutions Develop and manage data ingestion and transformation pipelin...Show moreLast updated: 30+ days ago
- Promoted
APEX Developer
Crystal Management | CMITWashington, DC, United StatesFull-time
- Promoted
CSV Engineer
VirtualVocationsAlexandria, Virginia, United StatesFull-time
- Promoted
LogicMonitor SME
VirtualVocationsArlington, Virginia, United StatesFull-time
- Promoted
- New!
Systems Integration Tester
VirtualVocationsWashington, District of Columbia, United StatesFull-time
- Promoted
Salesforce QA Engineer Lead
VirtualVocationsAlexandria, Virginia, United StatesFull-time
- Promoted
Data Quality Senior Engineer
VirtualVocationsAlexandria, Virginia, United StatesFull-time
- Promoted
IGA Engineer with Secret Clearance
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
ServiceNow QA Engineer
VirtualVocationsAlexandria, Virginia, United StatesFull-time
- Promoted
ETL Data Architect
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
Senior API Engineer
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
LMS System Administrator
VirtualVocationsAlexandria, Virginia, United StatesFull-time
- Promoted
- New!
Tech Lead for AI & Data
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
- New!
ETL Implementation Engineer
VirtualVocationsArlington, Virginia, United StatesFull-time
- Promoted
- New!
ETL Developer Consultant
VirtualVocationsWashington, District of Columbia, United StatesFull-time
- Promoted
Dynamics AX Developer
Full Circle Solutions IncBaltimore, MD, USFull-time
- Promoted
- New!
Deep Learning Software Engineer
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
- New!
CVML Engineer
VirtualVocationsAlexandria, Virginia, United StatesFull-time
- Promoted
Epic Certified BI Developer
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
- New!
Informatica IICS Developer
VirtualVocationsBaltimore, Maryland, United StatesFull-time
- Promoted
Senior AI Consultant
VirtualVocationsAlexandria, Virginia, United StatesFull-time