ETL Specialist

Posted 5 Days Ago
Be an Early Applicant
Hiring Remotely in Arlington, VA, USA
In-Office or Remote
80K-95K Annually
Senior level
Information Technology • Financial Services
The Role
Develops, maintains, and optimizes enterprise ETL and ELT pipelines supporting analytics, reporting, and AI/ML applications. Responsibilities include integrating diverse data sources, modernizing legacy workflows, building batch, incremental, and streaming processes, orchestrating pipelines, implementing data validation and governance, troubleshooting failures, optimizing performance and cloud costs, and maintaining technical documentation for the VA Summit ATLAS program.
Summary Generated by Built In
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

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.

Skills Required

  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related technical discipline, or equivalent 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, 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
  • Ability to travel for 1-2 domestic business trips per year
  • 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 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
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Arlington, VA
121 Employees
Year Founded: 2009

What We Do

Founded in 2009 and headquartered in the Washington DC metro area, Trilogy Federal is a verified service-disabled, veteran-owned small business (SDVOSB) providing financial management and information technology consulting to the Federal government. Trilogy has an extensive and distinctive history helping Federal clients achieve their financial management goals. Our leadership team has over 60 years of combined experience supporting Federal financial management initiatives. Our professional staff specializes in federal financial management and maintains certifications in several relevant programs. Trilogy strives to provide its clients with a flexible and comprehensive approach to financial management with the ultimate goal of fiscal compliance and audit readiness. The Trilogy approach starts with assessing the financial management solution and determining its effectiveness in capturing functional business requirements and meeting agency reporting requirements. Since our inception, we have assisted our federal partners in migrating to new financial management systems or enhancing existing systems to meet new requirements. Ultimately, success lies in the data, where Trilogy utilizes industry leading Business Intelligence and Business Performance Management tools to assess the overall effectiveness of financial business operations and to produce timely, reliable and value-added financial reporting. We have a proven track record of successful implementations for agencies large and small.

Similar Jobs

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
10 Locations
40000 Employees
45K-85K Annually

General Motors Logo General Motors

Implementation Manager

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
8 Locations
165000 Employees
106K-141K Annually

Wipfli Logo Wipfli

Audit Manager, Tribal Industry

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
97K-131K Annually

Wipfli Logo Wipfli

Architect

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
129K-174K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account