Data Analyst C/D (The Palliative and Advanced Illness Research Center)

Perelman School of Medicine at the University of Pennsylvania•Philadelphia, PA

34d•$61,000 - $100,000

About The Position

The Palliative and Advanced Illness Research Center is seeking two data managers to join a team of data managers and biostatisticians supporting the Center’s clinical trials, observational cohort studies, and pilot programs. The data managers will be responsible for deeply understanding PAIR’s study protocols and translating that understanding into the creation of appropriately structured analytic files, queries, data collection tools, data pipelines, and external data requests with data use agreements. The data managers must demonstrate a strong knowledge of research concepts and data structures, ideally in the healthcare setting, and communicate effectively and openly with collaborators, internal and external, about technical requirements and study design considerations. These individuals will also be responsible for planning for data acquisition, preservation, and destruction; establishing data use agreements on behalf of the Center; and maintaining complete documentation. The successful candidates must have significant data programming experience in R (preferred) and/or Python, and in SQL; experience with MS Access and SAS are also beneficial. Above all, attention to detail and the ability to clearly and concisely convey nuanced technical information to different audiences (project managers, investigators, technical and non-technical external stakeholders, biostatisticians, other data managers) will be essential to this individual’s success in the position.

Requirements

Experience analyzing complex data.
Experience programming in R or Python
Experience programming in SQL (or similar from other environments, e.g. SAS PROC SQL)
Excellent organizational skills and attention to detail
Excellent written and oral communication skills
Data Analyst C: Bachelor of Science and 2 to 3 years of experience or equivalent combination of education and experience is required.
Data Analyst D: A bachelor’s degree and 3-5 years of experience or equivalent combination of education and experience is required.

Nice To Haves

Experience with healthcare research and concepts
Epic Clarity certifications, especially from the Clinical Data Model track
Master's preferred.
Master's preferred.
Applicants with training and experience in querying electronic health record data structures, particularly Epic Clarity, will be considered for the more senior position, which will involve composing and validating complex SQL queries to retrieve health data according to real-life clinical documentation patterns.
Familiarity working with data generated from a variety of clinical processes (orders, labs, flowsheet, medications, alerts, episodes, notes, admission-discharge-transfer, appointments, referrals, etc.) will be a significant factor in evaluating candidates.

Responsibilities

Write R scripts to assess data quality, generate reports, and prepare analysis-ready datasets.
Design, test, and maintain data flows and databases to support study recruitment and data collection.
Create and maintain documentation for data resources created.
Contribute to the development of organizational systems for programs, data files, queries, and documentation files.
Review drafts and provide comments/revisions on data use agreements and develop plans to ensure their compliance.
Create flowcharts, summary documents, and other presentation aids to facilitate collective understanding of data-related workflows.
Provide training to research coordinators and project managers on data processes.
Provide constructive input in study team meetings and PAIR Center-wide discussions.
Perform other duties as assigned.

Benefits

Penn offers comprehensive medical, prescription, behavioral health, dental, vision, and life insurance benefits to protect you and your family’s health and welfare.
You can also use flexible spending accounts to pay for eligible health care and dependent care expenses with pre-tax dollars.
Take advantage of Penn's exceptional tuition benefits. You, your spouse, and your dependent children can get tuition assistance here at Penn. Your dependent children are also eligible for tuition assistance at other institutions.
Penn offers generous retirement plans to help you save for your future. Penn’s Basic, Matching, and Supplemental retirement plans allow you to save for retirement on a pre-tax or Roth basis. Choose from a wide variety of investment options through TIAA and Vanguard.
Penn provides you with a substantial amount of time away from work during the course of the year.
In partnership with Genworth Financial, Penn offers faculty and staff (and your eligible family members) long-term care insurance to help you cover some of the costs of long-term care services received at home, in the community or in a nursing facility.
Penn is committed to supporting our faculty and staff as they balance the competing demands of work and personal life. That’s why we offer a wide variety of programs and resources to help you care for your health, your family, and your work-life balance.
Penn provides an array of resources to help you advance yourself personally and professionally.
As a member of the Penn community, you have access to a wide range of University resources as well as cultural and recreational activities.
From arts and entertainment to transportation and mortgages, you'll find great deals for University faculty and staff.
Flexible work options offer creative approaches for completing work while promoting balance between work and personal commitments.
Penn offers a forgivable loan for eligible employees interested in buying a home or currently residing in West Philadelphia, which can be used for closing costs or home improvements.
Penn will reimburse eligible employees on qualified expenses in connection with the legal adoption of an eligible child, such as travel or court fees, for up to two adoptions in your household.