SAVE

Data Integrity Analyst

University of Pennsylvania

Details

Posted:

March 1, 2025

Location:

Philadelphia, Pennsylvania

Show Map

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 within the community. Work with DAR, ISC, and Registrar staff to ensure the accuracy of academic data in both Compass and MyPenn, including work on enhancements to the integration with Pennant.
Assist schools and centers for VIP data integrity issues. Assist the Senior Data Integrity Analyst with data validation processes. Assist with the Parent Process working closely with ISC, Admissions and the Parents Program on accurate and timely delivery of incoming first-year students. Assist with data analysis and cleanup to facilitate outreach to parents of incoming students.
Act as Data Administrator for the Penn Online Community. This position is responsible for creating PennKey setup codes for alumni and assisting/troubleshooting alumni PennKey requests. This responsibility requires significant external client interactions including Alumni and Volunteers.
Assist with testing and validating bug fixes and enhancements for the development database of record (Compass).
Additional responsibilities require working closely with Gifts Accounting & Administration and performing gift processing during peak periods and as needed.
Special update projects as requested by DAR or as determined necessary through data analysis or quality control reports. Assist with answering office phones, data loads and updates via the Batch Review and Import Tool (BRIT), contact adjustment cases, backing up other daily responsibilities of the DAR Records Office, and other duties as assigned.
Required to work Alumni Weekend, Winter Break, the Penn Reunion Leadership Conference (PRLC), and when needed, Homecoming.
The work hours are Monday - Friday 9:00 a.m. to 5:00 p.m.

Qualifications:

High School Diploma and 5-7 years' experience in data analysis, preferably in development and alumni relations or equivalent combination of education and experience required. Knowledge of second language preferred. Development experience preferred. Excellent data entry and analysis skills required. Knowledge of Excel and Word required. Knowledge of Business Objects and Access software preferred. Knowledge of SQL and/or R programming languages strongly preferred. Experience with Salesforce, particularly Sales Cloud, Service Cloud, Community Cloud, and Salesforce reports preferred. Must demonstrate the ability to provide excellent customer service to a diverse group of alumni, development officers and other co-workers, and other professionals. Must be able to manage multiple daily tasks while working quickly, accurately, and independently. Must have high comfort level with web research and tools.

Ability to work in a collegial and collaborative environment.

Ability to staff events as needed.

Ability to lift up to 25 pounds.

Job Location - City, State
Philadelphia, Pennsylvania

Department / School
Development and Alumni Relations

Pay Range
$20.45 - $29.67 Hourly 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, as well as internal and market factors and

the pay range assigned to the job profile.

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

To apply, visit https://wd1.myworkdaysite.com/en-US/recruiting/upenn/careers-at-penn/job/FMC-Tower-Development/Data-Integrity-Analyst_JR00103664-1

Internal Number: 6044016

About University of Pennsylvania

Penn has a long and proud tradition of intellectual rigor and pursuit of innovative knowledge, begun by Benjamin Franklin in 1740. That tradition lives today through the creativity, entrepreneurship, and engagement of our faculty, students, and staff. Academic life at Penn is unparalleled, with an undergraduate student body of 10,000 from every U.S. state and around the world. The entering class of 2015 is the most talented and diverse in Penn's history. Consistently ranked among the top 10 universities in the country, Penn welcomes an additional 10,000 students to our top-ranked graduate and professional schools.

More Jobs from This Employer

More Jobs Like This

Principal Human Resources Analyst (Employee Relations)	Fountain Valley, California
Orange County Sanitation District	Yesterday
Principal Trainer	Remote, Oregon
St. Charles Health System	Today
Director of Advancement Systems and Salesforce Product Manager	Clinton, New York
Hamilton College	Today

You do not have JavaScript Enabled on this browser. Please enable it in order to use the full functionality of our website.

Loading...

Data Integrity Analyst

University of Pennsylvania

Error