ETL Specialist

Salary Range: 80000 to 95000 (Currency: USD) (Pay period: per-year-salary)

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