Senior Business Analyst

Talencore; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A major player in the insurance and investment management sector is seeking a Senior Business Analyst to join their Data Integration & Performance Platform team. This role involves leading business analysis for critical data systems and enhancing performance platforms. The ideal candidate will have extensive experience in data warehouse platforms and a strong understanding of investment performance measurement.

Benefits

Professional growth in a global enterprise

Collaborative team environment

Competitive compensation and benefits

Employee wellness prioritization

Qualifications

• 5+ years business analysis experience supporting data warehouse platforms.
• Expert knowledge of business analysis methodologies and requirements gathering techniques.
• Hands-on experience with SQL and relational databases.

Responsibilities

• Lead business analysis for Agile and Waterfall projects focused on data enhancements.
• Document and communicate project scope, objectives, and timelines.
• Design complex investment reporting solutions using SQL, SSRS, OLAP, and Power BI.

Skills

Business Analysis

SQL

Data Analysis

Change Management

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Engineering

Bachelor's Degree in Mathematics

Bachelor's Degree in Finance

Tools

ETL/ELT tools

Power BI

Azure

Snowflake

Job description

Our client, a major player in the insurance and investment management industry with a global presence and offices across multiple continents, is seeking an experienced Senior Business Analyst to join their Data Integration & Performance Platform team. This role supports critical data systems that power investment decision-making across the organization.

What You'll Do:

• Lead business analysis for both Agile and Waterfall projects focused on data and performance platform enhancements
  
• Document and communicate project scope, objectives, and timelines
  
• Gather and analyze requirements from investment teams and finance stakeholders
  
• Design complex investment reporting solutions using SQL, SSRS, OLAP, and Power BI
  
• Define and execute comprehensive test plans
  
• Implement change management principles throughout project delivery
  
• Partner with technology teams on system enhancements and upgrades
  
• Serve as subject matter expert for data warehouse and performance measurement platforms
  
• Develop support documentation and maintain data dictionaries
  
• Monitor and resolve production data issues to ensure platform stability
  
  
  

Requirements

What You Bring:

• 5+ years business analysis experience supporting data warehouse platforms
  
• Expert knowledge of business analysis methodologies and requirements gathering techniques
  
• Hands-on experience with SQL and relational databases, ETL/ELT tools and design patterns
  
• Strong understanding of investment performance measurement and attribution methodologies
  
• Experience with the investment lifecycle and data domains for various financial instruments
  
• Demonstrated ability to manage multiple complex data projects simultaneously
  
• Background working with investment applications such as Eagle, SimCorp, FactSet, Bloomberg or Aladdin
  
• Bachelor's Degree in Computer Science, Engineering, Mathematics, Finance or related field
  
  

Bonus Points:

• Azure cloud platform and/or Snowflake experience
  
• CFA and/or CBAP certifications
  
• Experience with generative AI tools and prompt engineering
  
  
  
  

Benefits

What Our Client Offers:

• Opportunity to contribute to a significant digital transformation initiative
  
• Professional growth in a global, sophisticated enterprise
  
• Collaborative team environment focused on excellence
  
• Competitive compensation and benefits
  
• Workplace that prioritizes employee wellness and community engagement
  
  

------------------------

At Talencore, we stand against racism and discriminatory practices. We stand against violence.

We proudly support and partner with organizations that lift people up so everyone can succeed and thrive, and honour our candidates' experiences, perspectives and unique identity.

We are committed to continuing to make diversity, equity, and inclusion part of everything we do – from how we work with our talented candidates to how we support our clients in building their diverse workforce.