Position Details
View All Details Back To Current Job Opportunities Position Closed
Data Integrity Programmer Analyst
| Job Number | Full/Part Time | Schedule | Salary |
|---|---|---|---|
| 201508187625 | Full Time | 8AM - 5PM | - |
Position Information
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.
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.
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.
-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.
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.
-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.
Additional Information
In the Heart of Inland Southern California, UC Riverside is located on nearly 1,200 acres near Box Springs Mountain in Southern California; the park-like campus provides convenient access to the vibrant and growing Inland region. The campus is a living laboratory for the exploration of issues critical to growing communities' air, water, energy, transportation, politics, the arts, history and culture. UCR gives every student the resources to explore, engage, imagine and excel.
At UC Riverside we celebrate diversity and are proud of our #12 ranking among the nation for most diverse universities (US News and World Report 2013-2014). Become part of a place that fosters success for all its constituents, students, faculty, and staff, and where work/life balance and campus culture are integral to our way of life.
UCR is ranked 55th among top public universities (US News and World Report 2013-2014).
The University of California is an Equal Opportunity/Affirmative Action Employer with a strong institutional commitment to the achievement of excellence and diversity among its faculty and staff. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by law.
For information about our generous employee benefits package, visit: Employee Benefits Overview
At UC Riverside we celebrate diversity and are proud of our #12 ranking among the nation for most diverse universities (US News and World Report 2013-2014). Become part of a place that fosters success for all its constituents, students, faculty, and staff, and where work/life balance and campus culture are integral to our way of life.
UCR is ranked 55th among top public universities (US News and World Report 2013-2014).
The University of California is an Equal Opportunity/Affirmative Action Employer with a strong institutional commitment to the achievement of excellence and diversity among its faculty and staff. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by law.
For information about our generous employee benefits package, visit: Employee Benefits Overview