Advancement Data Analyst

Advancement Data Analyst

Regular

SA49724

full-time 40 hours weekly

Exempt

$74,000 - 100,000

Chapman University is required to provide a reasonable estimate of the compensation range for this position. This range takes into account a variety of factors that are considered in making compensation decisions, including experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. Salary offers are determined based on the final candidate's qualifications and experience, as well as internal equity and other internal factors. The anticipated pay range is not a promise of a particular wage.

As an integral part of the Advancement Systems Team, the Advancement Data Analyst will have primary responsibility for supporting the data and reporting needs of an assigned portfolio of business units within University Advancement and certain other units across the University as they work to enhance constituent engagement and philanthropy at Chapman. The Advancement Data Analyst will elicit, document, and analyze requirements around business needs to produce effective solutions. Guide solution implementations working closely with both stakeholders and other Systems team and IT resources to ensure a successful roll out. Assist in the maintenance and prioritization of the Systems team queue of support requests. Collaborate with other members of the Systems team to organize end user trainings, prepare requirements for major projects, and document workflows and best practices for all users. Participate in and support overall system upgrade, enhancement, and data integrity projects undertaken by Systems team.

• Work directly with stakeholders in assigned portfolio of business units to build strong working relationships by understanding needs and delivering key reports, dashboards, and other data insights aligned with strategic goals and initiatives
• Translate stakeholder business requirements to technical requirements
• Create detailed test cases and documentation for enhancements and new development
• Collaborate with stakeholders to define and execute customer acceptance testing
• Review and approve related training materials and documentation
• Assist with facilitating stakeholder training
• Work collaboratively with Systems team, IS&T, and others to identify and deliver overall system fixes and enhancements
• Support periodic system upgrades
• Support integration with and ongoing use/maintenance of external data systems, tools, and data sources
• Maintain data integrity through systematic auditing and data clean up projects

• Bachelor's degree or equivalent education and experience in a related field
• A minimum of two to four years' experience in independently assisting functional users with data analysis and reporting needs, as well as with troubleshooting system incident reports and developing system enhancement requests
• Strong working knowledge of data structures and prior experience with a relational database and/or reporting system
• Excellent technology skills with aptitude to learn and effectively use a variety of software tools at a "power user" level
• Excellent verbal and written communication skills with emphasis on clear and effective customer interactions
• Ability to work effectively independently and as a member of a team and thrive in a creative, fast-paced environment
• Impeccable attention to detail, accuracy, and quality of work
• Strong analytical skills with proven ability to analyze and prioritize requests, comply with data standards and policies, and form valid conclusions
• Strong organizational skills and the ability to manage large volumes of data in an accurate and meaningful way
• Demonstrated ability to manage multiple projects and priorities, to respond effectively to change, and to manage demanding work situations and deadlines
• Possess personal integrity and the ability to appropriately handle confidential and sensitive information

• Experience with report development applications such as Salesforce Report Builder, Apsona, Crystal Reports, or similar
• Experience with SQL (Structured Query Language) programming
• Experience managing and extracting data from an enterprise reporting or business intelligence tools
• Knowledge of charitable gift policies and procedures, as well as general knowledge of the data and reporting needs of non-profit institutions
• Knowledge of all relevant policies, laws and regulations, including FERPA

Chapman University is an equal opportunity employer committed to fostering a diverse and inclusive academic global community. The University is dedicated to enhancing diversity and inclusion in all aspects of recruitment and employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, gender expression, national origin, ancestry, citizenship status, physical disability, mental disability, medical condition, military and veteran status, marital status, pregnancy, genetic information or any other characteristic protected by state or federal law.

The University is committed to achieving a diverse faculty and staff and encourages members of underrepresented groups to apply. More information on diversity and inclusion at Chapman University can be found at

Applicants for Staff and Administrator positions must be currently authorized to work in the United States on a full-time basis. Chapman University does not sponsor applicants for Staff and Administrator positions for work visas.

The offer of employment is contingent upon satisfactory completion and outcomes of a criminal background screening and returning to the Office of Human Resources a signed original acceptance of the Chapman University Agreement to Arbitrate.

3

5