caferemote
Trilogy Federal

ETL Specialist

Remote United States Full-time $80K – $95K / year Posted 6 days ago
Apply now
Work from
United States
Contract
Full-time
Salary
$80K – $95K / year
Posted
15 November 2026
Apply by
14 January 2027

This position will support the Summit Data Platform by integrating data from diverse sources, modernizing legacy data workflows, and delivering efficient, scalable data pipelines that meet established performance, quality, and governance standards

Please note, this position is contingent upon award (anticipated early 2027). This role will also require 1-2 domestic business trips per year.

Responsibilities

Design, develop, and maintain ETL and Extract, Load, and Transform (ELT) pipelines to ingest, process, and integrate data from enterprise systems, legacy platforms, and cloud-based sources.

Develop and optimize data transformation workflows using Azure Data Factory, Azure Databricks, Structured Query Language (SQL), Python, and related technologies.

Implement batch, incremental, and streaming data integration processes based on source system characteristics and operational requirements.

Transform raw data into standardized, consumption-ready datasets that support enterprise reporting, analytics, and downstream applications.

Develop and maintain pipeline orchestration, scheduling, dependency management, and automated error-handling capabilities.

Support migration and modernization of legacy data integration processes, ensuring data consistency and continuity between source and target environments.

Collaborate with data engineers and data quality specialists to implement automated validation, reconciliation, and data freshness checks within integration workflows.

Monitor and troubleshoot pipeline failures, processing delays, and performance issues, implementing corrective actions to improve reliability and efficiency.

Optimize data movement and transformation processes to improve processing speed, resource utilization, and cloud operating costs.

Collaborate with data governance specialists to implement approved data standards, metadata requirements, and data lineage documentation within integration workflows.

Maintain technical documentation, including source-to-target mappings, transformation logic, pipeline configurations, and operational procedures.

Requirements

Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related technical discipline, or an equivalent combination of education and relevant professional experience.

Five or more years of professional experience developing and maintaining enterprise ETL, ELT, or data integration solutions.

Strong proficiency in SQL and Python for data extraction, transformation, and processing.

Hands-on experience with Azure Data Factory, Azure Databricks, or comparable enterprise data integration technologies.

Experience integrating data from relational databases, application programming interfaces (APIs), flat files, and other enterprise data sources.

Experience developing and maintaining batch and incremental data processing workflows.

Knowledge of data transformation techniques, source-to-target mapping, and relational data modeling.

Experience implementing pipeline scheduling, orchestration, monitoring, and error handling.

Experience troubleshooting data integration failures and optimizing pipeline performance.

Familiarity with cloud-based data warehouses, data lakes, and lakehouse architectures.

Strong analytical, troubleshooting, communication, and collaboration skills.

Ability to meet VA personnel vetting, background investigation, and system access requirements.

The ability to travel for 1-2 domestic business trips per year.

Nice to have

Experience supporting VA or other federal agency data modernization initiatives.

Experience migrating legacy ETL processes to Microsoft Azure cloud environments.

Experience with Delta Lake, Azure Synapse Analytics, or dedicated SQL pools.

Experience implementing streaming or event-driven data integration using Apache Kafka or comparable technologies.

Familiarity with Continuous Integration and Continuous Delivery (CI/CD) practices for automated pipeline deployment.

Experience working with sensitive healthcare data and federal privacy and security requirements.

Microsoft Certified: Azure Data Engineer Associate or comparable data integration certification.

Benefits

Health, dental, and vision plans

Optional FSA

Paid parental leave

Safe Harbor 401(k) with employer contributions 100% vested from day 1

Paid time off and 11 paid holidays

No cost group term life/AD&D plan, and optional supplemental coverage

Pet insurance

Monthly phone and internet stipend

Tuition and training reimbursement

To cut down on falsified applications and to avoid subjecting real candidates to screening by AI assistants, phone interviews at Trilogy require either a landline or a cellphone number backed by a physical SIM. We cannot conduct interviews with candidates who provide VOIP contact numbers (including Google Voice).

Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

About Trilogy Federal

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our collaborative, client-first service approach, combined with our commitment to the rapid implementation of pragmatic solutions, has earned Trilogy an unparalleled reputation for delivering transformative results.

Trilogy Federal seeks an experienced Extract, Transform, and Load (ETL) Specialist to support the Department of Veterans Affairs (VA) Summit Advanced Tooling, Lakehouse, and Artificial Intelligence Services (Summit ATLAS) program. The ETL Specialist will develop, maintain, and optimize data integration processes that enable reliable movement and transformation of enterprise data for analytics, reporting, and artificial intelligence and machine learning (AI/ML) applications.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from Trilogy Federal

View company →

Technical Writer

Trilogy Federal
Remote United States Full-time $70K – $85K / year

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our…

5 days ago Content Creator

Data Analyst (FinOps)

Trilogy Federal
Remote United States Full-time $75K – $90K / year

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our…

5 days ago Data

Data Visualization Engineer

Trilogy Federal
Remote United States Full-time $75K – $90K / year

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our…

5 days ago Data

Data Governance Specialist

Trilogy Federal
Remote United States Full-time $70K – $85K / year

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our…

5 days ago Data

Similar remote jobs

Browse all →

Senior BI/DW Developer

Nextpower
Remote India Full-time

Job Description: BI/DW Architect (Finance Analytics & Insights) Position Summary The BI/DW Architect (Finance Analytics & Insights) is a strategic leader within the Global Controllership…

4h ago Data

Senior Analytics Solutions Lead – Power BI & Fabric

Cooper Equipment Rentals Limited
Remote Canada Full-time CAD 110K – CAD 130K / year

Build your Career at Cooper Equipment Rentals Please note, to be considered for this position applicants should currently be residing in Canada and legally entitled to work. Why Work with…

4h ago Data

ServiceNow Business Analyst

LIGHTFEATHER IO LLC
Remote United States Full-time $110K – $130K / year

LightFeather is seeking a Senior ServiceNow Business Analyst to lead the requirements gathering and process design for our federal agency clients. In this role, you will act as the critical…

4h ago Data

Senior Data Migration Specialist

WELLSTAR
Remote Canada Full-time CAD 75K – CAD 95K / year

Who we are At WELLSTAR , we are committed to reshaping Canadian healthcare by leveraging technology to address the administrative burdens that pull physicians away from their true calling,…

4h ago Data

Risk Adjustment Operations Senior Project Analyst

Datavant
Remote United States Full-time $103K – $121K / year

Datavant is the data collaboration platform trusted for healthcare. Guided by our mission to make the world’s health data secure, accessible and actionable, we provide critical data…

4h ago Data

Data Scientist

Timeleft
Remote Albania, Andorra, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Germany, Gibraltar, Greece, Guernsey, Holy See (Vatican City State), Hungary, Iceland, Ireland, Full-time

⌘Role Overview The Data Scientist is the first hire on the team whose job is to put machine learning into production , not just into a notebook. You'll build models that power product and…

5h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.