Senior Business Intelligence & Data Analyst (9-Month Contract)

University Pension Plan Ontario; Toronto; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

Join a leading organization as a Senior Business Intelligence & Data Analyst, where you will leverage your analytics expertise to drive strategic decision-making. With a focus on data visualization and collaboration, this role offers a hybrid work environment that embraces flexibility and innovation within the university sector.

Benefits

Flexible hybrid work model

Free snacks and beverages in the office

Paid Mental Health Days

Qualifications

• Minimum of 8 years of experience in data visualization tools.
• Excellent proficiency in T-SQL required.
• Strong understanding of data modeling methodologies.

Responsibilities

• Lead design, development, and implementation of analytics initiatives.
• Ensure alignment of user stories to business objectives.
• Create and maintain interactive visualizations using various tools.

Skills

Data Visualization

T-SQL

Analytical Capabilities

Problem-Solving

Education

Undergraduate degree in quantitative field (Math, Computer Science, Analytics, Statistics)

Tools

Power BI

Tableau

DOMO

Job description

Senior Business Intelligence & Data Analyst (9-Month Contract)

Join to apply for the Senior Business Intelligence & Data Analyst (9-Month Contract) role at University Pension Plan Ontario

Senior Business Intelligence & Data Analyst (9-Month Contract)

Join to apply for the Senior Business Intelligence & Data Analyst (9-Month Contract) role at University Pension Plan Ontario

Get AI-powered advice on this job and more exclusive features.

About Upp

UPP is the first pension plan of its kind in Ontario’s university sector, proudly serving over 41,000 members across five universities and fourteen sector organizations. Our purpose is to bring greater retirement peace of mind to the university sector by investing with integrity and serving members with care. As a sector-wide plan designed for growth, our doors are open to all Ontario universities.

About Upp

UPP is the first pension plan of its kind in Ontario’s university sector, proudly serving over 41,000 members across five universities and fourteen sector organizations. Our purpose is to bring greater retirement peace of mind to the university sector by investing with integrity and serving members with care. As a sector-wide plan designed for growth, our doors are open to all Ontario universities.

Together, we’re a team of progressive thinkers and agile doers operating within a fast-paced culture of collaboration and respect. We believe in bringing smart and capable people together to create, solve and grow with a clear shared vision and values of integrity, inclusivity, ingenuity, and impact.

Our culture is intentionally welcoming and purposefully rooted in equity, diversity, inclusion, and reconciliation (EDIR). We believe diverse teams, perspectives, and lived experiences contribute to better decisions and a better workplace.

As a long-term investor, we recognize that environmental, social and governance (“ESG”) factors support risk management and value creation. As stated in our Responsible Investing Policy, we are committed to incorporating ESG considerations into our investment management activities and we collaborate with other industry participants in the promotion of a sustainable economy and society.

Join us in building a bright future for our members, our organization, and each other.

THE ROLE

We are seeking a motivated Senior Business Intelligence (BI) & Data analyst with diverse technology and business experience and a proven background connecting data to business outcomes.

This is a fantastic opportunity for an experienced analytics and visualization professional to join a team of high-performing individuals and make a great impact in a start-up organization. Reporting directly to the Director, Data and Analytics, the Senior BI & Data analyst will partner with business leaders and their teams to lead the design, development and implementation of critical analytics/business intelligence initiatives and projects that will contribute to strategic decision-making across the UPP.

This role is based in downtown Toronto in a hybrid work environment, allowing employees the flexibility to work remotely and in-office (minimum two days per week in-office).

Key Responsibilities

The Senior BI & Data Analyst will be responsible for a variety of duties, including but not limited to the following:

• Contribute to the stakeholder requirements workshops and ensure alignment of the user stories to business objectives
• Support the strategic design, execution, and maintenance of the BI and visualization use cases
• Create and maintain interactive visualizations (e.g., Power BI, Tableau, Google data studio, Looker, Qlik Sense, DOMO) through data interpretation and analysis, integrating various reporting
• Work closely with project/delivery managers to understand and design dashboards to meet their analytical requirements, including identifying and creating or enhancing critical metrics
• Ensure consistency of dashboards design across global business use cases
• Facilitate and coordinate with business source system administration teams on data architecture and direct system feeds
• Understand database structures and facilitate changes where required
• Oversee the publishing of dashboards (with refreshed data on a defined business need e.g., daily, weekly, quarterly, and annual basis)
• Assist with the preparation and development of reporting, presentations, and various materials for discussion at the executive level
• Build efficiencies in existing processes and execution of process improvement initiatives where possible
• Support the research, analysis, reporting and execution of data program initiatives
  
  

