Closing date: January 30, 2025

Use your analytical, data, and technical skills in a fast-growing company where you can have an impact. The British Columbia Investment Management Corporation (BCI) is currently seeking a co-op student/intern to support projects and initiatives being implemented as part of our Data and Analytics strategy for the Summer 2025 work term (May to August).

WHAT YOU NEED TO KNOW

BCI manages a globally diversified portfolio of assets valued at $250.4 billion and is one of Canada’s largest institutional investors. We invest globally to support pension and other funds for more than 30 clients based in British Columbia. We are proud to have been chosen as one of Canada’s Top 100 Employers and BC’s Top Employers. These national and provincial competitions recognize employers who offer exceptional workplaces for their employees.

The co-op/intern will work within our Corporate Data & Operations department as part of the Data and Analytics team. This is a great opportunity for you to learn and apply your knowledge to support the implementation of strategy, projects and services to the corporation.  As part of your work, you will help to support change management activities related to these initiatives.

WHO YOU WILL WORK WITH

The Corporate Data & Operations department delivers centralized, corporate business services that require partnership and integration across BCI departments. This role will work in the Data and Analytics team, which delivers analytics solutions (e.g. reports and dashboards), curated re-usable datasets, data science, data platforms, and data governance. Work for this assignment will focus on projects for BCI’s Corporate & Investor Relations department (CIR).

WHAT YOU WILL BE DOING

• Supporting the implementation of Data and Analytics projects and initiatives for CIR

• Creating reports and dashboards using Power BI and SQL

• Creating re-usable curated datasets using SQL

• Building test suites using the Great Expectations data quality framework

• Running and reviewing reports in CIR’s financial reporting solution “VisionFI”

THE IDEAL STUDENT

• Has a keen interest in data and technology and is a self-starter

• Demonstrates they are a team player, but can also work independently

• Demonstrates an extremely strong work ethic and displays initiative to strive to deliver value above and beyond the job description

• Comes up with creative ideas to improve the business reporting process

REQUIRED SKILLS

• Exhibit a high level of professionalism and excellent interpersonal skills

• Ability to meet deadlines while maintaining accuracy, excellent product quality, and attention to detail

• Has an interest in data, a dedication to hard work, commitment to the highest ethical standards, and an eagerness to learn

• Ability to use Excel, PowerPoint, Word and Outlook

• Familiarity using Microsoft 365 tools such as One Drive, SharePoint Online, and MS Teams would be an asset

• Familiarity with reporting tools such as Power BI, Tableau or SSRS

• Ability to read and write basic code scripts in SQL and Python

WHAT WE OFFER

• Excellent career development and training by contributing to a strategic program with high visibility

• Work with a dynamic team in a fast-paced environment

• The development of real-world skills at one of the largest institutional investors in Canada

• Exposure to some of the most talented, approachable, and inspiring people in the industry

• The ability to opt-in for access to Dialogue, a user-friendly app that offers virtual primary care, employee and family services, and mental health supports

• Time to connect with co-op students & interns at BCI – build your network and shared learning

• BCI investment professionals lead a monthly Investment Club to share industry knowledge with employees who work in other departments

• 2 paid days per year for volunteering

• Competitive pay: Mid / Back Office: $2,260.00 gross bi-weekly or $2,090.00 gross bi-weekly + vacation leave paid based on 6% of salary ($2,260.00 gross biweekly for those with (or working towards) a graduate degree or joining the Investment Strategy & Risk department and $2,090.00 gross biweekly for those with (or working towards) an undergraduate degree, diploma, or certificate)

• Travel: if coming to Victoria for this work term, BCI will provide a fixed-rate travel allowance based on your location

THE DETAILS

• Work term: Summer 2025 (May to August)

• Department: Corporate Data & Operations

• Office Location: 666 Burrard St, Vancouver, BC

• Travel: if coming to Vancouver for this work term, BCI will provide a fixed-rate travel allowance based on your location

• This co-op/internship will need to be completed in person at our Vancouver office with the option to work one day per week from home. Please note, some positions are not eligible for hybrid work.

HOW TO APPLY

• Apply directly to the Data Analytics Co-op/Internship posting on our careers page https://bci.wd10.myworkdayjobs.com/BCI_Careers

• Application deadline: January 30, 2025 at 11:59pm PT

• Please upload a cover letter, resume, and transcripts (unofficial transcript will suffice)

• Note: We welcome applications from all qualified candidates who are interested in applying for this role. You will need to be legally authorized to work in the country where this job is located. If you currently do not have authorization or if your work permit, study permit, or visa has restrictions or is due to expire during the work term, you may not be eligible for this opportunity.

At BCI, we value diversity and believe in fostering an inclusive culture where all employees can be successful.

We are performance and client focused and value integrity; if you share these values, we want to know you. 

We recognize that some skills can be learned on the job and encourage all to apply.

If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), contact us at [email protected].

We would like to hear from you!