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

University Pension Plan Ontario • Toronto, Ontario, Canada • 13h ago

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