data analyst

data analyst Edmonton

University of Alberta
Full Time Edmonton 117508 - 70500 CAD ANNUAL Today
Job description

VER Development & Alumni Rel.

Competition No. -
A113151265

Closing Date -
Jun 30, 2023



This position is a part of the Association of the Academic Staff of the University of Alberta (AASUA).

In accordance with the Administrative and Professional Officer Agreement, this full time continuing position offers a comprehensive benefits package found at Faculty & Staff Benefits and annual salary range of $70,500 - $117,508.

Location - Enterprise Square. This role is hybrid with a mix of remote and in person

Department summary

The goal of Information Services is to provide exceptional Advancement systems support, business process management and design, automated reporting solutions and data delivery for the Development and Alumni offices within External Relations. Information Services supports the strategic planning and operational effectiveness of all alumni relations functions as well as key fundraising programs including the annual fund, major gift and planned giving, alumni engagement programs, prospect management and research as well as major fundraising campaigns

Position summary

Reporting to the Manager, Information Services in the Office of Advancement Services, the Data Analytics Program Lead (DAPL) will be responsible for developing and implementing an integrated reporting and data analytics program that will support the strategic and operational needs of Development and Alumni Relations within the External Relations portfolio.

The DAPL manages a program, which includes all aspects of data analytics and data science including descriptive analytics, diagnostic analytics, predictive analytics and prescriptive analytics.

The DAPL works in a fast-paced dynamic work environment where the ability to provide reporting data quickly, clearly and with accuracy is paramount. The incumbent is responsible for the development and creation of all fundraising metrics and related performance reports to the University’s senior leadership. The DAPL also supports senior leadership by providing data from ad hoc requests, participating in vital benchmarking studies, and creating forecasting and financial models. The DAPL is a trusted advisor, working with highly sensitive and confidential information and is often looked upon by Executive Leadership for data guidance and reliable expertise

Duties

  • Responsible for managing a small team of analytics professionals.
  • Complete operations by assigning and monitoring work completed by the analytics team and providing real time feedback on staff performance.
  • Develop, maintain, enhance and oversee a comprehensive analytics program, providing data-driven intelligence to aid in determining University-wide and program fundraising goals.
  • Manage the data sources and reporting databases required to perform data analytics, ensuring adherence to data definitions and efficient data performance.
  • Develop and produce regular reports for senior leadership in order to monitor and review performance measures engagement strategies.
  • Direct, develop and validate statistical/financial models for forecasting fundraising progress and alumni engagement using historical trend data and information from industry peers.
  • Collect, collate and analyze complex data sets to participate in ongoing peer benchmarking studies on a variety of aspects in fundraising and alumni relations.
  • Develop quarterly and annual reporting and analyses for the Board of Governors, President’s Executive Committee, Provost Office, and any other governing bodies as required.
  • Being a subject matter expert in all advancement data, the DAPL will be able to quickly offer insight and effective solutions into data needs for the entire portfolio (both for ad-hoc data requests as well as automated report solutions).
  • The DAPL is responsible for seeing reports/dashboards through the development phases of the iterative reports/dashboard life cycle to produce elegant automated solutions that are visually appealing and easy to understand.
  • Direct activities to gather, filter and segment large data sets for the purposes of identifying, classifying and refining rated prospect lists and pools for fundraising activities. Identify overall trends and patterns in giving, volunteerism, event participation, etc. and search for explanations and underlying causes.
  • Responsible for all data requests within the portfolio that may involve the publication of statistics or figures.
  • Use 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.
  • Develop and validate statistical models for forecasting fundraising progress and alumni engagement using historical trend data and information from industry peers.
  • Develop 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.
  • Actively seek 3rd party data (publicly sourced or otherwise) to support data modelling and donor profile for internal clients.
  • Supporting 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.
  • Develop and maintain training material for the portfolio on business intelligence tools.

Minimum Qualifications

  • A Master’s in Business Administration or equivalent degree is required.
  • A minimum of 7 years’ experience in analyzing and synthesizing complex data sets and producing highly readable, informative reports for a variety of audiences, including non-technical users is required.
  • Ability to effectively manage a team of professionals by managing interpersonal relationships, performance management, and conducting annual staff evaluations including recommendations for merit awards.
  • Strong ability to effectively translate complex data sets and analyses into actionable insights and recommendations in a language that a wide range of audiences can understand.
  • 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), Business Intelligence software such as 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;
  • Ability to quickly learn new technologies/applications;
  • Strong understanding of the best way to present large datasets i.e., strong data visualization skills;
  • Ability to manage and lead 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.

Preferred Qualifications

  • Experience in the field of higher education or other non-profit institution with a focus on fundraising preferred.
  • Experience with ERP databases preferred.
  • Experience developing and maintaining a data warehouse preferred.
  • Experience developing and validating forecasting methods preferred

How to Apply

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

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority. If suitable Canadian citizens or permanent residents cannot be found, other individuals will be considered. 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.

About University of Alberta

CEO: Dr. David Turpin
Revenue: $2 to $5 billion (USD)
Size: 10000+ Employees
Type: College / University
Website: www.ualberta.ca

data analyst
University of Alberta

www.ualberta.ca
Edmonton, Canada
Dr. David Turpin
$2 to $5 billion (USD)
10000+ Employees
College / University
Colleges & Universities
Education
Related Jobs

All Related Listed jobs

Service Business Manager
Mitsubishi Power Europe, Ltd Paddington, England Today

Reporting to the Operations Director, you will be responsible for the coordination of the business planning and control for Mitsubishi Power EMEA branches and

Store Manager
LOAF London, England 32445 GBP ANNUAL Today

Leading a customer facing team by example to use their product knowledge and enthusiasm to maximise sales. Ensuring that all health and safety requirements are

Supply Graduate Scheme 2023
Reckitt Kingston upon Hull, England 36000 - 47400 GBP ANNUAL Today

Within this scheme you will be driving the delivery of quality products through the end to end Supply chain (Planning and Customer Services, Quality, Packaging,

Warehouse Operative/Tray Waster
Gi Group Coleshill, West Midlands, England 11 - 11.01 GBP HOURLY Today

(Needs own transport as Public transport is not available in the area). AM operatives will work 0600-1800. Free of site parking and canteen is onsite available.

Freelance Health and Social Care Trainer
Elite Careers Ltd Newham, England 12.5 - 18.75 GBP HOURLY Today

We are looking for an experienced and skilled healthcare trainer in London (although trainers from other locations are also encouraged to apply) with a minimum