Business Intelligence Engineer II

BCI; Vancouver; Hybrid; CAD 90,000 - 109,000; Full time

Job summary

An established industry player in investment management is seeking a Business Intelligence Engineer II to join its dynamic Corporate Data & Operations team. This role offers the chance to leverage your technical expertise in SQL and Power BI to transform complex data into actionable insights that drive strategic business decisions. You'll engage with stakeholders, design innovative BI solutions, and collaborate with talented professionals in a supportive environment. With a competitive salary and a commitment to employee well-being, this opportunity is perfect for those looking to make a significant impact in the data analytics field.

Benefits

Comprehensive health & dental benefits

Defined benefit pension plan

Paid time off

Employee and Family Assistance Program

Work from home option

Flexible work schedule

Qualifications

• 3-5 years of experience developing BI solutions like reports and dashboards.
• Proficient in SQL and Power BI with a focus on user experience.

Responsibilities

• Conduct requirements gathering and business analysis to design BI solutions.
• Develop reports and dashboards, ensuring high performance and accuracy.

Skills

SQL

Power BI

Data Visualization

Data Analysis

Python

Agile Methodologies

Education

Bachelor's degree in Data Science

Bachelor's degree in Technology

Bachelor's degree in Engineering

Bachelor's degree in Mathematics

Tools

Jira

Job description

Join to apply for the Business Intelligence Engineer II role at BCI

2 weeks ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

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

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

WHERE YOU WILL WORK

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 [e-mail].

We would like to hear from you!

About BCI

British Columbia Investment Management Corporation (BCI) offers an exceptional opportunity to work at a world-class organization while living in a west coast setting. 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Industries

  Investment Management

Referrals increase your chances of interviewing at BCI by 2x

Get notified about new Business Intelligence Engineer jobs in Vancouver, British Columbia, Canada.