University of Alberta

Senior Data Analyst

Advancement - Advancement Services

Competition No.  -    S113135742
Posting Date  -    May 14, 2018
Closing Date  -    May 28, 2018
Position Type  -    Full Time - Operating Funded
Salary Range  -    $58,675 to $81,208 per year
Grade  -    10
Hours  -    35

This position is located downtown in Enterprise Square building (10230 Jasper Avenue, Edmonton, Alberta, Canada T5J 4P6) and offers a comprehensive benefits package which can be viewed at Faculty & Staff Benefits.

Reporting to the Manager Data Analytics (MDA) in the Office of Advancement Services, the Advancement Senior Data Analyst (SDA) will be responsible for building and supporting the data analytics program that will support the strategic and operational needs of the Office of Advancement.

The SDA provides high-level qualitative and quantitative data and trend analysis that supports the strategic planning and operational effectiveness of key fundraising programs including annual fund, major gift, primary, and planned giving, alumni engagement programs, and prospect research.

The SDA will initiate and support complex and time sensitive projects and is responsible for ensuring data is presented in a clear and actionable manner while supporting stakeholders with information that assists their decision making. A focus on improving data quality and communication via data should be at the forefront of all tasks and strategies.

Utilizing his/her established skills in providing data-driven business intelligence, the successful candidate will support and contribute to short and long term collection and analysis strategies that will provide program directors and managers with reliable data in illustrative formats to assist them in making informed decisions.  The incumbent will work with stakeholders across the university under to ensure the quality of data available for reporting and analytics.


 Advancement Analytics Program Support

  • Supports and contributes to Information Services’ comprehensive analytics program, providing data-driven intelligence to aid in determining University-wide and program fundraising goals
  • Develops and produces regular reports for senior leadership in order to monitor and review performance measures as well as short and long-term engagement strategies. Specific areas of reporting include, but are not limited to, gift and prospect pipeline, prospect management and portfolio penetration, and gift/cash analysis and forecasting and alumni engagement
  • Works with stakeholders in various areas of Advancement (including but not limited to Alumni Relations, Strategic Communications, and Development) to define quantitative analytics needs and influence stakeholder decisions as they pertain to the best way to visualize and analyze data
  • Actively seeks 3rd party data (publicly sourced or otherwise) to support data modelling and donor profile projects sponsored by the Director of Information Services and the MDA for internal clients such as (but not limited to) Prospect Research, Annual Fund, and Alumni Relations
  • Supports the university’s participation in various institutional surveys and benchmarking studies relevant to fundraising and advancement activities
  • Develops and validates statistical models for forecasting fundraising progress and alumni engagement using historical trend data and information from industry peers
  • Develops and validates predictive modeling to feed the pipeline of prospective donors in order for Advancement to achieve fundraising goals

 Data Modeling and Statistical Analysis

  • Supports constituent research, data mining and modeling activities to determine trends and provide hypothesis testing of patterns in alumni and donor behavior, identifying and forecasting growth opportunities and addressing challenges
  • Works with a variety of stakeholders, including Executive Leadership to influence the best way to analyze data to achieve accurate and effective results as they pertain to fundraising goals and donor engagement activities
  • Provides impactful insight as to how to develop affinity and predictive behavioral models to support short-term and long-term engagement and fundraising strategies
  • Develops predictive model custom scoring and provide recommendations to unit managers and fundraisers for how to interpret, understand and apply scoring in various fundraising and engagement activities
  • Gathers, filters and segments large data sets for the purposes of identifying, classifying and refining rated prospect lists and pools for fundraising activities. Identifies overall trends and patterns in giving, volunteerism, event participation, etc. and searches for explanations and underlying causes
  • Uses various software tools (such as Excel, SPSS, etc.) and techniques (regression, RFM analysis, cross-tabulation, pivotal table analysis etc.) to analyze and present the data analysis
  • Undertakes special projects as directed or supported by the MDA and/or Director of Information Services

Advancement Reporting

  • Works with a variety of stakeholders, including Executive Leadership to influence the best way to report on data to achieve accurate and effective results as they pertain to fundraising and advancement activities.
  • Owns the entire development life cycle of a new reports: initiation and scope identification, requirements gathering, design, development, testing and quality assurance, user acceptance testing, move product into the production environment. In this capacity, this role is similar to a Business Analyst role with the addition of technical expertise in order to complete the latter half of the development life cycle in addition to the initial analysis and client relationship components.
  • Develops and maintains a catalog of standards to ensure consistency of criteria in reporting.
  • Supports unit leaders to develop performance reporting
  • Supports end users in understanding Tableau reporting
  • Works with a variety of stakeholders to develop new, exciting and visually appealing dashboards to meet unit goals and needs
  • Acts as a resource to Advance users in understanding report criteria and standards
  • Acts as a subject matter expert in analytics for Advancement users

Tableau Training

  • Provides classroom training for Tableau users on a variety of dashboards
  • Provides user support (verbal and/or written) for Tableau use
  • Develops Tableau documentation/guides to further support user base


  • Bachelor's degree required, preferably with an emphasis in business, mathematics, statistics, information systems, or operations management is preferred
  • Three to five years’ experience in analyzing and synthesizing complex data sets and producing highly readable, informative reports for a variety of audiences, including non-technical users, would be an asset
  • Strong understanding of Oracle SQL and the ability to effectively query large databases
  • Expertise with a variety of analytical and database software, including Excel, Access, statistical analysis and forecasting programs (e.g. SPSS, SAS, Crystal Ball, Forecast Pro) and presentation software (e.g. Tableau)
  • Strong understanding of data mining and predictive modeling tools and techniques
  • Strong analytical and data interpretation skills; detail oriented, creative, inquisitive, persistent, and self-motivated in applying research and analytical abilities in meaningful ways to support the university's fundraising goals
  • Exemplary computer, information management and data retrieval skills; excellent communication and statistical analysis skills
  • Ability to quickly learn new technologies/applications
  • Experience in the field of higher education or other non-profit institution with a focus on fundraising preferred
  • Experience with alumni/development databases (experience with Advance is desirable)
  • Experience developing and maintaining a data warehouse preferred
  • Experience developing and validating forecasting methods preferred
  • Strong understanding of the best way to present large datasets i.e. strong data visualization skills
  • Ability to support multiple projects while working under tight deadlines without compromising project goals or quality of deliverables
  • Ability and willingness to work in a fast-paced collaborative team environment
  • Ability to maintain a very high level of confidentiality regarding the research projects being conducted

How to Apply

Apply Online

Note: Online applications are accepted until midnight Mountain Standard Time of the closing date.

We thank all applicants for their interest; however, only those individuals selected for an interview will be contacted.

The University of Alberta is committed to an equitable, diverse, and inclusive workforce. We welcome applications from all qualified persons. We encourage women; First Nations, Métis and Inuit persons; members of visible minority groups; persons with disabilities; persons of any sexual orientation or gender identity and expression; and all those who may contribute to the further diversification of ideas and the University to apply.