Senior Data Integration Specialist

Medisolv is a national leader in healthcare quality data management solutions for hospitals and providers. Its all‑in‑one quality management platform, ENCOR, helps healthcare organizations advance patient care by measuring and improving their performance on more than 500 national quality and safety measures, including those required by the Centers for Medicare and Medicaid, The Joint Commission, private payers, and state agencies. Medisolv now serves more than 1,800 hospitals and 15,000 providers nationwide.

As part of a recent investment by Bessemer Venture Partners Forge in 2023, the company is undergoing a period of transformation and growth.

At Medisolv, we empower healthcare organizations to achieve excellence in quality data management. We develop innovative solutions that advance patient care, streamline operations, and provide actionable insights. Our dynamic and collaborative team is the driving force behind this mission, and we are looking for a skilled Epic Data Integration specialist with expertise querying and analyzing data from Epic’s Caboodle and Clarity databases.

As Senior Data Integration Specialist, you will work closely with Medisolv clients to extract, transform and load clinical, financial and administrative healthcare data from Epic Caboodle data warehouses and Clarity reporting databases into Medisolv’s data platform which feeds our suite of reporting and analytics products.

What You’ll Accomplish - Your Performance Objectives In your first 30 days, you will:

• Onboard with the data team to understand workflows, tools, and team dynamics.
• Demonstrate proficiency in working with and locating key clinical data elements in Epic Caboodle and Clarity databases.
• Demonstrate proficiency in writing moderately complex SQL scripts.
• Become familiar with Medisolv's current Azure‑based data infrastructure and Databricks.
• Learn the existing end‑to‑end processes from Epic Caboodle and Clarity source data extraction, transformations and load into Medisolv’s data models.

In your first 3 months, you will:

• Learn the Medisolv data model into which Epic data is transformed and made available to Medisolv's suite of applications.
• Learn how to correct and enhance existing Epic transformation SQL code to meet end‑user requirements.
• Collaborate with other members of the data integration team to provide insight into Epic data reporting best practices.
• Become familiar with specific electronic clinical quality measure data use cases.

In your first 6 months, you will:

• Collaborate with other team members to use Databricks to develop sophisticated SQL code and some Python code to transform Epic Clarity/Caboodle sourced data into predefined Medisolv data objects.
• Assist with optimization of all existing Epic and other EHR Vendor data source transformation scripts.
• Learn data quality concepts in support of electronic clinical quality measures.

In your first 12 months, you will:

• Independently use Databricks to develop sophisticated SQL code and some Python code to transform Epic Clarity/Caboodle sourced data into predefined Medisolv data objects.
• Work on optimizing and validating all existing Epic transformation scripts.
• Create documentation and define Epic data reporting best practices.
• Learn how to read and interpret electronic clinical quality measure specifications.

Who We’re Looking For

- The Person al Competencies That Matter

Detail‑Oriented Data Professional: You understand the importance of data quality, accuracy and reliability when transforming patients’ healthcare data.

Collaborative Team Player: You thrive in cross‑functional teams, building strong relationships across technical and non‑technical stakeholders.

Adaptable Innovator: You embrace change and consistently seek out new tools and techniques to enhance data workflows.

Resilient and Optimistic: You approach challenges with a solutions‑focused mindset and view setbacks as opportunities for growth.

What You Bring - Skills and Experience

Required:

• 3+ years of experience querying and analyzing clinical and administrative data from Epic Clarity, Caboodle and/or Chronicles data using SQL.
• One or more of the following Epic
  
  Certifications:
  
  Clinical Data Model, Access Data…