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

University Pension Plan Ontario; Toronto; Hybrid; CAD 90,000 - 100,000; Full time

Job summary

An innovative organization is seeking a Senior Business Intelligence & Data Analyst to join their dynamic team. This role offers a unique opportunity to leverage your analytics and visualization expertise to drive strategic decision-making in a collaborative environment. You will work closely with business leaders to design and implement critical analytics initiatives that support organizational goals. With a focus on equity and inclusivity, this position not only emphasizes professional growth but also fosters a culture of teamwork and respect. If you're passionate about data and making a meaningful impact, this role is perfect for you.

Benefits

Free Snacks and Beverages

Paid Mental Health Days

Supportive Onboarding Program

Qualifications

• 8+ years of experience in data visualization tools and expert Excel skills.
• Strong understanding of data modeling methodologies and best practices.

Responsibilities

• Lead design and implementation of analytics/business intelligence initiatives.
• Create and maintain interactive visualizations through data interpretation.

Skills

Data Visualization

T-SQL

Analytical Skills

Problem-Solving

Communication

Education

Undergraduate Degree in Quantitative Field

Tools

Power BI

Tableau

DOMO

Google Data Studio

Excel

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)

2 weeks ago Be among the first 25 applicants

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.

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.

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

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

  Analyst and Other

• Industries

  Financial Services and Pension Funds

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

Get notified about new Business Intelligence Analyst jobs in Toronto, Ontario, Canada.

Data Business Analyst [Investment & Capital Markets Domain] - Canada

Business Analyst-Azure data/ datawarehouse

Business Analyst Leader - IT II (MS Azure, API / Power BI, Power Apps or Power Automate)

Toronto, Ontario, Canada $90,000.00-$100,000.00 1 month ago

Toronto, Ontario, Canada CA$51.00-CA$58.00 2 weeks ago

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