ETL Specialist

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 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.

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.

Primary 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.
Minimum 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.
Preferred Qualifications:
  • 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 (including but not limited to):
  • 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

$80,000 - $95,000 a year

This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Data Quality Engineer
Data Quality Engineer

Trilogy Federal • United States

Remote
USD 85,000 - 100,000
Health, dental, and vision plans
401(k) match
Paid time off and holidays
+3
Data Quality Engineer
Data Quality Engineer

Trilogy Federal • Arlington (VA)

On-site
USD 110,000 - 160,000
Health, dental, and vision plans
401(k) with company match
Paid time off and holidays
+3
Full Stack Engineer – CDW Migration
Full Stack Engineer – CDW Migration

Trilogy Federal • United States

Remote
USD 90,000 - 105,000
Health insurance
Dental insurance
Vision insurance
+2
QA Engineer
QA Engineer

Trilogy Federal • United States

Remote
USD 75,000 - 90,000
Health, dental, and vision plans
Optional FSA
Paid parental leave
+6
Data Visualization Engineer
Data Visualization Engineer

Trilogy Federal • United States

Remote
USD 75,000 - 90,000
Health, dental, and vision plans
401(k) match
Paid time off
+3
Data Governance Specialist
Data Governance Specialist

Trilogy Federal • United States

Remote
USD 70,000 - 85,000
Health insurance
Dental coverage
Vision coverage
+9
AI/ML Engineer
AI/ML Engineer

Trilogy Federal • Arlington (VA)

On-site
USD 150,000 - 190,000
Health, dental, vision insurance
401(k) with company match
Paid time off and holidays
+1
Data Visualization Engineer
Data Visualization Engineer

Trilogy Federal • Arlington (VA)

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

Trilogy Federal • Arlington (VA)

On-site
USD 110,000 - 150,000
Health insurance
Dental insurance
Vision plan
+8