Reports Analyst, Operations and Services

**Reports Analyst, Operations and Services**:
**Primary Purpose**: The Reports Analyst is responsible for understanding the structure and operations of University Relations to improve and advance the operational reporting function and information needs. The Analyst is responsible for recommending, developing and implementing report/information solutions based on identified business needs that enable University Relations to fundraise and engage with alumni/donors and community.

**Nature of Work**: Reporting to both the Manager, Systems and Records (UR) and Manager, Reporting and Data Systems (ICT), the Reports Analyst works collaboratively with multiple teams to provide reporting and related system support to further the mission and vision of UR. The Reports Analyst’s activities include implementation of operational reporting through various tools within Blackbaud CRM (Constituent Relationship Management), as well as other reporting tools outside of the CRM such as the UDW (University Data Warehouse), use case development, reporting requirements development, creation and execution of standards, and quality assurance. The Reports Analyst maintains a full understanding of the alumni/donor database (Blackbaud CRM) and the data stored within. The Analyst must also understand university policy, privacy legislation and Canada Revenue Agency rulings related to charitable giving.

The Analyst contributes to the development of best practices, standards, procedures, and quality assurance practices of the Systems support team.

The Analyst plays a critical role in setting up the infrastructure for operational day to day requests for information needs, working closely with the Data Analyst and Programmer/Solution Analyst.

University Relations is responsible for institutional advancement programs (alumni and external relations, development, strategic communications), and as such is dedicated to supporting the related needs of all colleges, units and the university as a whole. University Relations is comprised of specialized teams that work together in an integrated model to ensure that the University of Saskatchewan has the reputation, relationships and resources necessary to take its place among the most distinguished universities in Canada and the world.

The University of Saskatchewan values diversity and Indigenous engagement is a strategic priority. In support of this priority, the position will participate in a team environment which recognizes and supports the importance and value of diversity in achieving the mission of the university, and actively seek out those with diverse cultural backgrounds, perspective, and experiences to support the mission.

In University Relations, the nature of our work centers on our guiding principles of being:

- **Inspiring**: We are confident in ourselves and our goals. We instill confidence and excitement in others to bring them along with us.
- **Committed to each other’s success**: We look for opportunities to make all our teams and the University successful.
- **Collaborative and integrated**: We work together toward shared goals.
- **Solutions
- and action-oriented**: We continuously seek a path forward and we get things done.
- **Brave and courageous**: We expect to encounter obstacles. We face these challenges head-on.
- **Respectful**: We demonstrate our regard for others through listening, understanding, and acknowledging the contributions of all.

**Typical Duties or Accountabilities**:

- Perform business analysis to understand alumni engagement, relationship management, and fundraising informational needs and requirements, and how business rules and workflows translate into data and information
- Design, develop, and implement solutions to provide information such as reports, extracts, dashboards, and self-serve options to meet the information needs of UR.
- Provide leadership in translating reporting objectives into technical solutions, exploring new reporting platforms to add value and improve effectiveness of activities and goals of UR.
- Ensure appropriate definitiveness in reporting of philanthropic funds promised and received in an accurate, accountable fashion.
- Ensure technical reporting specifications meet appropriate business and legal requirements.
- Provide ongoing development of complex queries, selections, smart field calculations, etc. to assist in operational and strategic reports and extracts.
- Document standards in defined business logic used for reports and extracts
- Develop self-serve solutions where applicable for improved service delivery of common information needs
- Identify issues of data quality (e.g. accuracy, completeness, reliability, etc.) and ensure that data-related problems are addressed and resolved in a timely manner.
- Has full knowledge of the tools and functional areas of Constituent Relationship Management (CRM) system for delivery of information and outputs.
- Ensure knowledge transfer happens by coaching, creating and maint