Data Analyst C​/D; Palliative and Advanced Illness Research Center

Job Title

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

The Palliative and Advanced Illness Research Center seeks two data managers to support clinical trials, observational cohort studies, and pilot programs. The role requires deep understanding of study protocols and translation into analytic files, queries, data pipelines, and external data requests, including data use agreements.

Data managers will also plan data acquisition, preservation, destruction, draft data use agreements, and maintain documentation.

Proficiency in R (preferred) and/or Python, with SQL; experience with MS Access and SAS beneficial.

• 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 created data resources.
• Contribute to development of organizational systems for programs, data files, queries, and documentation files.
• Review drafts and provide comments/revisions on data use agreements and develop compliance plans.
• Create flowcharts, summary documents, and other presentation aids to clarify 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.

Applicants with experience querying electronic health record data structures, especially Epic Clarity, will be considered for the senior position. The role involves composing and validating complex SQL queries and familiarity with data from various clinical processes.

• Experience analyzing complex data.
• Programming proficiency in R or Python.
• Programming proficiency in SQL (or similar, 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.
• Preferred:
  Epic Clarity certifications, Clinical Data Model track.

• Data Analyst C: Bachelor of Science and 2–3 years experience;
  Master’s preferred.
• Data Analyst D: Bachelor’s degree and 3–5 years experience;
  Master’s preferred. Experience with querying EHR data structures (e.g., Epic Clarity) required.

Philadelphia, Pennsylvania

Perelman School of Medicine

$61,000.00 – $ annual rate.

Background checks may be required after a conditional job offer is made.

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, citizenship status, age, disability, veteran status or any class protected under applicable federal, state or local law.