Senior ETL Engineer - Azure Data Factory & Lakehouse

Trilogy Federal

United States

Remote

USD 80,000 - 95,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health benefits
Dental & Vision
Paid parental leave
401(k) match
Paid time off

Job summary

Trilogy Federal seeks an experienced ETL Specialist to design, develop, and optimize data integration pipelines for the VA Summit ATLAS program. You will ingest and transform data across enterprise systems, APIs, and cloud sources to enable analytics and AI/ML workflows.

You will implement batch, incremental, and streaming data integration, ensuring data quality, lineage, and governance while optimizing performance, cost, and reliability. Occasional domestic travel is required.

Qualifications

  • Bachelor’s degree or equivalent in a technical field.
  • 5+ years of experience developing enterprise ETL/ELT or data integration solutions.
  • Strong proficiency in SQL and Python for data manipulation.
  • Hands-on experience with Azure Data Factory, Azure Databricks, or similar tools.
  • Experience integrating data from relational databases, APIs, and flat files.
  • Experience designing batch and incremental data pipelines.
  • Knowledge of data transformation, source-to-target mapping, and data modeling.
  • Experience with pipeline scheduling, orchestration, monitoring, and error handling.

Responsibilities

  • Design, develop, and maintain ETL/ELT pipelines ingesting data from enterprise systems and cloud sources.
  • Optimize data transformation workflows using SQL, Python, and Azure services.
  • Implement batch, incremental, and streaming data integration.
  • Transform raw data into standardized, analytics-ready datasets.
  • Develop and maintain pipeline orchestration, scheduling, and error handling.
  • Support migration and modernization of legacy data integration processes.
  • Collaborate with data engineers and data quality teams for validations and lineage.

Skills

SQL
Python
ETL/ELT
Data integration
Data modeling
Batch processing
Streaming data
Cloud architectures
Troubleshooting
Analytics collaboration

Education

Bachelor’s degree in Computer Science / IT / Data Engineering

Tools

Azure Data Factory
Azure Databricks
Delta Lake
SQL Server / APIs integration

Job description

Trilogy Federal seeks an experienced ETL Specialist to design, develop, and optimize data integration pipelines for the VA Summit ATLAS program. You will ingest and transform data across enterprise systems, APIs, and cloud sources to enable analytics and AI/ML workflows.

You will implement batch, incremental, and streaming data integration, ensuring data quality, lineage, and governance while optimizing performance, cost, and reliability. Occasional domestic travel is required.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Azure ETL Engineer – Data Lakehouse & Analytics
Senior Azure ETL Engineer – Data Lakehouse & Analytics

Trilogy Federal • Arlington (VA)

On-site
USD 120,000 - 180,000
Health, dental, and vision plans
Optional FSA
Paid parental leave
+3
Senior Data Engineer — Azure Lakehouse & Pipelines
Senior Data Engineer — Azure Lakehouse & Pipelines

Trilogy Federal • United States

Remote
USD 140,000 - 190,000
Health plan
Dental plan
Vision plan
+5
Remote ETL Specialist — Data Pipelines & Cloud Integration
Remote ETL Specialist — Data Pipelines & Cloud Integration

Trilogy Federal • United States

Remote
USD 120,000 - 160,000
Health insurance
Dental insurance
Vision insurance
+4
Senior Azure Data Platform Engineer — ETL & Lakehouse
Senior Azure Data Platform Engineer — ETL & Lakehouse

Valiant Technologies LLC • Redmond (WA)

On-site
USD 140,000 - 190,000
Data Engineer (Fully Remote)
Data Engineer (Fully Remote)

Trilogy Federal • United States

Remote
USD 140,000 - 190,000
Health plan
Dental plan
Vision plan
+5
ETL Specialist
ETL Specialist

Trilogy Federal • Arlington (VA)

On-site
USD 120,000 - 180,000
Health, dental, and vision plans
Optional FSA
Paid parental leave
+3
Senior Full Stack Engineer - Azure Cloud & Data Platform
Senior Full Stack Engineer - Azure Cloud & Data Platform

Trilogy Federal • United States

Remote
USD 90,000 - 105,000
Health insurance
Dental insurance
Vision insurance
+2
ETL Specialist (Fully Remote)
ETL Specialist (Fully Remote)

Trilogy Federal • United States

Remote
USD 120,000 - 160,000
Health insurance
Dental insurance
Vision insurance
+4
Remote Senior Data Engineer – Lakehouse & Automation
Remote Senior Data Engineer – Lakehouse & Automation

Leidos • United States

Remote
USD 108,000 - 195,000
Competitive compensation
Health and Wellness programs
Income Protection
+1
Senior Data Visualization Engineer - Power BI & Azure BI
Senior Data Visualization Engineer - Power BI & Azure BI

Trilogy Federal • Arlington (VA)

On-site
USD 120,000 - 160,000
Health, dental, and vision plans
Flexible FSA option
Paid parental leave
+6