Essential Functions: JOB PURPOSE Reporting to the Manager, Data Integrity, 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(s) 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. ESSENTIAL FUNCTIONSMaintain 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. 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.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.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. 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.Upload modified records collected from external sources into the division's administrative database(s).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. Participate in the division's Data Integrity Task Force. Represent the division on various data committees and user groups related to data integrity.Adhere to confidentiality and data usage policy for the division.Perform related work as assigned.
Qualifications: MINIMUM QUALIFICATIONSEducation: Bachelor's degreeAdditional Education Information: Graduation from an accredited college or university with a bachelor's degree in computer science, information systems, information technology, or related field. Experience: ExperiencedAdditional Experience Information: Minimum two (2) years experience with database management, records maintenance, SQL, and data cleaning, extraction and validation.Experience with administrative systems software, preferably in the higher education or nonprofit environment. General understanding of, or interest in, Development and Alumni Affairs best practices and general operations.Positive and collaborative professional philosophy, recognizing that this position is integral to the achievement of the goals and objectives of Development and Alumni Affairs.KNOWLEDGE, SKILLS & ABILITIES REQUIREDCOMMUNICATIONS SKILLS: Ability to communicate clearly, concisely and professionally both orally and in writing. Strong interpersonal skills a must.TECHNICAL SKILLS: Proficient in the use of complex administrative systems software, preferably in the higher education environment.PLANNING AND ORGANIZATION: Ability to manage several projects simultaneously, prioritize and plan work activities while meeting respective deadlines. Strong organizational and time-management skills.ANALYTICAL AND PRESENTATION SKILLS: Ability to evaluate, interpret, and present complex information effectively in professionally prepared documents or presentations. Must possess a demonstrated attention to detail in order to achieve a high degree of accuracy.TEAMWORK: Ability to collaborate effectively with colleagues within the division and central units; ability to produce high quality and consistent results with assistance of team members; provide support to teammates when tackling complex projects. LEARNING AGILITY: Independent and innovative self-starter who displays an ability to learn quickly and easily adapts to changing situations. Experience researching topics to gain knowledge and understanding when information gaps exist.This position requires a high level of commitment and enthusiasm. The incumbent must be willing to work extended hours as needed.
Founded in 1868, Wayne State University is a nationally recognized metropolitan research institution offering more than 400 academic programs through 13 schools and colleges to nearly 32,000 students. Wayne State?s main campus in Midtown Detroit comprises 100 buildings over nearly 200 acres; its five extension centers offer higher education to people throughout Southeast Michigan. Wayne State is dedicated to preparing students to excel by combining the academic excellence of a major research university with the practical experience of an institution that by its history, location and diversity represents a microcosm of the world we live in. Reflecting its location and the excellent international reputation of its graduate schools, particularly in the sciences, Wayne State boasts the most diverse student body among Michigan?s public universities. Its students represent 49 U.S. states and more than 60 countries.