Data Integration Specialist - Remote

Who are we?

Medisolv was founded over 25 years ago with the simple idea that software can unlock information buried in the chaos of health care data. We are a growing company focused on developing software applications that give hospitals tools to measure and improve their care. At Medisolv, we work with passion, excellence, integrity and innovation.

At Medisolv, you can expect an environment where employees feel motivated, challenged, and encouraged. Our office is located in Columbia, MD and have employees working remotely in 29 states. Our team understands work life balance and that we have a life beyond our desks.

What we offer:

• Medical, dental and vision insurance
• Employer paid group life insurance
• Employer paid long term disability
• 401k with company match
• FSA and HSA
• Flexible work schedules
• Paid time off and holidays
• Paid parental leave
• Annual in person & virtual team-building events
• Employee recognition awards
• Annual performance review and merit increase

Medisolv is seeking a Healthcare Data Integration Specialist with expertise querying and analyzing EHR data. As Healthcare Data Integration Specialist, you will work closely with Medisolv clients to extract, transform and load clinical and financial healthcare data from clients' EHR databases/data warehouses into Medisolv's normalized data repository which feeds our suite of reporting and analytics products. You will also serve as the EHR data subject matter expert at Medisolv and will advise other members of the Medisolv data team on best practices for querying the data.

Responsibilities:

• Create, test and maintain SQL ETL scripts used to extract data from client EHRs, primarily working with clients' Athena Health data, but may also be required to work with other EHR vendor databases (Epic, Cerner, Allscripts, Meditech, eCW, etc.)
• Work closely with clients to modify ETL scripts to address data issues related to client documentation workflow variability
• Validate data pipeline output against EHR source databases
• Serve as Medisolv's EHR data subject matter expert
• Advise members of the Medisolv data team on best practices for querying EHR data
• Monitor and troubleshoot issues with ETL data pipelines
• Create and maintain internal and client facing technical documentation

Qualifications:

• Minimum of three years of experience querying and analyzing EHR data is required (Epic, Cerner, Allscripts, Meditech, eCW, etc.)
• Experience working with Microsoft SQL Server (or other SQL technology) required
• Experience performing data validation on complex datasets
• Working knowledge of Standard Code Systems (ie. CPT, ICD, LOINC, SNOMED, RxNorm, etc.)
• Ability to lead discussions with clients to investigate root cause of data related issues.
• Excellent communication skills, both written and verbal; ability to document and explain schema elements, overall architecture, and system-approach to both management and engineering staff.
• Successful completion of a pre-employment background check
• Must be authorized to work for any employer in the U.S. We are not currently able to provide sponsorship for this position.

Preferred Qualifications:

• Experience querying Athena Health EHR data is preferred
• Experience using FHIR or EHR vendor specific APIs.
• Experience working with ETL processes and procedures.
• Familiarity with one or more key health data standards, including: HL7, FHIR, CDA, CCD.
• Familiarity with eCQM and Meaningful Use measures.
• Working knowledge of HIPPPA data security requirements.

Education:

• Bachelor's degree (or higher) in relevant discipline or equivalent experience.

This is a remote opportunity.