System and Data Analyst

$66,600 - $78,300 yearly
  • Santa Clara University
  • Santa Clara University, El Camino Real, Santa Clara, CA, USA
  • Nov 03, 2022
Full time ERP / Database / Data Analysis

Job Description

Position Title:

System and Data Analyst

 

Position Type:

Regular

Salary Range:

$66,600.00 - $78,300.00; commensurate with experience.

 

Pay Frequency:

Annual

A. POSITION PURPOSE
As a member of the Advancement Services team, and reporting to the Assistant Vice President of for Advancement Services within University Relations, the System and Data Analyst provides essential support to the University Relations division in the areas of system maintenance and data support. The position provides application software and technical support for CLARA, University Relation's CRM system. The analyst performs system administration, user account support, and data quality assistance.

 

B. ESSENTIAL DUTIES AND RESPONSIBILITIES

 

1. Reporting/Analytics

  • Perform system administrative functions, including code table maintenance, user account support, and security access.

  • Assist with system integrations with third-party solutions.

  • Create ad hoc queries and data extracts for users.

  • Work closely with customers to report data in requested formats.

  • Prioritize multiple reports, data analysis and data research requests.

  • Work with UR’s information systems team to build and deploy custom reporting solutions across platform.

  • Recommends techniques and/or resources needed for handling unique customer requests

 

2. Data Maintenance

  • Test software releases/upgrades, ensuring compatibility with existing reports and in-house customizations.

  • Track issues and recommend solutions.

  • Support large data coding requests.

  • Responsible for analyzing and managing data, taking steps necessary to ensure data integrity.

  • Provide data quality support and assistance to Gift & Records team.

 

3. Business Analysis

  • Work with customers to understand their needs and make the appropriate recommendations.

  • Work collaboratively with the Information Systems team to identify system and process improvement and manage updates/changes as appropriate.

  • Work with other University Relations departments to continuous analyze workflow and business process, makes recommendations to improve processes and procedures.

  • Assists with BBIS processes, including bulk emails and online event management setup.


4.   Other duties as assigned.

  • Backup Manager of User Services and Training, especially during peak periods.

  • Backup Data Reporting Analyst.

     

C.   PROVIDES WORK DIRECTION

 

Not applicable

 

D.   GENERAL GUIDELINES

  • Recommends initiatives and implements changes to improve quality and services.

  • Identifies and determines cause of problems; develops and presents recommendations for improvement of established processes and practices.

  • Maintains contact with customers and solicits feedback for improved services.

  • Maximizes productivity through use of appropriate tools; planned training and performance initiatives. Researches and develops resources that create timely and efficient workflow. 

  • Prepares progress reports; informs supervisor of project status; and deviation from goals.

  • Ensures completeness, accuracy and timeliness of all operational functions.

  • Prepares and submits reports as requested and required.

  • Develops and implements guidelines to support the functions of the unit.
     

E.   QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The items below are representative of the knowledge, skills, abilities, education, and experience required or preferred.

 

This position requires the ability to effectively establish and maintain cooperative working relationships within a diverse multicultural environment.

 

1. Knowledge

  • Knowledge of fundraising principles and practice.

  • In-depth experience with relational database management systems.

  • Excel knowledge, including advanced skills such as v-lookup, pivot tables and macros.

  • Experience using mapping and donor management software tools.

  • Microsoft Word knowledge for writing technical documentation for end users.

 

2. Skills

  • Excellent communication skills, both verbally and in writing.

  • Problem solver.

  • Interest in the collection of, relationships between, and business utilization of data and how this fits into the overall business strategy.

  • Excellent customer service skills.

  • Adept at critical thought: understanding complex problems.
     

3. Abilities

  • Highly organized and capable of managing multiple projects simultaneously while having the ability to shift work seamlessly when priorities change

  • Ability to analyze critically, read requirements, ask pointed/well-articulated questions, and think retrospectively are all critical to delivering what is requested. 

  • Ability to analyze user requests and translate into reports or other output.

  • Ability to write, communicate, and present clearly and cogently to all levels of individuals

  • Ability to prioritize a large volume of work and meet critical deadlines

  • Ability to work successfully in team setting

  • Ability and willingness to expand knowledge base.
     

4. Education

  • Bachelor’s degree in Business, Computer Sciences, Systems Analysis, or related field; or equivalent experience preferred.
     

5. Years of Experience

  • 3-5 years of years of relevant experience in Information Technology working with relational databases required.

  • Experience with reporting/data analytics preferred

  • Experience in higher education preferred
     

F.   PHYSICAL DEMANDS

The physical demands described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. In accordance with the Americans with Disabilities Act, as amended, the California Fair Employment & Housing Act, and all other applicable laws, SCU provides reasonable accommodations for qualified persons with disabilities.  A qualified individual is a person who meets skill, experience, education, or other requirements of the position, and who can perform the essential functions of the position with or without reasonable accommodation.

 

  • Considerable time is spent at a desk using a computer terminal. 

  • May be required to travel to other buildings on the campus.

  • May be required to attend conference and training sessions within Bay Area or in- or out-of-state locations.

  • May be required to occasionally travel to outside customers, venders or suppliers.
     

G.   WORK ENVIRONMENT

The work environment characteristics described below are representative of those an employee encounters while performing the essential functions of this job.

  • Typical office environment.

  • Mostly indoor office environment with windows.

  • Offices with equipment noise.

  • Offices with frequent interruptions

EEO Statement

Equal Opportunity/Notice of Nondiscrimination

Santa Clara University is an equal opportunity/equal access/affirmative action employer fully committed to achieving a diverse workforce and complies with all Federal and California State laws, regulations, and executive orders regarding non-discrimination and affirmative action. Applications from members of historically underrepresented groups are especially encouraged. For a complete copy of Santa Clara University’s equal opportunity and nondiscrimination policies, see https://www.scu.edu/title-ix/policies-reports/

 

Title IX of the Education Amendments of 1972

Santa Clara University does not discriminate in its employment practices or in its educational programs or activities on the basis of sex/gender, and prohibits retaliation against any person opposing discrimination or participating in any discrimination investigation or complaint process internally or externally. The Title IX Coordinator and Section 504 and ADA Coordinator is Jenna Elliott, Interim Director of Equal Opportunity and Title IX, 408-551-3043, jrelliot@scu.edu , www.scu.edu/title-ix. Inquiries can also be made to the Assistant Secretary of Education within the Office for Civil Rights (OCR). 

 

Clery Notice of Availability

Santa Clara University annually collects information about campus crimes and other reportable incidents in accordance with the federal Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act. To view the Santa Clara University report, please go to the Campus Safety Services website. To request a paper copy please call Campus Safety at (408) 554-4441. The report includes the type of crime, venue, and number of occurrences.

 

Americans with Disabilities Act

Santa Clara University affirms its' commitment to employ qualified individuals with disabilities within the workplace and to comply with the Americans with Disability Act. All applicants desiring an accommodation should contact the Department of Human Resources, and 408-554-5750 and request to speak to Indu Ahluwalia by phone at 408-554-5750 or by email at iahluwalia@scu.edu.

 

***When applying, please note that you saw the job posted on the NOVAworks Job Board. If you need help with your resumé, please see a NOVAworks Career Advisor.