Data Analyst

Job Category

Job Profile

Job Title

Department

Compensation Range

The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge, qualifications and experience for the position. In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.

Posting End Date

Note: Applications will be accepted until 11:59 PM on the Posting End Date.

Job End Date

At UBC, we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research, innovation, and learning for all faculty, staff and students. Our commitment to employment equity helps achieve inclusion and fairness, brings rich diversity to UBC as a workplace, and creates the necessary conditions for a rewarding career.

Job Description Summary

The Data Analyst leads quantitative research to support planning, leadership decision-making, and comprehensive program delivery strategy for Development and Alumni Engagement (DAE). Insights and recommendations drive strategic and tactical planning to improve operational effectiveness regarding the identification, cultivation, solicitation and stewardship of donors at all levels and the engagement of UBC s alumni and volunteers.

The Data Analyst provides comprehensive and expert data analysis support to initiatives and projects that identify prospective donors, determine trends, forecast growth opportunities and provide increased understanding of patterns in alumni, donor, and volunteer behavior. Using a combination of large university and external datasets, the analyst predicts outcomes and prescribes the best decision options related to UBC s alumni, donors, prospects and volunteers. The Data Analyst prepares analytical reports and presentations for UBC Executive, Alumni Association Board, and DAE senior leaders and develops self-serve and interactive dashboards to meet the data analytic needs for DAE staff. The Data Analyst contributes to a clear governance framework and documented protocols for the management of data used in analysis and resulting scores and metrics to ensure the integrity, quality and security of information.

Organizational Status

Reports to Manager, Data Analytics and is also accountable to senior leaders for project results.

Works closely with senior leaders in DAE to identify projects of strategic importance, the Director, Data Governance and Business Intelligence, and DAE analysts who provide data analysis assistance and contribute business knowledge to projects. Supervises work-learn and/or co-op students. Trains and supports all DAE staff.

Work Performed

- Plans and leads the consultation process for complex research projects to support development and alumni engagement across UBC.
- Leads and delivers major quantitative research initiatives that identify prospective donors, determine trends, forecast growth opportunities and provide strategic understanding of patterns in alumni and donor behavior.
- Provides statistical data analysis to support fundraising targets and policy objectives, using regression analysis, time series analysis, predictive modelling and segmentation, machine learning algorithms, text analysis, and spatial analysis.
- Participates in the development of policies and performance metrics and tracks and reports on results.
- Demonstrates the impact of performance and focuses on efficient and effective services.
- Develops and designs methodologies and standards to produce regular statistical reports.
- Documents all necessary business and technical details related to data analytics outputs, and uses in-house version control and project management tools to track and report on progress.
- Implements all stages of analytics projects.
- Contributes to the development of business cases, project plans, status reports, scope, deliverables and timelines related to small to medium data analytics projects
- Prepares information using data visualization techniques for analytics reports, proposals and presentations for UBC executive, Alumni Association Board, UBC Board of Governors and DAE leadership.
- Develops self-serve tools such as interactive reports and dashboards to meet the data analytics needs for DAE.
-Imparts understanding of complex technical ideas and results to non-technical audiences through the effective use of words, infographics and interactive data visualizations.
- Extracts, cleans, transforms, and synthesizes structured and unstructured internal UBC data and external data.
- Remain current on DAE s data sources, and ensure integrity, quality, security, and a high degree of usability for data used in analysis and resulting metrics, scores and attributes.
- Collaborates on the integration of data analytics outputs into CRM, design and delivery of training materials and sessions to DAE staff.
- Researches and develops of current and emerging trends in philanthropy, alumni engagement, higher education and complex data analysis. Liaises and collaborates with other UBC departments and other universities.

Consequence of Error/Judgement

This position has significant influence on the University s fundraising and alumni engagement programs and is fully accountable for errors. Incorrect research design or interpretation of information could result in significant loss of revenue for the University by directing our fundraisers towards unproductive activities. Poor recommendations and decisions would result in inefficient resource allocation, poor practices, ineffectual programs, and compromise delivery of UBC s executive-approved projects and initiatives. Errors in accuracy, judgement, or ethics could result in a significant and wide-spread loss of credibility and reputation for the University and its initiatives since DAE has such a large public outreach, with millions of communications each year. A privacy breach could potential affect all of our alumni and donors, resulting in significant fines, and irreparable damage to key UBC relationships.

Supervision Received

Works with a high degree of independence under the direction of the Manager, Data Analytics. Work is reviewed in terms of achievement of high professional standards and broad project objectives and goals.

Supervision Given

Manages student co-ops. Leads interdisciplinary project teams. Works in collaboration with DAE executive and program directors, researchers, data specialists, IT architects, report writers, business analysts, and data governance experts.

Minimum Qualifications

Post graduate degree in a relevant discipline. Post-graduate degree preferred. Minimum of four years of related experience, or the equivalent combination of education and experience.

- Willingness to respect diverse perspectives, including perspectives in conflict with one's own

- Demonstrates a commitment to enhancing one's own awareness, knowledge, and skills related to equity, diversity, and inclusion

Preferred Qualifications

Post-graduate degree preferred. Experience in quantitative research and advanced data analysis. Experience working in a university environment is an asset. Strong strategic thinking and analytical skills. Able to see the big picture opportunities and challenges and recommend meaningful action. Proven ability to undertake research project design, implementation, deployment and management. Proficient with statistics, data modelling, text analytics, survey design, spatial analysis and additional social science research methodologies. Demonstrated ability to extract data and analyze using programming and scripting. Proficient with statistical software (R/Stata/ Python), spreadsheets, data visualization applications (Tableau/Power BI), and relational databases (SQL). Experience with Blackbaud CRM, and GIS applications is an asset. Ability to meet business and customer needs through data analysis. Highly accountable for achieving results and comfortable driving for change. Leads through influence and engenders trust from a wide variety of people. Brings strong planning and project management skills. Exceptional service orientation, interpersonal and collaboration skills. Excellent written and verbal communications skills. Imparts understanding of complex ideas and statistics through words, infographics and interactive data visualizations. Delivers effective presentations to multi-disciplinary audiences, both technical and non-technical. Subject knowledge of Development (Fundraising), Alumni Affairs and other Advancement areas is recommended. Strong organizational and time management skills and attention to detail. Ability to work under pressure against deadlines and work collaboratively in a closely-knit team. Able to develop thorough knowledge of development, the donor lifecycle, alumni relations, and the post-secondary education sector. Understands privacy, copyright, and data security laws and best practices. Committed to ethical fundraising and research practices.