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

myUPP; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking organization as a Senior Business Intelligence & Data Analyst, where your expertise in data visualization and analytics will drive impactful decisions. In this dynamic role, you will collaborate with business leaders to design and implement critical BI initiatives, leveraging tools like Power BI and Tableau. This position offers a hybrid work environment, providing flexibility while being part of a passionate team dedicated to enhancing the retirement experience for university sector members. If you're looking to make a significant impact in a supportive and inclusive workplace, this opportunity is for you.

Benefits

Free Snacks and Beverages

Paid Mental Health Days

Welcoming Onboarding Program

Qualifications

• 8+ years of experience in data visualization tools and expert Excel skills.
• Strong analytical capabilities and problem-solving skills required.

Responsibilities

• Lead design and implementation of BI initiatives for strategic decision-making.
• Create and maintain interactive visualizations through data analysis.

Skills

Data Visualization

Analytical Skills

T-SQL

Problem-Solving

Team Collaboration

Education

Undergraduate Degree in Quantitative Field

Tools

Power BI

Tableau

DOMO

Google Data Studio

Looker

Qlik Sense

Excel

Job description

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

Monday, April 14, 2025

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. 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. We are committed to incorporating ESG considerations into our investment management activities.

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

• Contribute to stakeholder requirements workshops and ensure alignment of user stories to business objectives.
• Support the strategic design, execution, and maintenance of 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.
• Work closely with project/delivery managers to understand and design dashboards to meet their analytical requirements.
• Ensure consistency of dashboard 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.
• Assist with the preparation and development of reporting, presentations, and materials for discussion at the executive level.
• Build efficiencies in existing processes and execution of process improvement initiatives.
• Support the research, analysis, reporting, and execution of data program initiatives.

QUALIFICATIONS & EXPERIENCE

• Undergraduate degree or higher post-secondary education in a quantitative field (Math, Computer Science, Analytics, Statistics, etc.).
• Minimum of 8 years of combined experience in 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, and problem-solving skills.
• Team player with the ability to build strong relationships across the organization at all levels.
• Strong understanding of data modeling 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 communication skills.
• 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. 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.

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.

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.