Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailClosing 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 reusable datasets reporting data science and data governance. This is a 12month 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.
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 BCIs corporate strategy and plays an integral role in its by ensuring staff have highquality data advanced analytics for decisionmaking and wellappointed global offices for collaboration. The department is a critical part of how BCI delivers longterm value for our clients.
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.
Bachelors degree in data Science Technology Engineering Mathematics or a related field
A minimum of 35 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
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 endusers 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 testdriven development and automated testing
Work from our downtown Victoria office.
BCI offers a competitive total rewards package which includes a performancebased incentive plan comprehensive health & dental benefits a defined benefit pension plan and paid time off.
The annualized base salary range for this Victoriabased role is CAD $90000 to $109000.
The base salary offered to the successful candidate will consider a wide array of factors including but not limited to the individuals 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.
With our values as our anchor its our people that help shape employeefocused 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 Canadas 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 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 worklife balance.
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 .
We would like to hear from you!
Full-Time