The entry-level Advancement Services Assistant Data Analyst reports to the Data Analyst and helps to support the department’s comprehensive fundraising and alumni programs by identifying, interpreting and developing information solutions within The Raiser’s Edge database system and other Business Intelligence software.

Required Education

• Bachelor's degree required.

Required Experience

• Experience in data extraction and manipulation.
• Experience in higher education; fundraising office preferred.

Primary Duties/Essential Functions

Report Analysis and Development

• • Assists Analyst in preparing a suite of reports and queries to provide timely and accurate data to support the donor identification and solicitation goals of the Advancement and Alumni departments. 
  • Assists Analyst in preparing a comprehensive set of management reports that will meet internal and external reporting requirements (i.e., board reports, comparative data sets, departmental performance, and campaign preparedness, etc.).

Data Extraction Analysis and Development

• • Execute data requests through creating and running queries and exports in Raiser’s Edge and Access.
  • Proactively design, test and implement process improvements for major recurring data requests (e.g., APU Life, Dinner Rally, Direct Mail, Phonathon, and Giving Day).  
  • Develop reporting through Tableau.
  • Certify validity of results of data request solutions, for stated requirements, and for overall strategic Advancement directives or other applicable constraints (legal, postal, etc.). 
  • Provides additional line of support to the Advancement and Alumni offices and other colleagues to meet project deadlines as necessary.

Data Support

• • Work with Advancement Services and team leaders in maintaining relationships with University Data Analysts and the Office of Information and Technology.  
  • Develop knowledge of the fields and records in related APU databases and the tools used to generate reports, lists, data extracts, etc.
  • Process data requests from the university schools and departments as assigned.
  • Assist the data team in resolving bio data anomalies, verifying data transfer accuracy, donor accuracy, etc. by developing Raiser’s Edge queries, MS Office processes and direct examination.
  • Assist the data team in documenting new and revised procedures the data team uses in completing major and recurring projects. 
  • Assist in supporting users of the Advancement data systems as directed by the supervisor.
  • Provide event support during large events like Homecoming, Dinner Rally, Giving Day, and Commencement.

Other Duties

• • Responsible for daily electronic timekeeping as it applies to the scope of this position.
  • Regular, punctual attendance as required by the supervisor based on department needs.
  • Perform other duties related to the position as requested by the supervisor.

Skills

• Proven ability to communicate effectively with administration and staff, both non-technical end-users and technically skilled information systems staff.  
• Strong problem-solving and decision-making skills.  
• Strong analytical and data interpretation skills.  
• An in-depth understanding of relational database concepts, complex data structures and relationships.  
• Ability to work independently within a collaborative team environment.

Mental Demands

• In agreement with the purpose and goals of Azusa Pacific University in providing a Christian-based higher education for its students.

Physical Demands 

• Continuous sitting four-six hours/day.  
• Repetitive wrist, finger motions related to computer usage.  
• Hearing, talking on the telephone.  
• Ability to reach, grasp, bend, pull, lift up to 20 lbs.

Visual Demands

• Computer monitor and reading.

Environment

• Pleasant office setting, comfortable temperature.

Technologies

• Proficient in the use of Google Apps.
• Extensive experience with MS Word, Excel and MS Access or equivalent.
• Knowledge of SQL.
• Strongly Preferred: Hands-on experience with a Customer Relationship Management database (CRM) like, The Raiser’s Edge, Slate, or Oracle PeopleSoft, and experience with visualization software like Tableau or MS Power BI.

Compensation

• Grade 7: $19.49 to $22.41 is the hourly compensation for this role and reflects what Azusa Pacific University reasonably expects to pay for this position. Actual compensation may vary based on the qualifications, experience, and internal equity. In addition to compensation, APU offers a competitive benefits package. 

Azusa Pacific University is a Christ-centered, multicultural community that values and seeks faculty and staff who are committed to diversity, work effectively with diverse populations, and engage others in ways that honor our rich cultural mosaic and biblical foundation. Please click the links to learn more about 'what we believe', our 'mission statement', and our 'statement of faith'.

You can learn more about APU by watching the stories of faculty, staff, and alumni as they carry out our mission here: http://www.apu.edu/stories/.

Azusa Pacific University will conduct a background check on all final candidates.

Review of applications will begin immediately, and the position will remain open until filled unless otherwise stated. Azusa Pacific University does not discriminate on the basis of race, color, national origin, sex, age, disability, or status as a veteran in any of its policies, practices, or procedures. Women and minorities are encouraged to apply.