Data Integrity Associate

Job Purpose The Data Integrity Associate is responsible to analyze, monitor and maintain the accuracy, integrity and quality of the alumni, donor and gift records in the administrative database of record for the Division of Development and Alumni Affairs. Identify and remedy data integrity issues and errors. Maintain a systematic approach to keeping the records accurate and contribute to data enhancement projects. Work with other units in the division to coordinate data maintenance efforts. This position reports to the Associate Director, Data Integrity. Essential Functions (Essential functions are the primary duties/major job responsibilities that an employee must be able to perform, with or without reasonable accommodation. The essential functions are listed in order of importance.) Compile and analyze data extracted from the division’s administrative database(s) and Operational Data Store (ODS) to maintain data integrity, facilitate data hygiene projects and produce accurate reports. 25% Analyze data for integrity noncompliance based on university and division business rules, user input and best practices. Identify and correct structural and semantic data errors. 25% Maintain alumni, donor and gift records as directed, including deletions, additions and modifications. Process data update requests from staff, donors, alumni and friends. Assist the Manager, Data Integrity in evaluating the availability, operational need, and return on investment in the purchasing and uploading of new data as well as the outsourcing of various data cleansing projects. 10% Assist in data repository conversions, system adjustments, and strategies. Prepare and process data specifications for administrative database modules, prepare test plans, execute validation and perform other project-related work. 10% Execute protocols for routine updates of biographical data in the division’s administrative database(s), including call center and NCOA updates. Establish a protocol to track update requests and monitor completions. Monitor and report on the progress of all ongoing data integrity projects. 10% Upload modified records collected from external sources into the division’s administrative database(s). 5% Code large groups of alumni, donors and prospects to support the university’s alumni engagement, fundraising, and donor stewardship activities. Research third party vendors and data enhancement services, as requested. 5% Represent the division on various data committees and user groups related to data integrity. 5% Perform other related duties as assigned. 5% WORK CONTEXT This grid characterizes the position scope. Job Reports to: Associate Director Leadership Accountability: Implements operating plans Supervisory Accountability: None Organizational Accountability: None Financial Accountability: None Customer Accountability: Interfaces with customers inside the S/C/D Freedom to Act: Subject to regular review by supervisor