Closing date: May 1, 2025
Want to play a critical role by leveraging your design and technical skills to turn data into insights which help drive business decisions? If you are looking for a Data & Analytics career in the investment management industry, BCI is hiring for a new Business Intelligence Engineer II to join our world class Corporate Data & Operations department. This is an exciting time to be a part of a centralized team delivering re-usable datasets, reporting, data science, and data governance. This is a 12-month term role with a preference for someone located in Victoria, BC (or willing to relocate to Victoria, BC). The ability to work from our downtown Vancouver office could be considered for the right candidate.
DEPARTMENT DESCRIPTION
The Corporate Data & Operations department is a central hub that delivers essential business services across all departments within BCI. The department is comprised of three branches: Data & Analytics, Workplace Services, and Business Planning. The department facilitates BCI’s corporate strategy and plays an integral role in its execution by ensuring staff have high-quality data, advanced analytics for decision-making, and well-appointed global offices for collaboration. The department is a critical part of how BCI delivers long-term value for our clients.
THE OPPORTUNITY
Reporting to the Manager, Data & Analytics (Operations), the Business Intelligence Engineer is responsible for conducting requirements gathering and business analysis, designing, developing, and delivering Business Intelligence (BI) solutions such as reports and dashboards. The BI Engineer works closely with internal team members, such as the Data Product Manager and Data Engineers, and collaborates with the business and technology teams.
WHAT YOU BRING
-
Bachelor’s degree in data, Science, Technology, Engineering, Mathematics, or a related field
-
A minimum of 3-5 years of experience with responsibility for developing production business intelligence solutions such as reports and dashboards
-
Experience conducting business requirements gathering and business analysis
-
Experience learning, conducting technical data analysis, and extracting and transforming data from complex data stores
-
Must be proficient with SQL
-
Must be proficient in Power BI or similar modern data visualization tools
-
Must be proficient with designing complex data visualization solutions, whilst considering solution user experience
-
Knowledge of the investment management industry is an asset
-
Knowledge of agile development and agile tracking tools (e.g., Jira) is an asset
-
Knowledge of Python is an asset
WHAT YOU GET TO DO
The following responsibilities are illustrative of a standard Level 2 and may be scaled down or up in leadership, complexity, and autonomy based upon the level selected.
-
Engages with stakeholders to understand business problems and opportunities that can be supported through data by conducting requirements gathering and analysis
-
Designs and proposes business intelligence solutions which solve business problems
-
Analyzes data sources and complex data stores and writes production grade, high performing SQL to extract data
-
Develops business intelligence solutions such as reports and dashboards, with a focus on user experience and design
-
Conducts quality assurance testing, to ensure solutions built are accurate, high functioning, performant, and meet client requirements
-
Provides training and support to end-users of business intelligence software and solutions
-
Presents products to internal and external stakeholders, reviews the work of other engineers, and provides feedback in an open, respectful, and constructive manner
-
Diagnoses and resolves incidents and provides responsive communication to stakeholders
-
Creates and maintains technical documentation and user guides for business intelligence solutions
-
Proactively identifies risks and issues and proposes solutions to remove barriers
-
Applies knowledge of DevOps practices including continuous deployment, continuous integration, test-driven development, and automated testing
Work from our downtown Victoria office.
SALARY RANGE
BCI offers a competitive total rewards package which includes a performance-based incentive plan, comprehensive health & dental benefits, a defined benefit pension plan and paid time off.
The annualized base salary range for this Victoria-based role is CAD $90,000 to $109,000.
The base salary offered to the successful candidate will consider a wide array of factors including but not limited to the individual’s skill set, level of experience applicable to the role they are being offered and consideration to internal equity.
We pay our people competitively in the markets in which we compete for talent and with consideration to internal equity and job structure. We aim for actual pay to be around the median of the market for target or expected levels of performance, and around the upper quartile of the market for excellent performance.
Actual salaries may vary and may be above or below the range based on various factors, including, but not limited to, experience and expertise.
WHY APPLY TO JOIN BCI
With our values as our anchor, it’s our people that help shape employee-focused initiatives and who create the environment we work in each day – all of which further strengthens our culture. BCI has been recognized as one of Canada’s Top 100 Employers – for the sixth consecutive year - and has built programs and benefits to support all our employees, including those on temporary contracts:
-
Eligibility for the defined benefit BC Public Service Pension Plan, providing you with a secure retirement income. Comes into effect once 50% of maximum pensionable earnings are reached
-
Time off includes: 10 days' vacation, 6 paid sick days
-
6% pay in lieu of benefits
-
Enrollment in the Employee and Family Assistance Program
-
Four days in office, with the option to work from home once a week, promoting both a collaborative work culture and a healthy work-life balance.
TO APPLY
Apply online with a copy of your resume. We encourage timely submissions of applications as candidates will be actively reviewed and the interview process may advance earlier.
Screening process: As part of our interview process, we will require candidates selected for the first round of interviews to complete a short test on their SQL skills, as this is a mandatory requirement for the role.
Referrals: If you are currently connected with a BCI employee and plan to list them as a referee, please ensure you reach out to them first to get their consent to do so. All referrals will be verified internally.
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!
Top Skills
What We Do
British Columbia Investment Management Corporation (BCI) offers an exceptional opportunity to work at a world-class organization. With $250.4 billion of gross assets under management, BCI is the provider of investment management services to British Columbia’s public sector. We invest globally across a range of asset classes and strategies in public and private markets. BCI generates the investment returns that help our British Columbian public sector clients build financially secure futures.
The people who work at BCI are committed, passionate, and approachable. They aim for continuous improvement and share BCI’s core values of clients first, performance focused, world class, accountability, transparency, and integrity. Being recognized as one of Canada’s Top 100 Employers, Canada’s Top Family-Friendly Employers and BC’s Top Employers exemplifies BCI’s ongoing commitment to be a progressive workplace of choice; one that attracts, retains, and promotes talent so that we can continue to work towards meeting our clients’ financial goals. As an active in-house asset manager, BCI depends on specialized skills and expertise to successfully execute its world-class investment strategies and fulfill client needs. We are currently expanding our team and our skill base to equip BCI for the future.
