General Information
| Payroll Title | PROGR ANL 1 | Title Code | 007278 | Grade/Step | 07 | Working Title | Data Integrity Programmer Analyst |
|---|---|---|---|---|---|---|---|
| Department Name | Advancement Services | Supervisor | Jan L Wildman | Department Head | Jan L Wildman |
Special Requirements and Conditions
| Critical Position |
| Valid Driver License |
| Overtime |
Level of Supervision Received
| General Supervision |
Items Used
| Standard Office Equipment; |
Position Purpose
| This position will improve data integrity by analyzing databases used in Advancement Services, including the Raiser's Edge and Financial Edge databases and their corresponding data warehouses. The position will develop strategies to insure accurate data entry and correct data integrity issues, as well as execute or implement those strategies to insure data integrity in the databases used in Advancement Services. |
Essential Functions
| Essential Function | % Time |
|---|---|
| Data Integrity | 100 |
| 1. Analyze institutional business needs, system resources, and end user needs to improve existing data entry and input processes; provide input on how newly acquired data should be stored in the database to best meet user needs and be consistent with existing data. 2. Specify, test, and debug user interfaces and SQL queries and programming code. Develop and enforce data standards. 3. Consult with clients and recommend acquisition of new technology solutions to improve or automate existing processes; create implementation plans and conduct project management activities. 4. Communicate Records Management policy and procedure changes to end users as necessary. 5. Analyze processes, create documentation, and collaborate with training staff in the development of end-user training materials. Serve as part of a team of who analyze database functionality, coding, and practices for continual improvement. Coordinate programmatic data correction, including data downloading, analyzing, programmatic correction, and uploading into an enterprise scale database environment for improving and enforcing data standards. Provide overall database analysis and development across a variety of platforms. 6. Use tools like SQL Server Management Studio to perform data analysis. 7. Develop audit reports using SQL Server Reporting Service. 8. Use Raiser's Edge API to develop data validation routines to insure data integrity at the point of data entry. 9. In addition, this position is responsible for producing reports, queries, mailing lists, etc., and providing other data services to Advancement Services's customers (e.g., Development Officers, Alumni & Constituent Relations, Strategic Communications) so that they may accomplish their goals of engaging Donors and alumni in the mission and philanthropic and academic goals of UCR. |
|
Minimum Requirements
| Minimum Requirement | Display Ranking |
|---|---|
| 1 | |
| Bachelor's degree in a related field or an equivalent combination of education and experience working on data integrity tasks, accounting, or information technology. |
|
| 2 | |
| Demonstrated experience in complex data validation and correction. |
|
| 3 | |
| Experience developing reports from a SQL database using SQL Server Reporting Services and querying with T-SQL. |
|
| 4 | |
| Practical knowledge of Microsoft Access, Excel, Word, PowerPoint and Outlook. |
|
| 5 | |
| Ability to communicate effectively with both technical and non-technical personnel. Must be able to work with all levels of staff. |
|
| 6 | |
| Excellent communication skills, time management abilities, and organizational skills. Must be able to manage multiple projects, activities and tasks simultaneously. |
|
| 7 | |
| Excellent interpersonal skills and the ability to provide effective, respectful support to end-users. |
|
| 8 | |
| Ability to work under time pressure and handle frequent requests from multiple users each having their own timelines |
|
| 9 | |
| Ability to maintain knowledge of current technologies. |
|
Preferred Qualifications
| Preferred Qualification | Display Ranking |
|---|---|
| 1 | |
|
Bachelor's degree with emphasis in information technology, computer science, or related field. |
|
| 2 | |
|
Experience in a fundraising environment, preferably in a higher education setting. |
|
| 3 | |
|
An understanding of the operations of a university Advancement department |
|
| 4 | |
|
Familiarity with Advancement terminology. |
|
| 5 | |
|
Experience with The Raiser's Edge or a similar Advancement database. |
|
| 6 | |
|
Experience with VB 6, VBA, or VB.NET, especially in conjunction with the Raiser's Edge API. |
|
| 7 | |
|
Proficiency in delivering presentations to both technical and non-technical audiences. |
|
| 8 | |
|
Advanced knowledge of relational database structures and techniques. |
|
| Posted Position Purpose |
|---|
| This position will improve data integrity by analyzing databases used in Advancement Services, including the Raiser's Edge and Financial Edge databases and their corresponding data warehouses. The position will develop strategies to insure accurate data entry and correct data integrity issues, as well as execute or implement those strategies to insure data integrity in the databases used in Advancement Services.Want to be a part of a talented technology team? Apply today!
The Office of Constituent Management & Technologies is responsible for all aspects of University Advancement's technological systems, including the Advancement database, The Raiser's Edge; programming, reporting and data analysis; systems maintenance and upgrades, training, help desk, and other computer and cell phone support services. To support the programmatic needs of University Advancement and our campus partners by providing computer systems services to facilitate communication with alumni, friends, and donors.
About University Advancement: Under the leadership of Vice Chancellor Peter A. Hayashida, the UC Riverside University Advancement team raises public awareness of UCR's excellence in research, teaching and service. We encourage, promote, and secure public and private resources to support: recruitment and retention of world-class faculty; high-quality education for the best and brightest students who are reflective of California's diverse population; and leading-edge facilities and equipment necessary for inquiry and the creation of knowledge for the 21st century and beyond. About UCR: The University of California, Riverside (www.ucr.edu) is a doctoral research university, a living laboratory for groundbreaking exploration of issues critical to Inland Southern California, the state and communities around the world. Reflecting California's diverse culture, UCR's enrollment has exceeded 21,000 students. The campus opened a medical school in 2013 and has reached the heart of the Coachella Valley by way of the UCR Palm Desert Center. The campus has an annual statewide economic impact of more than $1 billion. UCR is the most diverse campus in the prestigious 10 campus UC system and it is the eighth most diverse university in the nation. Recently named a "Next Generation University", UCR has earned a national reputation for excellence in research, teaching and service. For the second consecutive year, UCR has been recognized by The Princeton Review as one of the top green colleges in North America and for (2013) the Washington Monthly magazine ranked the University of California, Riverside second among national universities in their ninth-annual College Ranking Survey. Measures of social mobility, including enrollment of low-income students, net price and having a better-than-predicted graduation rate, helped propel UCR to the No. 2 overall ranking with an overall score of 93.5 out of a possible 100 points.
|
| Posted Minimum Requirements |
| -Bachelor's degree in a related field or an equivalent combination of education and experience working on data integrity tasks, accounting, or information technology. -Demonstrated experience in complex data validation and correction. -Experience developing reports from a SQL database using SQL Server Reporting Services and querying with T-SQL. -Practical knowledge of Microsoft Access, Excel, Word, PowerPoint and Outlook. -Ability to communicate effectively with both technical and non-technical personnel. Must be able to work with all levels of staff. -Excellent interpersonal skills and the ability to provide effective, respectful support to end-users. -Excellent communication skills, time management abilities, and organizational skills. Must be able to manage multiple projects, activities and tasks simultaneously. -Ability to work under time pressure and handle frequent requests from multiple users each having their own timelines -Ability to maintain knowledge of current technologies. |
| Posted Preferred Qualifications |
| -Bachelor's degree with emphasis in information technology, computer science, or related field. -Experience in a fundraising environment, preferably in a higher education setting. -An understanding of the operations of a university Advancement department. -Familiarity with Advancement terminology. -Experience with The Raiser's Edge or a similar Advancement database. -Experience with VB 6, VBA, or VB.NET, especially in conjunction with the Raiser's Edge API. -Proficiency in delivering presentations to both technical and non-technical audiences. -Advanced knowledge of relational database structures and techniques. |