Sr. ETL Developer/Team Lead - Healthcare SaaS
25 days ago
Miami
Job Description Company Overview: We are a fast-growing Healthcare Data Analytics SaaS company that empowers health systems, health plans, and accountable care organizations (ACOs) to make data-driven decisions that improve clinical, financial, and operational outcomes. Our platform provides real-time insights, population health analytics, risk stratification, and performance measurement capabilities that support value-based care and quality improvement initiatives. Position Summary This is a hybrid role with required in-office days. Candidates must be able to work from our office on designated days each week. The Senior ETL Developer / Team Lead will lead a team of ETL developers and data integration specialists responsible for designing, developing, optimizing, and maintaining enterprise data pipelines and ingestion frameworks. This role combines hands-on technical expertise with strong leadership and team management skills. The ideal candidate has deep experience in healthcare data (claims, EHR, eligibility, HEDIS/quality, risk adjustment), enterprise ETL development, and modern data engineering stacks. They will elevate our integration capabilities, enforce data quality standards, improve scalability, and ensure the timely delivery of mission-critical data feeds. Key Responsibilities Team Leadership & Management • Lead, mentor, and performance-manage a team of ETL developers and specialists., • Oversee workload planning, sprint execution, code reviews, and technical guidance., • Establish and enforce best practices for coding standards, documentation, and QA., • Provide coaching, career development, and skills advancement within the team., • Architect and optimize ETL/ELT frameworks for scalability, maintainability, and performance., • Lead the design of ingestion pipelines for healthcare data sources (837/835, 270/271, 277CA, CCD/C-CDA, FHIR, EMR flat files, HL7, ADT feeds, pharmacy claims, labs, etc.)., • Define data quality, validation, and reconciliation processes., • Develop ETL/ELT pipelines using tools such as Python, SQL, dbt, SSIS, Informatica, Talend, Matillion, or similar., • Write complex SQL queries, stored procedures, and performance-optimized transformations., • Implement automation, scheduling, and orchestration using Airflow, Azure Data Factory, or similar., • Collaborate with product managers and client success teams to translate data requirements into technical specifications., • Troubleshoot complex data issues, root-cause defects, and implement long-term fixes., • Support onboarding of new clients, new data feeds, and new data products., • Implement continuous improvement processes and automation to reduce manual work., • Ensure robust monitoring, alerting, and logging for all pipelines., • Maintain clear documentation of data mapping, transformations, and workflows., • 8+ years of experience in ETL/ELT development, data engineering, or data integration., • 3+ years leading or managing ETL or data engineering teams., • Expert SQL skills and strong experience with relational databases (SQL Server, Postgres, Redshift, BigQuery)., • Hands-on experience with ETL tools (SSIS, Talend, Matillion, dbt, ADF, Airflow, etc.)., • Strong background in healthcare data integration, including formats such as:, • Claims: 837/835, encounter data, • Eligibility & enrollment: 270/271, monthly rosters, • Clinical: HL7, FHIR, CCD/C-CDA, EMR exports, • Quality/Risk: HEDIS, CMS models, risk adjustment, • Experience designing scalable data pipelines., • Strong understanding of data modeling, warehousing concepts, and MDM., • Experience implementing data validation, QA frameworks, and reconciliation logic., • Background in value-based care, population health, or Medicare Advantage analytics., • Experience with real-time or streaming data (Kafka, Kinesis, EventHub)., • Experience integrating with EHR systems (Epic, Cerner, Athena, eClinicalWorks, NextGen, etc.)., • Familiarity with SOC 2, HIPAA, PHI, and HITRUST data governance., • Experience with agile methodologies and JIRA/Azure DevOps., • Establish a predictable, well-governed ETL development cycle with strong QA discipline., • Reduce data processing errors through automated QA and validation layers., • Improve pipeline performance and reduce latency across ingestion workflows., • Implement scalable frameworks for onboarding new clients and data feeds., • Increase team productivity through mentorship, automation, and process improvements., • Competitive salary, • Health, dental, and vision insurance, • Generous PTO and holidays