Data Integrity Associate

Data Integrity Associate

Wayne State University is searching for an experienced Data Integrity Associate at its Detroit campus location.

Wayne State is a premier, public, urban research university located in the heart of Detroit, Michigan where students from all backgrounds are offered a rich, high-quality education. Our deep-rooted commitment to excellence, collaboration, integrity, diversity and inclusion creates exceptional educational opportunities which prepare students for success in a global society.

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 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%

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

• Education:
  
  Bachelor's degree
• Graduation from an accredited college or university with a bachelor’s degree in computer science, information systems, information technology, or related field.
• Experience:
  
  Experienced (minimum 2 years of job-related experience)
• Minimum two (2) years of experience with database management, records maintenance, SQL, and data cleansing, extraction and validation.
• Experience with administrative systems software, preferably in the higher education or nonprofit environment.
• General understanding of, and interest in, Development and Alumni Affairs’ best practices and general operations.
• Positive and collaborative professional…