Surgical Data Analyst - Department of Surgery

Surgical Data Analyst - Department of Surgery
*1 year temp position

About the job

The Surgical Data analyst will be responsible for receiving real world electronic health record data exported from multiple health systems and will be responsible for data transformation and normalization for the Research Evaluating Vagal Excitation Anatomical Links (REVEAL) and the Combat Wound Infection Evidence Based Medicine (CWI-EBM), two large funded multi-site clinical trials. REVEAL's focus is to collect and maintain a "first in kind" comprehensive dataset of clinical and biologic longitudinal data for vagus nerve stimulation which can have major scientific and clinical impact for a multitude of health conditions. This hire will be involved in innovative discussions, study planning and analyses. They will also integrate biological lab data and structured data collected using the study's REDcap database into the final study database known as the "Vagabase". The Data Analyst will report jointly to the (1) Director and (2) Project Manager of the REVEAL Data and Analysis Core (DAC). They will also be responsible for the transfer for the Vagabase and any relevant metadata and code to the NIH's public data repository. CWI-EBM's focus will be to develop the first ever joint military/civilian database for patients and extremity wound trauma. This database will be analysis/AI-ready and the Data Analyst will report directly to the University of Minnesota site-PI for data.

This job may be remote.

Principle Duties

Document project requirements, implementation plan, execution, and delivery (30%)
* Carefully document the process for and code generated for the delivery of the transformed and analysis-read 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.

Query, extract, integrate, format, and deliver data as per study needs (70%)
* 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 in 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.

All required qualifications must be documented on application materials

Required qualifications:
* 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.
* Experience must include a 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.)

Preferred Qualifications:
* 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.

Committed to innovation and diversity, the Medical School educates physicians, scientists, and health professionals; generates knowledge and treatments; and cares for patients and communities with compassion and respect. We value excellence, inclusiveness, collaboration, and discovery.

• Competitive wages, paid holidays, and generous time off
• Continuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit Program
• Low-cost medical, dental, and pharmacy plans
• Healthcare and dependent care flexible spending accounts
• University HSA contributions
• Disability and employer-paid life insurance
• Employee wellbeing program
• Excellent retirement plans with employer contribution
• Public Service Loan Forgiveness (PSLF) opportunity
• Financial counseling services
• Employee Assistance Program with eight sessions of counseling at no cost
• Employee Transit Pass with free or reduced rates in the Twin Cities metro area

Applications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.

Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.

To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-8647.

The University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.

The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.edu

The University of Minnesota, Twin Cities (UMTC)

The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.

At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America's Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).