The Opportunity:

We are a leading Canadian financial services co-operative committed to being a catalyst for a sustainable and resilient society and our team is essential to deliver on this strategy. That’s why we prioritize our people, to ensure we provide a strong culture and development opportunities which enables our team to thrive and to live our purpose. The best part is that you will work with people that care passionately about you, our clients, and our communities.

Our Business Intelligence team empowers decision making using leading edge science and analytics. We strive to deliver a single version of truth, by providing our business partners with access to comprehensive data and valuable insights to help our organization achieve operational excellence.This senior role contributes to this mission using its analysis, development, storytelling, business analyst and statistician skills.

As a Business Intelligence Consultant, you will autonomously lead medium sized projects and tasks of large complexity and size, as well as to provide coaching and support to other team members. You will support the development and maintenance of the Lost Cost tool providing data for our Actuarial pricing teams. As a partner of the Sovereign insurance organisation, you will get to influence decisions by providing analytics to a large portfolio of commercial risks.

How you will create impact:

• Extract data as required for project analysis or analysis of our book of business using BI tools or programming language (SQL, R, MicroStrategy).

• Compile and present insightful stories to explain broad business insights that create value for our business partners and the organization’s leaders

• Document detailed business requirements including data, security, Dashboards, Visual Insight and Self Service reporting requirements.

• Construct, test, reconcile and document BI solutions.

• Advanced and efficient in using programming language and BI tools.

• Train and support our business users on our analytic solutions.

How you will succeed:

• You have an innovative mindset to improve operational efficiencies and ability to influence change, with a primary focus on client needs.

• You use critical thinking skills to recognize assumptions, evaluate arguments, draw conclusions and proactively propose solutions.

• You have strong communication skills to clearly convey messages and explore diverse points of view.

• You build trusting relationships and provide guidance to support the development of colleagues.

  
  

To join our team:

• You have 7 years of relevant experience in Business Intelligence or other relevant domain.

• You have a University Degree in Business Intelligence, Computer Science, Actuarial Science, Mathematics, Statistics or equivalent technical experience.

• You have experience writting complex SQL stored procedures.

• You have knowledge of a database structure and advanced capabilities in data analysis.

• Experience with database architecture is an asset.

• Experience in Property and Casualty insurance is an asset.

• Experience to the use of job related applications, technologies and programming languages (R, Python, Netezza, MicroStrategy, Azure) is an asset.

• Knowledge of actuarial concepts is an asset.

What you need to know:

• You will be subject to a Background check as a condition of employment, in the event you are the successful candidate.

What’s in it for you?

• Training and development opportunities to grow your career.

• Flexible work options and paid time off to support your personal and family needs.

• A holistic approach to your well-being, with physical and mental health programs and a supportive workplace culture.

• Paid volunteer days to give back to your community.

• A comprehensive total rewards package, including competitive salary, bonus, pension and benefits.