Data Analyst

Job location: Perelman Center-FL7

Employment Type: Full-time
Posted data: 2021-09-09
Req: JR00004703
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 Employers By State in 2021.

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

Job Profile Title

Data Analyst D

Job Description Summary

Data Analyst D
The data analyst will partner with the Faculty of the Penn Dermatology Oncology Center (PennDOC) and the Skin Biology and Disease Resource Based Center (SBDRC) to design, conduct, and publish research that improves the lives of patients with skin cancer and skin diseases. The data analyst will enjoy a collegial relationship with a dynamic group of surgeons, clinicians, and basic scientists dedicated to conducting practical research about skin cancer and skin diseases. The data analyst will also collaborate with clinical research coordinators in the Department of Dermatology and work with collaborating investigators from other specialties and outside institutions to ensure compliance with regulatory research requirements.
Applicants must have a strong background in creating and analyzing databases; knowledge in basic statistics; basic knowledge in regulatory requirements of the Institutional Review Board; excellent oral and written communication skills to work with a team and to draft research proposals and manuscripts; and organizational skills to prepare agendas and material for regular research team meetings.
The data analyst will receive mentorship from and report to the Director of Research Operations for the Department of Dermatology. The data analyst will have regular guidance from Faculty mentors, including Principle Investigators and Subject Matter Experts.

Job Description

With general direction, performs data analysis and assists with design of complex data models based upon business or research requirements. Often as part of a team, identifies and resolves required information flows and content issues, and transforms requirements into data designs and models. May perform analyses, development and evaluation on large databases and large complex installations. May provide reporting and decision support systems consultation. May provide data analysis expertise to one or more project or support teams. May work with vendor delivered solutions

Position contingent on funding.

Responsibilities

- Develops and analyzes databases as indicated for research projects including clinical trials, observational, retrospective, and prospective studies. Maintains and enhances the existing database for Mohs micrographic surgery at Penn. Collects and organizes data from patient charts and existing databases (e.g. SEER, Optum). Develop and implement quality control plans to ensure data integrity and compliance.

- Performs descriptive and inferential statistics, including regression analyses, and sample size calculations. Analyses may also include simple data descriptions (e.g., prevalence and incidence of outcomes), correlations, regression modeling (e.g., linear, logistic, cox proportional hazard models, mixed effects models, latent class analysis). Uses statistical programming language, such as SAS, STATA, R, or other programing language for analysis and collaborates with biostatistical experts when appropriate. Ability to use data visualization techniques in Tableau, Power BI, Excel, or with a programming language (e.g., R or Python. The analyst may need to learn additional statistical or bioinformatics (e.g., multi-omic data analysis) techniques for existing and/or future projects.

- Drafting and submission of research grant proposals and manuscripts:

Partners with Faculty to complete research grant proposals and manuscripts. Common contributions from the data analyst include: preparing tables to summarize data and figures to illustrate statistics; drafting relevant portions of research proposals and manuscripts; submitting manuscripts and proposals; and managing correspondence with authors, journal editors, and reviewers.

- Mentoring pre-doctoral research fellows and organizing research meetings:

Mentors pre-doctoral student researchers in study design and basic statistical analysis. Works with faculty mentors and Principle Investigators, including Director of PennDOC and PI/co-PI of the SBDRC to organize the agenda and materials for research group meetings.

- Perform additional duties as assigned

Duties

The data analyst will partner with the Faculty of the Penn Dermatology Oncology Center and the Skin Biology and Disease Resource Based Center to design, conduct, and publish research that improves the lives of patients with skin cancer and skin diseases. The data analyst will enjoy a collegial relationship with a dynamic group of surgeons, clinicians, and researchers dedicated to practical research about skin cancer and skin diseases. The data analyst will also collaborate with clinical research coordinators in the Department of Dermatology and interface with collaborating investigators and biostatisticians from other specialties and outside institutions.

The data analyst will create and analyze databases; apply basic statistics to data; design data tables and figures; assist with manuscript and grant proposal drafting; ensure compliance with research regulations; and prepare materials for regular research team meetings.

Qualifications

Required:

• 3-5 years experience. 1-2 years of prior experience in clinical research or an equivalent combination of education and experience.
• Bachelor's Degree or higher educational attainment in biostatistics, biomedical informatics, public health, or related field that ensures a fundamental understanding of research design considerations. Master's Degree preferred.
• Basic knowledge of regulatory requirements and how to appropriately fulfill them, including Institutional Review Board submissions.
• Ability to perform descriptive and basic inferential statistics, including regression analyses, and sample size calculations.
• Proficiency with basic computer programming skills, including basic Microsoft Office applications, e.g. Access, Word, Excel, PowerPoint.
• Experience using a statistical programming language, such as SAS, STATA, R, or other programming language.
• Working knowledge of relational database design, query, and reporting.
• Excellent interpersonal and communication (written and verbal) skills
• Ability to work both independently and with a team as well as the ability to manage up.
• Strong organizational and documentation skills.

Preferred

• Ability to import/export data into or from various formats into standard statistical software.
• Experience in verifying, documenting, and cleaning large data files.
• Experience with large administrative or claims datasets (e.g Medicare, SEER, NCDB, etc)
• Familiarity with data standards and coding conventions.
• Experience managing multiple projects effectively and meeting deadlines.
• Experience with data visualization techniques in Tableau, Power BI, Excel, or with a programming language (e.g., R or Python).
• Experience with mySQL or SQL

Working Conditions
Office, Library, Computer Room

Physical Effort
Typically sitting at desk or table

Contingent upon funding

Job Location - City, State

Philadelphia, Pennsylvania

Department / School

Perelman School of Medicine

Pay Range

$59,703.00 - $168,837.00

Affirmative Action Statement
Penn adheres to a policy that prohibits discrimination on the basis of race, color, sex, sexual orientation, gender identity, religion, creed, national or ethnic origin, citizenship status, age, disability, veteran status, or any other legally protected class.

Special Requirements
Background check 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