ROOTS Hub ETL Developer
About The Position
This position is specifically to support RHTP (Rural Health Transformation Program). The RHTP ETL Developer works independently, and collaboratively, to elicit requirements and create specifications. They then design, architect, and implement complex ETL/ELT solutions using Azure data services, Microsoft Fabric, Data Factory pipelines, Data Lakehouse architecture, Dataverse integrations, SQL-based transformations, and cloud-based data orchestration. The individual in this position interfaces with various functional teams as required to support the solution delivery. They proactively identify needs or issues, develop strategies, and propose/implement technical and process solutions. They interpret internal or external business issues and recommend best practices. They adapt precedent and may make significant departures from traditional approaches. Note: This position might require access to and use of confidential healthcare information or protected health information (PHI) as described in laws addressing patient confidentiality, including, but not limited to, the federal HIPAA law, the Confidentiality of Alcohol and Substance Abuse Patient Records law, 42 CFR Part 2, and various state laws. As such, the individual who filled this position shall be required to be trained in such laws and shall be required to observe those laws in his/her capacity as an employee of Vaya Partners. The individual filling this position shall also sign a confidentiality statement as an employee of Vaya Partners.
Requirements
- 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 data ingestion, transformation, orchestration, scheduling, monitoring, error handling, and performance optimization.
- Experience integrating Microsoft Dataverse, enterprise applications, databases, APIs, and external data sources across cloud and on-premises environments to support operational and analytical data needs.
- Extensive experience with Microsoft SQL Server, including database development, data integration, performance tuning, and data warehousing solutions.
- Expert-level proficiency in SQL and T-SQL, 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, 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.
- Experience gathering, analyzing, and documenting business and technical requirements, data mappings, specifications, and solution designs.
- Strong analytical, troubleshooting, and problem-solving skills with the ability 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 with the ability to effectively communicate technical concepts to both technical and non-technical stakeholders.
- Experience handling and protecting sensitive data, including Protected Health Information (PHI), in compliance with regulatory and organizational requirements.
- Strong proficiency with Microsoft 365, including Teams, SharePoint, and Office applications.
- A High School Diploma is required.
- Five (5) to seven (7) years of development experience are required for incumbents with a computer industry related degree.
- Five (5) to seven (7) years of development experience if specifically within in a healthcare or insurance related environment may be acceptable with a bachelor's degree in any field of study.
- Degrees other than the above listed bachelor's degrees can be accepted if there is significant work experience in a field related to the duties of this position.
Nice To Haves
- A Bachelor's Degree in the fields of Computer Engineering, Computer Science, Management Information Systems, or related business fields is preferred.
- A Microsoft certification in Azure, Fabric, SQL Server, Data Engineering, or related technologies is preferred.
Responsibilities
- Designing, developing, testing, and implementing ETL/ELT solutions to enable the analysis of data that supports strategic initiatives and ongoing business requirements. This includes building Azure Data Factory and Microsoft Fabric pipelines, integrating Dataverse and source system data, developing Lakehouse-based ingestion and transformation patterns, and supporting curated datasets for analytics and reporting.
- Proactively approaching business units and creating the best solution to address business needs and current infrastructure.
- Performing requirements analysis, solution design, development, and implementation of end-user requested data solutions.
- Further defining business requirements and providing specifications for end user sign off prior to development.
- Designing pipeline architecture, data mappings, transformation logic, data validation rules, scheduling, monitoring, and deployment approaches for Azure, Dataverse, Microsoft Fabric, Data Factory, Lakehouse, and related enterprise data platform solutions.
- Working with other development team members to coordinate User Acceptance Testing, obtain end user satisfaction with developed product, and implement the final solution.
- Demonstrating day-to-day adherence with change control procedures and practices and writing basic technical documentation.
- Monitoring 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.
- Communicating potential service problems by identifying patterns occurring across separate solutions and documenting remediation steps, operational procedures, source-to-target mappings, and support processes.
- Learning and improving upon the skills necessary to stay competitive in the field and coincide with the advances in technology.
- Participating in conferences, seminars, certification programs, etc. as applicable to ensure continued skill development and technical competency.
- Developing and executing industry security standards as they relate to Integrations development and as supported by adopted policy.
- Following industry standards and best practices to ensure the security of information, communications, data, etc. when developing solutions.
- Performing other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
High school or GED
