Surgical Data Analyst – Department of Surgery

$63,419 - $104,624/Yr

University of Minnesota - Minneapolis, MN

Full-time - Entry Level

Minneapolis, MN

Educational Services

About the position

The Surgical Data Analyst will play a crucial role in managing and transforming electronic health record data for two significant clinical trials: REVEAL and CWI-EBM. This position involves data normalization, integration of biological lab data, and ensuring compliance with various standards. The analyst will work closely with the project team to document processes, execute data queries, and deliver analysis-ready datasets, contributing to impactful research in health conditions related to vagus nerve stimulation and extremity wound trauma.

Responsibilities

• Document project requirements, implementation plan, execution, and delivery.
• Carefully document the process for and code generated for the delivery of the transformed and analysis-ready dataset for the REVEAL study.
• Ensure that all study activities meet various compliance standards, IRB, and data security.
• Follow standard operating procedures and adhere to REVEAL study team policies and best practices.
• Discuss and provide feedback related to opportunities for enhancement with team management.
• Write code to query raw data and perform data transformation of EHR data extractions using SQL.
• Map data to common data model to facilitate generalizability.
• Integrate biological lab data and structured data collected using the study’s REDcap database into the final study database.
• Work closely with other team members to review execution plans and validate results.
• Work with and support data transformation needs for the downstream data scientist team including any iterative modifications of variables generated and data validation.
• Facilitate regular transfers of a de-identified copy of the study database to external public repositories as required by the NIH.

Requirements

• BA/BS plus at least 2 years of relevant analytical or quantitative work experience, or a combination of education and work experience to equal at least six years.
• Minimum of three years of experience querying, formatting, and analyzing healthcare data such as inpatient/outpatient clinical records, labs, medications, provider data, and/or claims.
• Experience working with messy real-world electronic health record data.
• Experience working independently in a rapidly changing scientific environment.
• Proficiency with query development and report writing.
• Demonstrated experience with T-SQL and PL/SQL programming languages.
• Knowledge of healthcare data management concepts and regulatory/compliance policies (HIPAA, IRB, etc).

Nice-to-haves

• Knowledge of clinical data and healthcare code sets and ontologies (ICD9/ICD10, CPT, NDC/RXNorm, LOINC, etc).
• Epic Clarity certification.
• Familiarity with the OMOP common data models and data integration activities.
• Research experience is a plus.
• Exposure to statistical modelling and/or advanced analytics using R or Python.

Benefits

• Salary range of $63,419.20 - $104,624.00
• Potential for remote work