Data Integrity Analyst

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 Integrity Analyst

Job Profile Title

Records Data Integrity Analyst

Job Description Summary

This position reports directly to the Senior Data Integrity Analyst and works to help identify patterns of inadequate/inconsistent/incomplete/incorrect data (including, but not limited to name presentation, contact data, academics, and employment information) for constituents, find solutions for acquiring good data using a variety of data resources, and ensure that constituent records are updated with this data. Work with DAR and ISC staff to assist with building and maintaining integrations with other Penn systems (Pennant, MyPenn Community, iModules etc.) The focus is on, but not limited to, VIP constituents and requires professional interaction with various development officers and staff members across campus.

Job Description

Job Responsibilities

• Write SQL queries and/or Salesforce reports to identify constituents with inadequate/inconsistent/incomplete/incorrect data, including name presentation and address and electronic contact data.  Develop solutions for acquiring good data and ensure that constituent records, focusing on VIPs, are updated appropriately.  Analyze and resolve other data integrity issues as assigned.  Review data for consistency, format, and accuracy.  Update data in a timely and organized fashion to assure the highest possible data quality.  Look for systematic and human errors and work with the Director, Associate Director, Senior Data Integrity Analyst, and ISC staff to correct and develop strategies to eliminate future data flaws, including the Applicant and Parent processes.
• Act as MyPenn Alumni Community Administrator, support data quality reviews in the alumni community, and assist alumni with issues submitted to the MyPenn Help Desk. This includes assisting with improvements to the integration between the alumni system of record, Compass, and MyPenn, as well as large scale data cleanup projects withi