ROOTS Hub ETL Developer

Vaya Health’s ROOTS Hub ETL Developer role supports RHTP (Rural Health Transformation Program) by building the data foundation that helps teams analyze information tied to strategic initiatives and ongoing business needs. This position is a remote, home-based role operating Monday through Friday from 8:30am to 5:00pm EST, with work that spans requirements gathering, ETL/ELT solution design and delivery, and operational support in a healthcare and PHI-aware environment.

What you’ll do

• Design, develop, test, and implement ETL/ELT solutions that enable analysis aligned to strategic initiatives and current business requirements.
• Build Azure Data Factory and Microsoft Fabric pipelines, integrating Dataverse and source system data.
• Create Lakehouse-based ingestion and transformation patterns and support curated datasets used for analytics and reporting.
• Analyze requirements, design solutions, and implement end-user requested data capabilities.
• Contribute to defining business requirements, producing specifications for end-user sign-off before development.
• Design pipeline architecture including data mappings, transformation logic, validation rules, scheduling, monitoring, and deployment approaches across Azure, Dataverse, Microsoft Fabric, Data Factory, Lakehouse, and related enterprise data platforms.
• Coordinate User Acceptance Testing, confirm end-user satisfaction, and deliver the final solution.
• Follow change control procedures and practices, and produce basic technical documentation.
• Monitor the health, performance, reliability, and data quality of supported ETL/ELT processes, including Azure Data Factory and Microsoft Fabric pipelines, Lakehouse loads, and Dataverse integrations.
• Identify patterns that may indicate service issues across separate solutions, document remediation steps, operational procedures, source-to-target mappings, and support processes.
• Develop and execute security standards applicable to integration development in line with adopted policy.
• Apply industry standards and best practices to protect information, communications, and data throughout solution development.

Core qualifications

• 5+ years of hands-on experience designing, developing, and supporting ETL/ELT solutions using Azure Data Factory (ADF), Microsoft Fabric Data Factory, Microsoft Fabric Lakehouse, and SQL Server Integration Services (SSIS), including ingestion, transformation, orchestration, scheduling, monitoring, error handling, and performance optimization.
• Experience integrating Microsoft Dataverse with enterprise applications, databases, APIs, and external sources across cloud and on-premises environments.
• Extensive experience with Microsoft SQL Server, including database development, data integration, performance tuning, and data warehousing solutions.
• Expert-level SQL and T-SQL skills, including complex queries, stored procedures, functions, views, data modeling, and query optimization.
• Strong knowledge of data engineering best practices, including metadata-driven processing, incremental loading, data quality management, security, resiliency, documentation, version control, and CI/CD automation.
• Experience with source control and DevOps tools, including Git and automated deployment frameworks.
• Proficiency with Microsoft Visual Studio and SQL Server Management Studio (SSMS) and related development tools.
• Experience with Microsoft Power Apps and other Power Platform technologies.
• Experience with data warehousing, dimensional modeling, and modern cloud-based analytics platforms.
• Ability to gather, analyze, and document business and technical requirements, data mappings, specifications, and solution designs.
• Strong analytical and troubleshooting skills to diagnose and resolve complex data, integration, and performance issues.
• Experience working in Agile/Scrum environments and managing multiple priorities in a fast-paced, deadline-driven setting.
• Excellent verbal and written communication skills for technical and non-technical stakeholders.
• Experience handling and protecting sensitive data, including Protected Health Information (PHI), in alignment with regulatory and organizational requirements.
• Strong proficiency with Microsoft 365, including Teams, SharePoint, and Office applications.
• A High School Diploma is required; a Bachelor’s degree in specified fields is preferred.
• Microsoft certification in Azure, Fabric, SQL Server, Data Engineering, or related technologies is not required, but preferred.

Technologies

• Azure Data Factory (ADF), Microsoft Fabric Data Factory, Microsoft Fabric Lakehouse, SQL Server Integration Services (SSIS)
• Microsoft Dataverse, SQL Server, SQL, T-SQL
• Microsoft Visual Studio, SQL Server Management Studio (SSMS)
• Microsoft Power Apps, Power Platform
• Git, Microsoft 365 (Teams, SharePoint, Office applications)
• Agile/Scrum, CI/CD

Location and scheduling

• Remote (home-based, virtual position) with Monday–Friday hours from 8:30am–5:00pm EST.
• Vaya Partners welcomes applications from candidates living in NC, SC, GA, TN, VA, MD, or FL.
• Residency requirement: the person in this position must live in NC, SC, GA, TN, VA, MD, or FL.

Additional notes

• This role may require access to confidential healthcare information, including PHI, and requires training in applicable laws (including HIPAA and 42 CFR Part 2) as well as observing those laws as an employee of Vaya Partners.
• The individual must sign a confidentiality statement as an employee of Vaya Partners.

Compensation and application

• Salary range: USD 92,558 - 120,326 per year.
• Depending on qualifications and experience of the candidate.
• This position is Exempt and eligible for overtime compensation.
• Application deadline: open until filled.
• Apply via Vaya Partners Career Center: https://www.vayahealth.com/about/careers/.