Senior Analyst

Description:

The Finance team at BCI is seeking a highly analytical and technically skilled Analyst or Senior Analyst, Performance Analytics, to join our Victoria, BC office. This role is pivotal in managing and transforming performance measurement data to support accurate calculations, analytics, and reporting across Total Fund, Asset Class, and Client Performance teams. The successful candidate will develop and maintain analytical tools using SQL, Python, and data visualization platforms, lead daily production support for performance solutions, and collaborate closely with stakeholders to enhance performance reporting capabilities and data integrity.

WHO YOU WILL WORK WITH

The Finance department is part of BCI Operations and is responsible for investment and corporate accounting, valuations, as well as financial statements and financial reporting to our clients. The team also leads BCI’s budgeting process, tax structuring and tax compliance, finance client engagement, finance operations, procurement, and investment performance and analytics. Working with our internal business partners, auditors and external advisors, the Finance department strives to be a trusted advisor to our internal and external clients by providing timely, accurate, and relevant financial information and analysis.

Performance & Analytics serves as an authoritative source of performance information, playing a crucial role in supporting BCI's investment strategy. By adopting a customer-centric structure, the branch aligns its teams with the end customers they support, including Total Fund Performance, Asset Class Performance, Client Performance, and Performance Analytics & Support. This alignment ensures that all stakeholders receive focused, one-stop service of independent measurement of portfolio and benchmark performance, in-depth performance attribution, insightful performance analysis, and comprehensive reporting. Additionally, the branch contributes to compensation evaluation, further reinforcing BCI's commitment to delivering exceptional value to its clients and meeting clients’ expectations.

THE OPPORTUNITY

Reporting to the Manager, Performance Analytics & Support, the Analyst/Senior Analyst supports the Performance & Analytics branch by assisting with data management, analytics, and technical solutions. This position combines technical skills with performance measurement knowledge to help source, transform, and maintain data for all Performance teams, while contributing to innovative analytical solutions that enhance our capabilities. The Analyst/Senior Analyst provides production support, builds analytical tools using modern technologies, and collaborates closely with Total Fund, Asset Class, and Client Performance teams to enable accurate performance calculations, attribution analysis, and timely client reporting, while also supporting their technical needs.

WHAT YOU BRING

Must have

• 1-3 years institutional investment experience, preferably in performance measurement, data analytics, or capital markets
• Strong SQL skills and experience working with relational databases
• Demonstrated Python skills for data analysis and visualization
• Experience with data visualization tools such as Power BI
• A relevant university degree (finance, accounting, mathematics, computer science, statistics, or related field)
• An understanding of asset class behaviour, capital markets, and complex institutional investment portfolios (i.e. knowledge of derivatives/overlay, absolute return strategies, alternative investments, private markets) and industry standard performance measurement and benchmarking practices
• Experience with data transformation and manipulation
• Strong attention to detail and ability to problem solve
• Good verbal and written communication skills with ability to work effectively with both technical and business teams
• Demonstrated ability to drive results and consistently achieve objectives, even under challenging circumstances
• Proven situational adaptability to adjust approach and work style to match shifting demands

Strongly preferred

• CIPM, CFA, or CAIA designation in progress or complete
• Experience supporting performance analytics systems or reporting processes

WHAT YOU WILL DO

• Manages sourcing, transforming, and maintenance of performance measurement data to support all Performance teams in executing calculations, attribution analysis, and client reporting
• Supports other Performance teams (Total Fund, Asset Class, and Client Performance) by assisting with performance calculations, interpreting attribution results, gathering data for client requests, and providing analytical solutions to help investigate return anomalies and ensure accurate performance reporting
• Develops analytical tools and solutions using SQL, Python, and data visualization platforms to enhance performance reporting capabilities Leads daily production support for performance systems, troubleshooting issues and implementing solutions Collaborates with Performance teams to understand their technical needs and helps implement solutions that improve their ability to produce accurate and timely performance analysis
• Documents technical processes, data flows, and procedures to support knowledge sharing across the Performance branch
• Supports the preparation of interactive dashboards and analytical tools that enable other teams to respond effectively to client requests
• Assists with testing and validation during system upgrades and process improvements
• Monitors data quality and reports anomalies to ensure integrity of performance calculations and attribution analysis
• Participates in cross-functional projects to enhance performance measurement capabilities
• Provides technical support to Performance team members, helping them utilize data tools and systems effectively