Requisition Number: 2020S004Posting Full Time/Part Time: Full Time Division: Institutional Advancement Division Department: Advancement Operations
Accountabilities: The Advancement Operations Analyst os responsible for the following:
Reporting and data analysis support for the Institutional Advancement division to advance the university's short and long-term goals, strategic planning, and operations.
The design of reports to convey complex relational or connected analysis not easily represented in traditional reporting methods.
Ensuring that data reports from multiple sources provide consistent, timely, and accurate information for decision makers.
Reports go to the Board of Trustees, Cabinet, Campaign Planning Committee, Institutional Advancement management team, volunteers, and donors.
The Analyst shares system administration responsibilities for the Raiser's Edge system as well as serves as the primary staff training for Raiser's Edge and reporting.
The Analyst is accountable for assisting with new technology implementations in the division.
Specific responsibilities include but are not limited to:
Manages and oversees the development, production, distribution, and maintenance of demographic and fundraising reports for Institutional Advancement.Standard reports include: gift and pledges, events, Annual Giving, campaign progress reports
Creates and manipulates reports in Raiser's Edge, Crystal Reports, Tableau, or Excel
Uses visual analytics to deliver information from data sets that are difficult to present through conventional reporting techniques
Serves as the data resource liaison to campus partners who are in need of
Serves as a member of the data team responsible for the development of the advancement data warehouse
Reaches out to colleagues within the division and campus partners to learn about reporting needs. Designs custom reports.
Assesses and monitors responses to requests for reporting to ensure information is supplied in a relevant and timely manner;
Provides structured opportunities such as workshops, tutorials, and documentation to help users produce and use reports;
Writes, updates, and distributes report documentation;
Writes user-level documentation for database, reports, queries, exports, etc.
Analyzes and interprets data to identify coding issues and recommend appropriate methods of resolution. Determine data storage methods for supplemental data.
Builds and implements key data imports using the ImportOmatic tool.
Serves as “first tier” training and support for Advancement users on Raiser's Edge and reporting tools;
Shares with users the changes, enhancements, problems, and technical plans regarding Raiser's Edge.
Shares management of the Raiser's Edge database including adding new users and managing security;
Shares responsibility for supporting new software implementations within the Advancement division;
Performs year-end database diagnostics and cleanup processes.
Technical Competencies Customer Service/Problem Solving Demonstrated ability to understand, prioritize and respond to requests for information and to determine and respond to root cause of request or problem.
Operations Management Demonstrated ability to execute setup, implementation and management of back office tasks for IA. Ability to provide input to Advancement and execution of policies, protocols, and workflows to support operational performance of IA.
Records Management Demonstrated ability to understand and use database. Ability to manage access/use, maintenance and ongoing reliability and quality of records data (alumni, gift records, reports, etc.).
Data Management Demonstrated ability to understand and make use of analytical methodologies and techniques to produce useful information/reports with some direction. Ability to understand databases and manipulate data to provide useful information about donors and prospects. Ability to become proficient with software tools and packages relevant to produce reports.
Technology Demonstrated ability to understand and use functionality of department-specific applications and technology. Ability to apply technology tools to develop and produce reports and manage information. May require ability to provide access to advancement technology tools and applications. Ability to respond to complex requests and produce complex reports.
Advancement Domain Knowledge Demonstrated understanding of advancement business and operations sufficient to optimize queries, data sets and technical training. Demonstrated knowledge of advancement data sufficient to ensure all data-related work is relevant and optimized to the needs of the advancement team.
Project Management Demonstrated ability to lead projects with staff resources, develop project plans, develop requirements, and coordinate across teams. Project plans subject to approval by more senior staff. Demonstrated ability to execute subsets of complex projects managed by others.
Behavioral Competencies Personal Accountability for Results Takes responsibility for decisions, performance, and outcomes; behaves in a responsible manner with a positive attitude; shows self-awareness and openness to feedback.
Effective Communication Demonstrates effective written and oral communication skills; shares information and seeks input from others; adapts communication to diverse audiences; protects private and confidential information.
Problem Solving and Decision Making Analyzes and prioritizes situations to identify and solve problems; generates solutions to improve efficiency and quality; involves others in solving problems and making decisions; factors organizational goals into decisions; makes clear, transparent, and timely decisions.
Change Management Responds positively to changing university initiatives and readily adapts behavior to maintain effective performance; understands the long-term direction of the university and can relate this to departmental area; adapts to new methodologies; identifies and acts on areas where change is appropriate.
Leadership and Teamwork Applies skills and knowledge to provide a climate to achieve departmental and organizational success; balances individual and department goals; helps others perform at their best; builds productive relationships to enhance individual and organizational effectiveness; treats others with respect; resolves conflicts among team members.
Creativity and Innovation Generates, explores, encourages, and implements innovative ways of creating strategic value for the university, division, department, and individual level; critically assesses the effectiveness of new initiatives.
Diversity and Inclusion Demonstrates respect for people and their differences; understands the benefits of a diverse workforce; earns the trust and respect of others; includes and welcomes others; works to understand the perspective of others; promotes opportunities to experience diversity within our community.
Sustainability Understands the impact of decision making and personal behavior in achieving the university’s commitment to a sustainable and carbon-neutral campus; supports and advances the university’s sustainability initiatives; influences others to use sustainable practices.
Preferred Qualifications Experience with Crystal Reports, Tableau, Raiser’s Edge, and Excel
Education Bachelor’s degree or a combination of equivalent education and experience.
Work Schedule: Weekdays
Job Open Date: 01/14/2020
Job Close Date: 3/23/2020
Open Until Filled Yes
EEO Statement It is the policy of Colgate University not to discriminate against any employee or applicant for employment on the basis of their race, color, creed, religion, age, sex, pregnancy, national origin, marital status, disability, protected Veterans status, sexual orientation, gender identity or expression, genetic information, being or having been victims of domestic violence or stalking, familial status, or any other categories covered by law. Colgate is an Equal Opportunity/Affirmative Action employer. Candidates from historically underrepresented groups, women, persons with disabilities, and protected veterans are encouraged to apply.
Clery Act CAMPUS CRIME REPORTING AND STATISTICS The Campus Safety Department will provide upon request a copy of Colgate’s Annual Security and Fire Safety Report. This report includes statistics as reported to the United States Department of Education for the previous three years concerning reported: 1. crimes that occurred on-campus; in certain off-campus buildings or property owned or controlled by Colgate University; and on public property within, or immediately adjacent to and accessible from, the campus and 2. fires that occurred in student housing facilities. The report also includes institutional policies concerning campus security and fire safety, such as policies concerning sexual assault, life safety systems, and other related matters. To obtain a copy, contact the Campus Safety Compliance Manager via e-mail at email@example.com. You may also access the report from the Campus Safety web page at: www.colgate.edu/offices/support/campussafety.