Senior Analyst, Data and Analytics

University of Ottawa•Stewart, BC

1d•CA$92,685 - CA$115,243•Onsite

About The Position

University Advancement plays a pivotal role in fostering meaningful connections between the University and its alumni, donors, and partners. Our team is dedicated to advancing the University's mission by securing philanthropic support, engaging with our vibrant alumni community, and building partnerships that drive innovation and excellence. Through strategic initiatives and collaborative efforts, we help shape the future of the University, ensuring that it continues to thrive as a leading institution of higher education and research. Together, we empower our students, faculty and researchers to make a lasting impact on the world. Supporting evidence-based decision-making and the University of Ottawa’s strategic priorities, the incumbent manages and optimizes the CRM platform and its data. The role is responsible for ensuring data integrity, governance, and system effectiveness, while analyzing and interpreting CRM data to provide actionable insights that support strategic planning, operational efficiency, performance monitoring, and continuous improvement. Working closely with internal stakeholders, the incumbent translates business needs into data-driven solutions that maximize the value of the CRM platform.

Requirements

University degree in data analytics, computer science or a related discipline, or an equivalent combination of education and experience.
Minimum of 3–5 years of relevant experience in data analysis, reporting or business intelligence in a large, complex CRM environment.
Bilingualism – French and English (spoken and written).
Demonstrated experience working with datasets from multiple systems and producing clear analytical outputs for diverse audiences.
Superior interpersonal skills, with proven ability to successfully collaborate with varied parties in a professional and diplomatic manner.
Strong analytical and problem-solving skills with attention to detail.
Ability to translate data into clear insights and recommendations for non-technical stakeholders.
Experience with data visualization and reporting tools.
Knowledge of database concepts, data structures and analytical methodologies.
Excellent organizational and time-management skills, with the ability to manage multiple priorities and deadlines.
Strong computer skills and ability to learn new systems quickly.
Knowledge and advanced skills in Microsoft Office are strong assets.
Experience using query languages such as SQL, SOQL or similar.
Planning: Organize in time a series of actions or events in order to realize an objective or a project. Plan and organize own work and priorities in regular daily activities.
Initiative: Demonstrate creativity and initiative to suggest improvements and encourage positive results. Is proactive and self-starting. Show availability and willingness to go above and beyond whenever it is possible.
Client Service Orientation: Help or serve others to meet their needs. This implies anticipating and identifying the needs of internal and external clients and finding solutions on how to meet them.
Teamwork and Cooperation: Cooperate and work well with other members of the team to reach common goal(s). Accept and give constructive feedback. Able to adjust own behaviour to reach the goals of the team.

Nice To Haves

Salesforce Administrator certification is considered an asset.

Responsibilities

Collects, analyzes and interprets quantitative and qualitative data from multiple internal systems and sources to support reporting, forecasting and performance assessment.
Develops regular and ad hoc reports, dashboards and visualizations that present clear, accurate and timely insights aligned with strategic and operational needs.
Ensures data accuracy, integrity and consistency by validating data sources, identifying discrepancies, and recommending corrective actions.
Establishes and maintains data standards, documentation, and best practices to support reliable data usage and long-term sustainability.
Acts as the primary steward of the organization's CRM platform, overseeing data governance, data imports and exports, and system configuration and workflows.
Transforms complex datasets into meaningful insights that support planning, prioritization and decision-making.
Identifies trends, patterns and risks, and provides analysis to support strategic initiatives, management reporting and continuous performance improvement.
Works closely with internal partners to understand analytical needs and provide tailored data solutions.
Supports stakeholders in interpreting data, understanding implications and applying insights to their respective areas of responsibility.
Supports operational planning and monitoring by developing metrics, key performance indicators and tracking tools.
Responds to data requests from leadership and operational teams, ensuring clarity of scope, timelines and deliverables.
Ensures analytical practices comply with university policies, data governance standards and privacy requirements.
Maintains documentation of methodologies, assumptions and definitions to promote transparency and reproducibility.
Keeps apprised of emerging strategies on data analysis and management and identifies opportunities to integrate these strategies into the University’s advancement service and to standardize business processes.
Performs other duties in support of the University’s data analysis and management efforts as assigned.