Senior Epic 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 Epic 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 Personal 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 Model, Revenue Data Model or other relevant certification.
• Strong understanding of clinical and administrative EHR documentation workflows and how they translate into the data stored in the Epic Clarity and Caboodle databases.
• Familiarity with Big Data platforms like Databricks or Snowflake.
• Strong verbal and written communication skills to explain complex data concepts to technical and non-technical team members.

Preferred:

• Familiarity with clinical quality measures.
• Familiarity with Python, Scala, Java or R.

Why You'll Love Working Here

At Medisolv, we value our people and the unique perspectives they bring to our mission. Here, you'll find:

• A collaborative and innovative work environment.
• Opportunities for professional development and continuous learning.
• A mission-driven culture that prioritizes making a meaningful impact on the healthcare industry.

Ready to join us on this exciting journey? Apply now and help us transform healthcare through the power of data!

Medisolv is committed to creating a diverse and inclusive workplace. We believe that diversity drives innovation, and we are dedicated to fostering an environment where all employees feel valued and respected.

Candidates must successfully complete a pre-employment background check and be legally authorized to work in the United States, as sponsorship is not available.