ETL Developer

This is a fully remote position, open to applicants in Florida, +5 more states.

📋 Description

• Gather requirements and develop specifications for RHTP ETL/ELT solutions.

• Design, create, test, and implement ETL/ELT solutions that align with strategic initiatives and business needs.

• Construct pipelines using Azure Data Factory and Microsoft Fabric.

• Integrate data from Dataverse and source systems.

• Create ingestion and transformation patterns based on Lakehouse architecture.

• Support curated datasets for analytics and reporting purposes.

• Design the architecture of pipelines, including data mappings, transformation logic, validation rules, scheduling, monitoring, and deployment strategies.

• Coordinate User Acceptance Testing to secure end-user approval and satisfaction.

• Adhere to change-control procedures and produce technical documentation.

• Oversee the health, performance, reliability, and data quality of ETL/ELT processes.

• Identify patterns in service issues and document remediation, operational procedures, mappings, and support processes.

• Engage in professional development activities.

• Develop and implement industry security standards for integrations.

• Safeguard confidential healthcare information and PHI in accordance with applicable regulations.

• Perform additional duties as assigned.

⛳️ Requirements

• A High School Diploma is mandatory.

• 5–7 years of development experience is required for candidates with a computer industry-related degree.

• 5–7 years of development experience in a healthcare or insurance-related setting may be acceptable with a bachelor's degree in any field.

• Significant work experience in a relevant field may substitute for the required bachelor's degrees.

• Practical experience with Azure Data Factory, Microsoft Fabric Data Factory, Microsoft Fabric Lakehouse, and SSIS is essential.

• Experience in integrating Microsoft Dataverse, enterprise applications, databases, APIs, and external data sources is necessary.

• Extensive experience with Microsoft SQL Server is required.

• Proficiency in SQL and T-SQL at an expert level is expected.

• Familiarity with data engineering best practices, metadata-driven processing, incremental loading, data quality, security, resiliency, documentation, version control, and CI/CD automation is important.

• Experience with Git and automated deployment frameworks is valuable.

• Proficient in Microsoft Visual Studio and SQL Server Management Studio.

• Experience with Microsoft Power Apps and Power Platform technologies is preferred.

• Background in data warehousing, dimensional modeling, and cloud-based analytics platforms is advantageous.

• Experience in gathering, analyzing, and documenting requirements, data mappings, specifications, and solution designs is needed.

• Familiarity with Agile/Scrum methodologies is required.

• Experience in managing and protecting PHI is essential.

• Strong proficiency in Microsoft 365, Teams, SharePoint, and Office applications is necessary.

• Microsoft certification in Azure, Fabric, SQL Server, Data Engineering, or related technologies is preferred but not mandatory.

• Candidates must reside in NC, SC, GA, TN, VA, MD, or FL.

🏝️ Benefits

• This is a remote, home-based virtual position.

• Opportunities for professional development through conferences, seminars, and certification programs.

• Eligibility for overtime compensation.

• Commitment to equal opportunity employment.