Develop, implement, and maintain the data quality management (compliance) plan for more than 250,000 alumnae and donor records. Responsible for all phases of the data quality lifecycle including: quality assessments and data profiling; quality design; quality transformation and monitoring that result in measurable and sustained data integrity. Manage special projects related to data and reporting needs within Institutional Advancement. Reports to the Associate Director, Advancement Services, Institutional Advancement or designated administrator.
Characteristic Duties and Responsibilities:
Utilize data profiling techniques to assess data accuracy, completeness, and consistency across data sources.
Document and maintain data transformation rules and mapping.
Identify areas for data augmentation and cleansing; maintain updates from third party sources according to a defined plan and measure effectiveness.
Design and implement plans for data audits, correction procedures, and measuring data quality.
Manage methodologies (how, where, etc.) of information storage within source and reporting systems; partner with appropriate personnel within the division to design and implement changes when needed.
Develop and maintain an annual budget for data-related services and updates.
Perform testing and data validation on reports and dashboards as needed.
Stay current with IRS regulations, CASE standards, and departmental data needs and implement changes as needed.
Perform other related duties as assigned.
Bachelor's Degree in business administration, information systems, or a related field from an accredited university or college and two years of experience working with reporting and database development tools.
A minimum of six years of progressively responsible work experience in data entry, performing data uploads, and data auditing; experience implementing data and process improvements; maintaining large databases (over 150,000 records), with a demonstrated understanding of data manipulation, data design, quality assessment, and profiling concepts. Requires demonstrated ability in use of enterprise reporting systems such as Cognos, Tableau, SQL Server Reporting Services. Must possess advanced skills in MS Office Suite (Excel, Word and Access) with ability to manipulate and format data.
License/Certification: Not applicable.
Preferred Qualifications: Banner ERP experience is preferred.
Knowledge Of: Enterprise reporting and database development tools such as Cognos, SQL / MS Reporting Services, Tableau or similar tools * Data management, data manipulation, data design, quality assessment / profiling concepts * Higher education structure and fundraising functions Understanding of data confidentiality and its application to security and access request skills * Postal Services Standards *
Skill In: Written, verbal and interpersonal communication with the ability to communicate effectively with all components of the university and external constituents * Excellent process management skills * Implementing projects and assessment of program initiatives Demonstrated use of enterprise reporting systems (e.g. Cognos, Tableau, SQL / MS Reporting Services; with a high degree of analytical and problem solving skills) * Advanced skills in MS Office Suite (Excel, Word and Access) with the ability to manipulate and format data *
Ability To: Independently manage multiple projects, set priorities, resolve problems and make decisions in a timely manner * Perform data uploads and data auditing *
Assessments: Asterisk (*) indicates knowledge, skills, abilities which require assessments.
Kent State University's eight-campus system, among the largest regional systems in the country, serves both the development of a true living/learning approach at the Kent Campus and the regional needs on seven other campuses throughout Northeast Ohio.
The Kent Campus provides the resources and facilities of a large, diverse Ohio university, while the Regional Campuses – Kent State University at... Ashtabula, Kent State University at East Liverpool, Kent State University at Geauga, Kent State University at Salem, Kent State University at Stark, Kent State University at Trumbull and Kent State University at Tuscarawas - offer the friendly, casual atmosphere of small liberal arts colleges. Today, Kent State has become an engine for economic, cultural and workforce development locally and internationally as one of the premiere Ohio universities. Kent State is ranked among the nation's 77 public research universities demonstrating high-research activity by the Carnegie Foundation for the Advancement of Teaching. The Liquid Crystal Institute, for example, conducts research that translates into technologies used globally in laptops, calculators and flat screen televisions.