General Information
| Job Description | DATABASE ADM 2 | Working Title | Data and Reporting Analyst |
|---|---|---|---|
| Job Code | 007176 | Grade | 21 |
| Department Name | Advancement Services - D01282 | Department Head | Kim McDade |
| Supervisor | Lily Barger | Effective Date | 09/20/2022 |
Position(s) Directly Supervised
| Job Code | Title | FTE |
|---|
Generic Scope
| Professional who applies acquired job skills, policies, and procedures to complete substantive assignments/projects/tasks of moderate scope and complexity; exercises judgment within defined guidelines and practices to determine appropriate action. |
Custom Scope
| Uses professional concepts, industry standards, and best practices in maintaining databases. Demonstrates functional proficiency/fluency. Exercises judgment within defined procedures and practices to determine appropriate course of action. Applies campus/medical center/OP policies and procedures to resolve a variety of database issues. Works on database problems of moderate scope where analysis of situations or data requires a review of a variety of factors. |
Department Custom Scope
| *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. |
Education & Experience Requirements
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 |
Experience Requirements
| 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 |
License Requirements
| License | Requirement |
|---|---|
| Valid Drivers License. | Required |
Certification Requirements
| Certification | Requirement |
|---|
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
| Under general supervision, applies professional database concepts, resolves basic procedural and technical issues in the context of department policies and procedures. | 30 |
Works on database-related issues and projects of moderate scope taking in numerous business practice and technical considerations, applying defined IT procedures and practices to database projects.
|
15 |
| Maintains security and integrity controls. | 15 |
| Works with others in the implementation of database scripts, interfaces, and applications. Communicate Records Management policy and procedure changes to end-users as necessary. In addition, this position is responsible for producing reports, queries, mailing lists, etc., and providing other data services to Advancement Service's customers (e.g., Development Officers, Alumni & Constituent Relations, University Communications) so that they may accomplish their goals of engaging donors and alumni in the mission and philanthropic and academic goals of UCR. | 15 |
Works on moderately sized databases with multiple tables and end users using basic database design and programming techniques.
|
10 |
May interact with both members internal and external to their unit.
|
5 |
| Implements performance tuning techniques including indexes and advanced SQL syntax. | 5 |
Monitors policies, procedures and standards relating to database management.
|
5 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Demonstrates interpersonal skills, problem solving skills, service orientation, active listening, effective verbal and written communication skills and organizational skills. | Required |
| Knowledgeable about professional approaches and relevant standards and technology for management of unstructured data such as text and images. | Required |
| Ability to work under time pressure and handle frequent requests from multiple users each having their own timelines. | Required |
| Excellent interpersonal skills and the ability to provide effective, respectful support to end-users. | Required |
| Able to multi-task and prioritize tasks. | Required |
| Ability to communicate effectively with both technical and non-technical personnel. Must be able to work with all levels of staff. | Required |
| Excellent communication skills, time management abilities, and organizational skills. Must be able to manage multiple projects, activities and tasks simultaneously. | Required |
| Has effective written/verbal communication skills. | Required |
| Ability to maintain knowledge of current technologies. | Required |
| Demonstrates reasoning and ability to develop original ideas to solve problems. | Required |
| 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. | Required |
| Practical knowledge of Microsoft Access, Excel, Word, PowerPoint and Outlook. | Required |
| Knowledge relating to capacity planning and interface specifications. | Required |
| Intermediate database management operations and knowledge of department rules and regulations. | Required |
| Advanced knowledge of relational database structures and techniques. | Required |
| Knowledge of database management systems and standards. | Required |
| An understanding of the operations of a university Advancement department. | Preferred |
| Proficiency in delivering presentations to both technical and non-technical audiences. | Preferred |
| Familiarity with Advancement terminology. | Preferred |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Must pass a background check. | Required |
Other Special Requirements & Conditions
|
|
Level of Supervision Received
| Supervision |
Environment
Working Environment
| Full-time remote work arrangements will be considered |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: Yes |