Quick Summary
NovumHealth is hiring a Remote SQL ETL Developer with hands-on experience in building and maintaining robust data pipelines. This role is ideal for a data engineering or ETL operations professional ready to apply their expertise in a mission-driven healthcare environment. You will own end-to-end ETL workflows, write production-quality SQL, and collaborate with analysts and business stakeholders to deliver accurate, timely healthcare data.
About NovumHealth
NovumHealth partners with Medicaid health plans to manage high-acuity members through specialized behavioral health care coordination. We engage members during inpatient admissions, facilitate transitions to community-based care, and reduce avoidable utilization. Our work drives measurable cost and outcome improvements for health plans and enhances the lives of members.
About the Role
As a SQL ETL Developer, you will be instrumental in developing and maintaining critical data pipelines. This position requires a strong understanding of SQL, cloud data platforms, and a commitment to data accuracy within the healthcare sector.
Key Responsibilities
- Collaborate with leadership to define pipeline specifications, then build and maintain SQL-based ETL pipelines supporting internal reporting and analytics.
- Write efficient, well-documented SQL queries for data extraction, transformation, and loading across systems.
- Perform monthly ETL and database maintenance for cloud-based data tables.
- Conduct data validation and cleansing to ensure accurate and trustworthy datasets.
- Troubleshoot and debug data issues within existing workflows.
- Partner with data analysts and business users to translate reporting needs into effective data solutions.
- Document ETL processes, data sources, and schemas.
- Participate in team meetings, sprint planning, and code reviews.
Required Qualifications
- Bachelor's degree in Business Analytics, Data Analytics, Health Informatics, Computer Science, or a related field.
- Advanced SQL skills, including complex joins, subqueries, window functions, and query optimization.
- 2–4 years of hands-on experience designing, building, and maintaining ETL pipelines in a professional environment.
- Experience working with large, complex datasets.
- 2–4 years of hands-on experience with at least one cloud data platform (e.g., Microsoft Fabric, Snowflake, Databricks, Azure Synapse).
- Intermediate Excel skills (formulas, pivot tables, basic analysis).
- Strong written and verbal communication skills.
- Self-motivated problem solver capable of independent work and team collaboration.
Preferred Qualifications
Candidates with the following will be given strong consideration:
- Proficiency in Power BI or similar BI tools.
- Exposure to healthcare data: CPT/ICD codes, HEDIS metrics, NCQA reporting, or value-based care frameworks.
- Salesforce reporting and object development experience.
- Programming experience in Python, PHP, Java, or R.
- Familiarity with Epic or other EMR/EHR systems.
- Certified Healthcare Data Analyst (CHDA) certification or equivalent.
- Behavioral health or managed care experience.
Stretch Responsibilities
Beyond core ETL development, this role may also include:
- Data modeling and normalization on healthcare datasets for prospective clients.
- Backup support for data analysts on reporting tools.
- Ad hoc analytics support for clinical and operations teams.
- End-user technical support for clinical and operations staff.
What Success Looks Like
- Pipelines run accurately and on schedule.
- Data issues are diagnosed and resolved without disrupting downstream reporting.
- Analysts and business users receive the data they need, when they need it.
- Documentation keeps pace with the work.
- You deepen expertise in healthcare data domains and take on expanded ownership of cloud platform workflows within the first year.
Who You Are
- Proactive and resourceful in solving problems.
- Comfortable in a fast-moving environment with shifting priorities.
- Clear communicator with both technical and non-technical audiences.
- Collaborative but capable of working independently to meet deadlines.
- Driven to use data to improve healthcare outcomes.
What We Offer
- Competitive base salary and performance bonus.
- Medical, dental, and vision coverage.
- Employer-paid Life and AD&D Insurance.
- 401(k) with company match.
- Paid time off and company holidays.
- Real-world healthcare data experience in a mission-driven, growing company.
Pay: From $85,000.00 per year
Benefits: 401(k) matching, Dental insurance, Employee discount, Flexible schedule, Flexible spending account, Health insurance, Health savings account, Life insurance, Paid time off, Vision insurance.
NovumHealth is an equal opportunity employer. We consider qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other protected characteristic. We comply with the Americans with Disabilities Act and provide reasonable accommodations during the application and employment process.
Work Location: Remote