Business Intelligence Engineer

Business Intelligence Engineer page is loaded

Business Intelligence Engineer

Apply locations Victoria, BC Vancouver, BC time type Full time posted on Posted 6 Days Ago job requisition id JR100807

CLOSING DATE: April 18, 2024

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 looking for a Business Intelligence Engineer to join our growing Corporate Data & Operations department for a 12-month, temporary role. This is an exciting time to be a part of a centralized team delivering re-usable datasets, reporting, data science, and data governance. Come join us in either our Victoria or Vancouver office!

POSITION DESCRIPTION

Reporting to the Manager, Data & Analytics Engineering, the Business Intelligence Engineer (BI Analyst) 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.

This is a 12-month temporary role with potential for extension.

This is an on-site position that can be based in either our Vancouver or Victoria office.

WHAT YOU BRING

• Bachelor’s degree in Data, Science, Technology, Engineering, Mathematics, or a related field

• A minimum of 5 years of experience with responsibility for developing production business intelligence solutions such as reports and dashboards

• Experience learning, conducting technical data analysis, and extracting and transforming data from complex data stores

• Must be an expert with SQL for data querying

• Must be an expert with Power BI

• Must be proficient with designing complex data visualization solutions, whilst considering solution user experience

• Knowledge of PowerApps and/or a background in software engineering is an asset

• Knowledge of Python is an asset

WHAT YOU WILL DO

• 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

• Performs other related duties as required

WHERE YOU WILL WORK

Work from our downtown Victoria or Vancouver office.

SALARY RANGE

The annualized base salary range for this Victoria or Vancouver-based role is CAD $84,000 to $100,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 fourth 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 

• Annual wellness allowance to support an active lifestyle

• 6% pay in lieu of benefits 

• Enrollment in the Employee and Family Assistance Program 

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.

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!

About Us

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 $233 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.

Based in Victoria, British Columbia, with offices in Vancouver, New York City, and London, U.K., BCI manages a portfolio of diversified public and private market investments on behalf of our 32 British Columbia public sector clients.

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.

#J-18808-Ljbffr