Qualifications & Experience

• Undergraduate degree or higher post-secondary education in quantitative field of study (Math, Computer Science, Analytics, Statistics etc.)
• Minimum of 8 years of combined experience in a data visualization tools (e.g., DOMO, Microsoft Power BI, Tableau, Google data studio Looker, Qlik Sense) and Expert Excel skills
• Excellent proficiency in T-SQL
• Exceptionally strong work ethic and a high level of analytical capabilities, attention to detail & problem-solving skills
• Team player with the ability to build strong relationships across the organization at all levels; and
• Strong understating of data modelling methodologies and best practices for data visualization techniques
  
  

Nice To Have Skills

• Experience with programming languages such as Python, R, JSON, YAML, Shell Scripting, MDX, VBA
• Experience with statistical modeling in business analytics
• Experience in the business domains of Pensions, Investments, and Corporate Functions
• Experience with DOMO
• Experience with Google Cloud Platform and Big Query
• Understanding of Financial Reporting
  
  

ATTRIBUTES

• Excellent written and verbal communications
• Foster a collaborative and open two-way communication on progress, issues and blockers with both internal and external stakeholders
• Ability to design and execute repeatable processes
• Ability to organize and drive results from multi-layer matrix stakeholders
• Ability to engage and align users and partners to reach consensus
• Ability to pivot and update design to delivery as required by changing priorities and user stories
• Ability to effectively identify emerging technologies, trends, standards, and products that have a strong potential to better enable UPP business units
  
  

LIFE AT UPP

Do work that matters. We are duty-bound to serve our members’ interests, and it’s a responsibility we don’t take lightly. That’s why we’ve ingrained sustainability in our work from day one—to ensure our members have a resilient future to retire into, both today and for generations to come.

Stronger together. Collaboration is how UPP was born, and it’s how we work with each other and our partners day in, day out. No one at UPP is just a number (even if they are excellent at math) and every win is a shared win.

Grow every day. You’ll have the opportunity to work on unique, once-in-a-career projects that maximize your skill set and probably teach you some new ones—at any stage in your career.

Benefits

Prioritize wellness. At UPP, wellness takes many forms. Ultimately, it’s about ensuring our people are cared for in the ways that matter to them. Check out some highlights of our inclusive employee-focused benefits program including:

• Supportive and welcoming onboarding through the UPP Buddy Program
• Free snacks and beverages (coffee, tea, and flavored water) in the office
• Paid Mental Health Days
• Flexible hybrid work model
  
  

UPP enthusiastically welcomes applications from all qualified applicants and especially invites people with lived experience as an Indigenous person, a person with a disability or as a member of another Human Rights Code protected group that faces barriers to employment to apply. Our goal is to create a barrier-free experience for every candidate throughout the recruitment process, so if you require accommodation at any point during the process, please let us know so that we can make the appropriate arrangements. It would be our honor to work with you to adapt our processes to ensure that you can meaningfully participate.

UPP respects your privacy. For information on how UPP handles the personal information you provide during the application process, please see our Job Applicant Privacy Statement.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Research, Analyst, and Information Technology

Referrals increase your chances of interviewing at University Pension Plan Ontario by 2x

Sign in to set job alerts for “Senior Business Intelligence Analyst” roles.

Senior Business Intelligence Analyst (Power Automate / Apps)

Senior Business Intelligence Analyst, Business Innovation and Operations Management (Hybrid, Toronto)

Senior Business Intelligence Analyst - Marketing Delivery

Business Analyst-Azure data/ datawarehouse

Business Intelligence Manager- Biopharma

Senior Specialist, Data Analysis Product Management

Richmond Hill, Ontario, Canada 1 week ago

Senior Data Analyst – Measurement, Triangle Retail Media

Senior Analyst, Credit Risk Data, Analytics, and Platforms

Manager, Business Intelligence and Reporting

Greater Toronto Area, Canada $65.00-$90.00 3 weeks ago

Sr. Analyst, Data Science and Analytics Solutions - 12 Months Contract

Toronto, Ontario, Canada CA$36.55-CA$36.55 2 weeks ago

Senior Specialist, Data Analysis Product Management

Senior Business Analyst, Data Integration & Performance Platform (12 month contract)

Business Analyst with Big-Data HDFS, SQL

Assistant Asset Management Data Analyst – Co-op

Business Analyst, Investment Data Operations

Senior Business Analyst, Player Engagement

Intermediate Business Analyst - Client Data and Onboarding

Senior Analyst, Data & AI Ethics - Research

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.