Data & Analytics Engineer / Senior Data & Analytics Engineer (6-month term)

BCI Corporation; Victoria; On-site; CAD 90,000 - 109,000; Full time

Job summary

A leading investment management firm in Victoria is looking for a Data & Analytics Engineer to join their Corporate Data & Operations team. This role involves conducting requirements gathering, creating analytical solutions, and performing data analysis to support innovative data-driven initiatives within the organization. The ideal candidate has a strong background in data engineering with proficiency in Power BI, SQL, and analytics tools. This position offers competitive compensation and a dynamic work environment.

Benefits

Competitive total rewards package

Comprehensive health & dental benefits

Defined benefit pension plan

Paid time off

Qualifications

• Minimum 3 years of experience in data engineering, BI development, or analytics engineering.
• Experience with the HR data domain is an asset.
• Experience with cloud-based data platforms is an asset.

Responsibilities

• Conduct requirements gathering and propose analytical solutions for business use-cases.
• Create and maintain analytical solutions using tools like Power BI.
• Lead the design and technical architecture of projects end-to-end.

Skills

Power BI

Excel

SQL

Agile methodologies

Data modeling

Data architecture fundamentals

Communication skills

Problem-solving skills

Education

Bachelor's degree in Data Science, Technology, Engineering, Mathematics or related field

Tools

Databricks

Snowflake

BigQuery

Python

Job description

About Us :

With $295.0 billion of gross assets under management, as of March 31, 2025, British Columbia Investment Management Corporation (BCI) is the provider of investment management services for British Columbia’s public sector and one of the largest asset managers in Canada. BCI seeks investment opportunities around the world and across a range of asset classes that convert savings into productive capital. Our investment returns play a significant role in helping our institutional clients build a financially secure future for their beneficiaries.

Headquartered in Victoria, British Columbia, and with teams spanning Vancouver, New York, London, and Mumbai.

BCI integrates environmental, social, and governance (ESG) factors into all investment decisions to meet clients' risk and return requirements. Our people shape employee-focused initiatives, creating a strong culture. To learn more about our culture and values, visit our page.

POSTING CLOSE DATE :

Ope nuntilfilled

THE OPPORTUNITY

Are you passionate about building scalable data solutions and eager to contribute to cutting‑edge analytics initiatives? BCI is seeking a Data & Analytics Engineer / Senior Data & Analytics Engineer to join our growing Corporate Data & Operations team for a 6‑month term. This is an exciting opportunity to work on the Enterprise & Governance pod's new HR data foundation project, enabling innovative data‑driven solutions across the organization. Come join us in our Victoria office.

POSITION DESCRIPTION

Reporting to the Manager, Data & Analytics, the Data & Analytics Engineer conducts requirements gathering, creates analytical solutions and datasets, and performs data analysis on low and medium complexity projects independently, and high complexity projects with supervision and technical direction.

This role will participate in our Enterprise & Governance pod, which is launching an exciting new project in collaboration with HR to build out a comprehensive data foundation that can service HR domain use‑cases. You will work on cutting‑edge data solutions that leverage modern analytics tools and emerging AI technologies.

WHAT YOU BRING

• Bachelor's degree in Data Science, Technology, Engineering, Mathematics, or related field
• Minimum 3 years of experience (or 6 years for Senior role) in data engineering, BI development, or analytics engineering
• Advanced proficiency with Power BI, Excel, and modern data visualization tools
• Advanced proficiency with SQL
• Intermediate proficiency with data modeling and data architecture fundamentals
• Demonstrated proficiency in using LLM‑based tools (e.g., Claude) daily for diverse tasks such as requirements gathering, content translation, project summarization, quality assurance, code development, prototype generation, and problem‑solving

Experience with the HR data domain (an asset)

Experience with cloud-based data platforms like Databricks, Snowflake, or BigQuery (an asset)

Experience with Python (an asset)

Experience with data integration (an asset)

• Excellent listening, communication, collaboration and problem‑solving skills
• Strong understanding of Agile methodologies

WHAT YOU WILL DO

• Conduct requirements gathering and propose analytical solutions for business use‑cases, process improvement opportunities, and decision enhancement
• Create and maintain production‑grade analytical solutions such as reports, dashboards, automated emails, and interactive analytical applications using tools like Power BI, Excel, Claude, Replit, Power Automate, and PowerApps
• Create and maintain production‑grade datasets and ETL that can source AI models / applications and analytical solutions using tools like Databricks and languages like SQL and Python
• Conduct data analysis and identify business insights for action to support data‑driven decision making
• Lead the design and technical architecture of projects end‑to‑end for low to medium complexity solutions
• Design scalable data models suitable for multiple downstream usages (e.g., reports, dashboards, AI models, and LLM‑based querying)
• Mentor co‑ops and junior engineers and perform code reviews
• Collaborate with HR and internal stakeholders to understand business objectives and data needs
• Proactively identify opportunities to leverage data and analytics to business advantage

WHERE YOU WILL WORK

Work from our downtown Victoria office.

SALARY RANGE

The annualized base salary range for the Engineer role is CAD $90,000 to $109,000 and $103,000 to $124,000 for the Senior Engineer role.

Temporary employees receive a competitive benefits package including statutory holiday pay, 6% benefit pay, six paid sick days, ten vacation days, access to our integrated health platform, virtual counselling, mentorship and professional development programs, and corporate discounts. Benefits are prorated based on the length of term.

BCI offers a competitive total rewards package, including a performance‑based incentive plan, comprehensive health & dental benefits, a defined benefit pension plan, and paid time off. We pay our people competitively in the markets in which we operate and with consideration for internal equity and job structure. The base salary will consider factors such as the individual's skill set, experience, and internal equity. We aim for actual pay to be around the market median for expected performance and the upper quartile for excellent performance. Actual salaries may vary based on experience and expertise.

Next Steps :

To apply online, please submit your resume promptly. Applications will be actively reviewed, and those selected for an interview will be contacted. We welcome all qualified candidates who are legally authorized to work in the country where this job is located. If you do not have authorization, or if your work permit has restrictions or is due to expire within 12 months, please inform our recruitment team if shortlisted.

At BCI, we value diversity and foster an inclusive culture where all employees can thrive. We are performance and client‑focused, valuing integrity, and we want to know you if you share these values. We recognize that some skills can be learned on the job and encourage everyone to apply. If you require accommodations for the recruitment process, such as alternate formats of materials or accessible meeting rooms, please contact us at .

To learn more about working with BCI, including our comprehensive benefits packages, our commitment to equity, diversity and inclusion and the recruitment process visit our .

BCI does not accept unsolicited resumes or candidate submissions from third‑party recruitment agencies, executive search firms, or staffing suppliers unless they have an existing contractual agreement with our organization. Our approved vendor relationships are established for particular recruitment requirements and do not extend to general job postings on our website or other platforms. Any candidate information or resumes submitted by suppliers not approved by BCI will be deemed unsolicited and will not be reviewed or considered. BCI will not be liable for any fees, commissions, or charges related to unsolicited candidate submissions or recruitment services.