Sign upLog in

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

University of Pennsylvania

Philadelphia, PA

Apply
JOB DETAILS
SALARY
$61,000–$100,000 Per Year
SKILLS
Analysis Skills, Biostatistics, Clinical Data, Clinical Study Publications, Clinical Trial, Closing Costs, Communication Skills, Data Analysis, Data Collection, Data Management, Data Modeling, Data Quality, Data Sets, Data Structures, Detail Oriented, Documentation, Entertainment and Media, Epic Certification, Epic Clarity, Epic Systems, Funding, Healthcare, Legal, Maintain Compliance, Medical Record System, Medications, Microsoft Access Database, Mortgage, Music, News Reporting, Organizational Skills, Presentation/Verbal Skills, Project/Program Coordination, Project/Program Management, Python Programming/Scripting Language, Query Analysis, R Programming Language, Reporting Skills, Research Protocols, SQL (Structured Query Language), Scholarship, Scripting (Scripting Languages), Technical Presentation, Test Design, Theater Production, Training/Teaching, University Library, Writing Skills
LOCATION
Philadelphia, PA
POSTED
7 days ago


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.








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.





Job Description


Job Responsibilities


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.




DUTIES:


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:


A 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)






Job Location - City, State

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.




University Benefits

+ Health, Life, and Flexible Spending Accounts : 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.

+ Tuition : 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.

+ Retirement: 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.

+ Time Away from Work: Penn provides you with a substantial amount of time away from work during the course of the year. This allows you to relax, take vacations, attend to personal affairs, recover from illness or injury, spend time with family—whatever your personal needs may be.

+ Long-Term Care Insurance: 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. If you apply when you’re newly hired, you won’t have to provide proof of good health or be subject to underwriting requirements. Eligible family members must always provide proof of good health and are subject to underwriting.

+ Wellness and Work-life Resources : 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.

+ Professional and Personal Development: Penn provides an array of resources to help you advance yourself personally and professionally.

+ University Resources: As a member of the Penn community, you have access to a wide range of University resources as well as cultural and recreational activities. Take advantage of the University’s libraries and athletic facilities, or visit our arboretum and art galleries. There’s always something going on at Penn, whether it’s a new exhibit at the Penn Museum, the latest music or theater presentation at the Annenberg Center, or the Penn Relays at Franklin Field to name just a few examples. As a member of the Penn community, you’re right in the middle of the excitement—and you and your family can enjoy many of these activities for free.

+ Discounts and Special Services : From arts and entertainment to transportation and mortgages, you'll find great deals for University faculty and staff. Not only do Penn arts and cultural centers and museums offer free and discounted admission and memberships to faculty and staff. You can also enjoy substantial savings on other goods and services such as new cars from Ford and General Motors, cellular phone service plans, movie tickets, and admission to theme parks.

+ Flexible Work Hours: Flexible work options offer creative approaches for completing work while promoting balance between work and personal commitments. These approaches involve use of non-traditional work hours, locations, and/or job structures.

+ Penn Home Ownership Services: 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.

+ Adoption Assistance: 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.




​


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



The University of Pennsylvania’s special character is reflected in the wide variety of backgrounds, experiences, and perspectives of the Penn community. We seek talented faculty and staff who will constitute a vibrant community and help create an educational and working environment that best supports the University’s commitment to excellence in teaching, research, and scholarship. 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.

About the Company

U

University of Pennsylvania

Penn's beautiful urban campus provides easy access to a range of educational, cultural, and recreational activities. We offer excellent healthcare and tuition benefits for you and your family, as well as generous retirement benefits, professional development opportunities and flexible work options. Penn is a diverse, multicultural learning community at the cutting edge of research and information technology. Click here to read more about why we're a Best Employer. Not only does Penn offer a unique environment within the city of Philadelphia to work, we also provide a wide array of employee benefits. From a competitive retirement program and comprehensive health care options to health promotion and wellness services and tuition assistance, there's a wealth of opportunities and resources available to you at Penn.

Penn is frequently cited as an outstanding employer:

  • Recipient of the 2010 Terri Lynne Lokoff Child Care Foundation Corporate Leadership Award for commitment to supporting worklife balance programs.
  • Selected as a recipient of the 2010 Healthy Workplace Award by the Philadelphia Business Journal and presenting sponsor UnitedHealthcare
  • Recognized as a 2010 Top Workplace by The Philadelphia Inquirer/Daily News.
  • Recipient of the 2009 Vision Award for commitment to workforce diversity and economic inclusion.
  • Selected for Computerworld's 100 Best Places to Work in IT six years in a row!
  • Recognized by the Delaware Valley Association for the Education of Young Children as a 2006 Best Employer for Working Parents
  • Named a Best Place to Work in the November 2007 issue of Philadelphia Magazine.
  • Designated a Best Workplace for Commuters by the National Center for Transit Research
COMPANY SIZE
100 to 499 employees
INDUSTRY
Advertising and PR Services
FOUNDED
1990
WEBSITE
http://www.cmimedia.com/