← Back to jobsJob ID col-cmwf8pogg0e2189hqfjuzbrcw

Trilogy FederalPosted 8 days ago

ETL Specialist

Full-time
Remote
5+ years
Competitive
Posted 8 days ago

Trilogy Federal is seeking an ETL Specialist to support the Department of Veterans Affairs Summit ATLAS program. The role develops, maintains, and optimizes data integration pipelines for the Summit Data Platform, supporting analytics, reporting, and AI/ML applications.

Posted
8 days ago
Source
jobs.lever.co
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

Qualifications

  • 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

Preferred

  • 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
  • Azure Data Engineer Certification

Required skills

Azure Data FactoryAzure DatabricksAzure Synapse AnalyticsDelta LakeETL/ELTEnterprise Data IntegrationPipeline OrchestrationPythonRelational Data ModelingSQL

Full job description

Trilogy Federal is seeking an ETL Specialist to support the Department of Veterans Affairs Summit ATLAS program. The role develops, maintains, and optimizes data integration pipelines for the Summit Data Platform, supporting analytics, reporting, and AI/ML applications.

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

Preferred

  • 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
  • Federal Data Modernization
  • Legacy ETL Migration
  • Microsoft Azure
  • Delta Lake
  • Azure Synapse Analytics
  • Dedicated SQL Pools
  • Streaming Data Integration
  • Event-Driven Data Integration
  • Apache Kafka
  • CI/CD
  • Automated Pipeline Deployment
  • Sensitive Healthcare Data
  • Federal Privacy Requirements
  • Federal Security Requirements
  • Azure Data Engineer Certification
  • 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
  • Full-time remote work

Company

  • Federal consulting for financial management and IT modernization
  • Arlington, Virginia, USA
  • http://trilogyfederal.com/
  • Founded in 2009
  • 51-200 employees

Qualifications

  • 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
  • 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
  • Five or more years of professional experience developing and maintaining enterprise ETL, ELT, or data integration solutions.

Required skills

  • Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Batch and Incremental Data Processing, Cloud Data Warehouses, Data Lakes, and Lakehouse Architectures, Delta Lake, ETL/ELT, Enterprise Data Integration, Pipeline Orchestration, Python, Relational Data Modeling, SQL

Experience

  • 5+ years

Job details

Employment type

Full-time

Seniority level

5+ years

Date posted

Nov 13, 2026

Work mode

Remote

Job source

jobs.lever.co

Company

Trilogy Federal

Information Technology & AI

Federal consulting for financial management and IT modernization

See all 3 jobs from Trilogy Federal →
  • Arlington, Virginia, USA
  • Information Technology & AI
  • 51-200 employees
  • Founded 2009
  • trilogyfederal.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Machine Learning, Computer Vision jobs

Apple

1d ago

New

Senior Computer Vision & Machine Learning Engineer

Full-timeOn-siteSunnyvale, CACompetitive

Apple is seeking a Senior Computer Vision & Machine Learning Engineer to develop real-time 3D perception, spatial input, and tracking technologies for future products.

Why similarSame rolePython

just now

1d ago

New

Senior Analysts, Data Science & Analytics

Full-timeHybridWhite Plains, NY$115K – $118K/yr

TransUnion hires Senior Analysts, Data Science & Analytics to deliver Commerce Signals data science work for clients, including measurement studies.

Why similarSame rolePython

First Citizens Bank

1d ago

New

Senior Data Engineer - ETL/ELT (Remote - NC, AZ, TX, FL)

Full-timeRemoteUnited StatesCompetitive

First Citizens Bank is hiring a Senior Data Engineer to implement, enhance, and support data pipelines and platform capabilities within established architectural patterns.

Why similarSimilar titlePythonSQL

Get new Machine Learning, Computer Vision jobs by email

Create job alert

ETL Specialist

Trilogy Federal · Competitive

Apply on company site