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

About

University Overview
The University of Pennsylvania, the largest private employer in Philadelphia, is a world‑renowned leader in education, research, and innovation. This historic, Ivy League school consistently ranks among the top 10 universities in the annual U.S. News & World Report survey. Penn has 12 highly‑regarded schools that provide opportunities for undergraduate, graduate and continuing education, all influenced by Penn's distinctive interdisciplinary approach to scholarship and learning. As an employer Penn has been ranked nationally on many occasions with the most recent award from Forbes who named Penn one of America's Best Large Employers in 2023.

Penn offers a unique working environment within the city of Philadelphia. The University is situated on a beautiful urban campus, with easy access to a range of educational, cultural, and recreational activities. With its historical significance and landmarks, lively cultural offerings, and wide variety of atmospheres, Philadelphia is the perfect place to call home for work and play.

The University offers a competitive benefits package that includes excellent healthcare and tuition benefits for employees and their families, generous retirement benefits, a wide variety of professional development opportunities, supportive work and family benefits, a wealth of health and wellness programs and resources, and much more.

Position

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

Job Profile Title
Data Analyst C

Job Description Summary

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.

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.

Data Analyst D: 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.

Contingent Upon Funding.

Qualifications

Required

• 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.

Preferred

• Experience with healthcare research and concepts.
• Epic Clarity certifications, especially from the Clinical Data Model track.

Data Analyst C

• Bachelor of Science and 2 to 3 years of experience or equivalent combination of education and experience is required. Master's preferred.

Data Analyst D

• Bachelor’s degree and 3‑5 years of experience or equivalent combination of education and experience is required. Master's preferred.

• Experience with querying electronic health record data structures (e.g., Epic Clarity).

Location

Philadelphia, Pennsylvania

Department / School

Perelman School of Medicine

Pay Range

$61,000.00 – $100,000.00 Annual Rate
Salary offers are made based on the candidate's qualifications, experience, skills, and education as they directly relate to the requirements of the position, and in alignment with salary ranges based on external market data for the job's level. Internal organization and peer data at Penn are also considered.

Equal Opportunity Statement

The University of Pennsylvania is an equal opportunity employer. Candidates are considered for employment without regard to race, color, sex, sexual orientation, religion, creed, national origin (including shared ancestry or ethnic characteristics), citizenship status, age, disability, veteran status or any class protected under applicable federal, state or local law.

Special Requirements

Background checks may be required after a conditional job offer is made. Consideration of the background check will be tailored to the requirements of the job.

Benefits

• Health, Life, and Flexible Spending Accounts: Comprehensive medical, prescription, behavioral health, dental, vision, and life insurance; flexible spending accounts for eligible health care and dependent care expenses.
• Tuition: Tuition assistance for you, your spouse, and dependent children (including assistance at other institutions for dependent children).
• Retirement: Basic, Matching, and Supplemental retirement plans (pre‑tax or Roth) with a variety of investment options through TIAA and Vanguard.
• Time Away from Work: Substantial paid time off for vacations, personal affairs, illness, injury, and family needs.
• Long‑Term Care Insurance: Coverage for long‑term care services; new hires may enroll without underwriting.
• Wellness and Work‑life Resources: Programs and resources to support health, family, and work‑life balance.
• Professional and Personal Development: Resources for personal and professional advancement.
• University Resources: Access to libraries, athletic facilities, arboretum, art galleries, museums, performances, and other cultural/recreational activities.
• Discounts and Special Services: Discounts on arts, entertainment, transportation, mortgages, automobiles, cellular plans, movie tickets, theme park admissions, etc.
• Flexible Work Hours: Non‑traditional work hours, locations, and job structures to promote balance.
• Penn Home Ownership Services: Forgivable loan for eligible employees buying a home or residing in West Philadelphia (for closing costs or improvements).
• Adoption Assistance: Reimbursement for qualified adoption expenses (up to two adoptions).

To learn more, please visit: https://www.hr.upenn.edu/PennHR/benefits-pay

Application

To apply, visit: https://wd1.myworkdaysite.com/en-US/recruiting/upenn/careers-at-penn/job/Blockley-Hall/Data-Analyst-C-D--The-Palliative-and-Advanced-Illness-Research-Center-_JR00081005-1

jeid-a6a7c599c2eb894baf8e0557d4a5673d