Position Details
View All Details Back To Current Job Opportunities Position Closed
Data and Reporting Analyst
Job Number | Full/Part Time | Schedule | Salary |
---|---|---|---|
26791730 | Full Time | 8AM - 5PM | $64,300 - $89,300 |
Position Information
*The position is eligible for hybrid/remote accommodations*
The Data and Reporting Analyst serves University Advancement by applying the best data integrity and security practices while fulfilling internal customer requests for data extracts and email blasts. Duties include improving data integrity by analyzing databases used in Advancement Services, including Raiser's Edge and Mailchimp databases, as well as the Raiser's Edge data warehouse. The position will develop strategies to ensure accurate data entry, correct data integrity issues, and execute or implement those strategies to ensure data integrity in the databases used in Advancement Services. This position also provides help-desk support and data set troubleshooting while advising internal customers of data security concerns and regulations. The Office of Constituent Management & Technologies is responsible for all aspects of University Advancement's technological systems, including the Advancement database Raiser's Edge; programming, reporting and data analysis; systems maintenance and upgrades, training, help desk, and other computer and cell phone support services. In addition, 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.
As a condition of employment, you will be required to comply with the University of California SARS-CoV-2 (COVID-19) Vaccination Program Policy. All Covered Individuals under the policy must provide proof of Full Vaccination or, if applicable, submit a request for Exception (based on Medical Exemption, Disability, and/or Religious Objection) or Deferral (based on pregnancy) no later than the applicable deadline. For new University of California employees, the applicable deadline is eight weeks after their first date of employment. Please note: the budgeted amount for this position is up to $67,000.
The Data and Reporting Analyst serves University Advancement by applying the best data integrity and security practices while fulfilling internal customer requests for data extracts and email blasts. Duties include improving data integrity by analyzing databases used in Advancement Services, including Raiser's Edge and Mailchimp databases, as well as the Raiser's Edge data warehouse. The position will develop strategies to ensure accurate data entry, correct data integrity issues, and execute or implement those strategies to ensure data integrity in the databases used in Advancement Services. This position also provides help-desk support and data set troubleshooting while advising internal customers of data security concerns and regulations. The Office of Constituent Management & Technologies is responsible for all aspects of University Advancement's technological systems, including the Advancement database Raiser's Edge; programming, reporting and data analysis; systems maintenance and upgrades, training, help desk, and other computer and cell phone support services. In addition, 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.
As a condition of employment, you will be required to comply with the University of California SARS-CoV-2 (COVID-19) Vaccination Program Policy. All Covered Individuals under the policy must provide proof of Full Vaccination or, if applicable, submit a request for Exception (based on Medical Exemption, Disability, and/or Religious Objection) or Deferral (based on pregnancy) no later than the applicable deadline. For new University of California employees, the applicable deadline is eight weeks after their first date of employment. Please note: the budgeted amount for this position is up to $67,000.
Education
Education Requirements
Degree | Requirement |
---|---|
Bachelor's degree in related area and/or equivalent experience/training. | Required |
Bachelor's degree with emphasis in information technology, computer science, or related field. | Preferred |
Licenses
License | Requirement |
---|---|
Valid Drivers License. | Required |
Experience
Experience | Requirement |
---|---|
2 - 4 years of related experience. | Required |
Experience serving customers through a ticketing system | Preferred |
Experience with VB 6, VBA, or VB.NET, especially in conjunction with the Raiser's Edge API. | Preferred |
Experience with The Raiser's Edge or a similar Advancement database. | Preferred |
Experience in a fundraising environment, preferably in a higher education setting. | Preferred |
Demonstrated experience in complex data validation and correction. | Required |
Experience with creating email blasts in Mailchimp or similar software | Preferred |
Experience developing reports from a SQL database using SQL Server Reporting Services and querying with T- SQL. | Required |
Special Conditions
Special Condition | Requirement |
---|---|
Must pass a background check. | Required |
Minimum Requirements
Demonstrates interpersonal skills, problem solving skills, service orientation, active listening, effective verbal and written communication skills and organizational skills.
Knowledgeable about professional approaches and relevant standards and technology for management of unstructured data such as text and images.
Ability to work under time pressure and handle frequent requests from multiple users each having their own timelines.
Excellent interpersonal skills and the ability to provide effective, respectful support to end-users.
Able to multi-task and prioritize tasks.
Ability to communicate effectively with both technical and non-technical personnel. Must be able to work with all levels of staff.
Excellent communication skills, time management abilities, and organizational skills. Must be able to manage multiple projects, activities and tasks simultaneously.
Has effective written/verbal communication skills.
Ability to maintain knowledge of current technologies.
Demonstrates reasoning and ability to develop original ideas to solve problems.
Demonstrates good judgment and decision-making; problem identification and resolution; identifying measures of system performance and the actions to improve performance through application configuration and programming techniques.
Practical knowledge of Microsoft Access, Excel, Word, PowerPoint and Outlook.
Knowledge relating to capacity planning and interface specifications.
Intermediate database management operations and knowledge of department rules and regulations.
Advanced knowledge of relational database structures and techniques.
Knowledge of database management systems and standards.
Knowledgeable about professional approaches and relevant standards and technology for management of unstructured data such as text and images.
Ability to work under time pressure and handle frequent requests from multiple users each having their own timelines.
Excellent interpersonal skills and the ability to provide effective, respectful support to end-users.
Able to multi-task and prioritize tasks.
Ability to communicate effectively with both technical and non-technical personnel. Must be able to work with all levels of staff.
Excellent communication skills, time management abilities, and organizational skills. Must be able to manage multiple projects, activities and tasks simultaneously.
Has effective written/verbal communication skills.
Ability to maintain knowledge of current technologies.
Demonstrates reasoning and ability to develop original ideas to solve problems.
Demonstrates good judgment and decision-making; problem identification and resolution; identifying measures of system performance and the actions to improve performance through application configuration and programming techniques.
Practical knowledge of Microsoft Access, Excel, Word, PowerPoint and Outlook.
Knowledge relating to capacity planning and interface specifications.
Intermediate database management operations and knowledge of department rules and regulations.
Advanced knowledge of relational database structures and techniques.
Knowledge of database management systems and standards.
Preferred Qualifications
An understanding of the operations of a university Advancement department.
Proficiency in delivering presentations to both technical and non-technical audiences.
Familiarity with Advancement terminology.
Proficiency in delivering presentations to both technical and non-technical audiences.
Familiarity with Advancement terminology.
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, faculty and staff member the resources to explore, engage, imagine and excel.
UC Riverside is recognized as one of the most ethnically diverse research universities in the country boasting several key rankings of which we are extremely proud.
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
UC Riverside is recognized as one of the most ethnically diverse research universities in the country boasting several key rankings of which we are extremely proud.
- UC Riverside is proud to be ranked No. 12 among all U.S. universities, according to Money Magazine's 2020 rankings, and among the top 1 percent of universities worldwide, according to the 2019-20 Center for World University rankings.
- UC Riverside is the top university in the United States for social mobility. - U.S. News 2020
- UCR is a member of the University Innovation Alliance, the leading national coalition of public research universities committed to improving student success for low-income, first-generation, and students of color.
- Among top-tier universities, UC Riverside ranks No. 2 in financial aid. - Business Insider 2019
- Ranked No. 2 in the world for research, UCR's Department of Entomology maintains one of the largest collections of insect specimens the nation. - Center for World University Rankings
- UCR's distinguished faculty boasts 2 Nobel Laureates, and 13 members of the National Academies of Science and Medicine.
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