Data Engineer

Data Engineer - Dialysis / ESRD - 100% Remote

Summary:

Innovative Renal Care (IRC) is seeking a hands-on, execution-focused Data Engineer to build, optimize, and maintain our operational data infrastructure and analytical platforms.

In this role, you will work closely with our Application Development and IT teams to design operational backend databases, construct REST API integrations, write optimized ETL/ELT pipelines, and support internal software systems. You are a practitioner who loves getting into the technical details - whether that means tuning a slow SQL/PySpark query, designing normalized and dimensional schemas, or implementing strict automated data quality checks for healthcare data.

Essential Functions:

• Collaborates directly with Software/App Dev teams to design, build, and maintain operational database backends and REST API integrations for internal healthcare software applications.
• Builds, monitors, and maintains resilient, automated ETL/ELT pipelines using Python, PySpark, dbt, and Cloud platforms (Azure / AWS / Snowflake).
• Designs both normalized (3NF) relational database schemas for transactional applications and dimensional (Kimball/star-schema) models for analytics and BI reporting.
• Proactively diagnoses and resolves performance bottlenecks across SQL queries, Snowflake workloads, and PySpark jobs using query profiling, indexing, repartitioning, and clustering techniques.
• Implements robust error handling, automated alerting (Slack/PagerDuty/dbt tests), and dead-letter queue patterns to quickly debug and resolve upstream data anomalies with minimal downtime.
• Ensures strict compliance with HIPAA and PHI requirements by implementing data masking, role-based access control (RBAC), and validation rules across all patient data pipelines.
• Maintains clear technical documentation for data flows, database schemas, and API contracts.

Required Education and Experience:

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field.
• 3+ years of experience of hands-on, full-time experience building, deploying, and maintaining production data pipelines and backend databases in an enterprise or in-house product environment.
• Strong proficiency in Python (or PySpark) and Advanced SQL (complex joins, CTEs, window functions, stored procedures, and query execution plan tuning).
• Direct experience with modern cloud data warehousing tools such as Snowflake, dbt, or Azure Data Factory / Databricks.
• Hands-on experience designing and supporting operational relational databases (e.g., SQL Server, PostgreSQL, or Azure SQL) and integrating with REST APIs.
• Demonstrated experience handling sensitive healthcare/clinical data, protected health information (PHI), and adhering to HIPAA compliance standards. (Experience with ESRD, dialysis data, or EMR/EHR system integrations is a strong plus).

At Innovative Renal Care (IRC), our comprehensive benefits program is a key component of our total compensation package. It includes a 401(k) match, healthcare coverage, and a broad range of other benefits that compare favorably within our industry and marketplace. Learn more atIRC Benefits and Perks

About Innovative Renal Care

We are one of the largest dialysis service providers in the U.S., partnering with local physicians to deliver high-quality care to patients with ESRD and other kidney conditions. Our mission is to be the trusted experts and preferred partners for patients, physicians, and healthcare providers by delivering best-in-class care, service, and solutions.

Our Values: I CARE

Integrity & Innovation - Earn trust by keeping promises and embracing new solutions.

Compassion - Treat patients, families, and colleagues with respect and empathy.

Accountability - Take ownership and recognize the contributions of others.

Results-Driven - Strive for excellence and exceed expectations.

Everyone Counts - Foster diversity, equity, teamwork, and collaboration.

Why Join IRC?

• Career Growth - Be part of a values-driven team making a meaningful impact.
• Competitive Compensation - Salaries continually benchmarked against market and trends.
• Enhanced PTO - Your most recent dialysis experience counts toward PTO accrual.
• Team Culture - Thrive in a supportive environment that values innovation, accountability, and compassion.

Innovative Renal Care is an equal opportunity and a drug free workplace.All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origins, citizenship, disability or protected veteran status.All applicants will be subject to a drug screening and background check upon acceptance of an offer.

*IRC will only contact you from careers@innovativerenal.comor team members with an @innovativerenal.comemail address. Please be cautious and aware of spam or fraudulent emails soliciting personal or banking information. IRC will not request this information via email.