Business Intelligence (BI) Developer

Canaccord Genuity Group Inc.; Vancouver; On-site; CAD 90,000 - 100,000; Full time

Job summary

Join a leading independent financial services firm as a Business Intelligence Developer. In this dynamic role, you will leverage your expertise in Microsoft BI tools to enhance business intelligence applications and support data-driven decision-making. Collaborate with a talented team to deliver innovative solutions that meet client needs while maintaining high-quality standards. This is an exciting opportunity to grow your career in a fast-paced environment that values diversity, collaboration, and professional development. If you are passionate about data and eager to make an impact, this position is for you.

Qualifications

• 4+ years of experience with Microsoft BI tools and SQL/data manipulation.
• Strong understanding of DAX and business analysis skills.

Responsibilities

• Maintain and support BI production environments and troubleshoot issues.
• Analyze, design, and deliver reports in SSRS and PowerBI.

Skills

Microsoft BI Platform

SQL Server

PowerBI

SSRS

DAX

SQL/data manipulation

Business Systems Analysis

Azure environments

Documentation skills

Business analysis

Job description

Business Intelligence (BI) Developer

Apply locations: Vancouver, BC

Time type: Full time

Posted on: Posted 5 Days Ago

Job requisition id: JR100322

Salary Range: $90,000 - $100,000

Who we are:

Canaccord Genuity (CG) is a leading independent full-service financial services firm, with operations in two principal segments of the securities industry: wealth management and capital markets. CG is driven by an unwavering commitment to build lasting client relationships – we achieve this by generating value for our individual, institutional, and corporate clients through comprehensive wealth management solutions and investment banking services. We are a leading independent wealth management firm in Canada, and the leading mid-market provider of investment banking advisory, equity research, sales and trading services for corporations and institutions.

We pride ourselves on understanding our clients’ needs and finding innovative, bespoke solutions. Our entrepreneurial and friendly team will challenge you to learn and grow every day. We value great work and collaboration and strive to eliminate bureaucratic thinking. We’re looking for talented people who thrive in a fast-paced environment and want to have an impact with innovative ideas and best practices.

Come be a part of our Canadian success story and help deliver superior experiences for our clients. At CG, we recognize that diversity across our business strengthens our client relationships and enables more innovative solutions. We strongly encourage applications from all qualified individuals regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status. CG provides an accessible candidate experience. If you need any accommodation throughout the interview process and beyond, please let us know.

Our Canadian operation, Canaccord Genuity Corp., is currently looking for a BI Developer/Support Analyst to join our team. Reporting to the Manager, Business Intelligence Team, this role will be responsible for the analysis, design, development and deployment of BI applications using Microsoft Business Intelligence tools. This role will provide highly valued client and business intelligence that drives the planning, management and measurement of our business. The ideal candidate will have the ability to communicate effectively in technical and non-technical environments. Additionally, they will display excellent collaboration and organizational skills, including the ability to maintain exceptional client support and prioritize tasks.

Responsibilities:

• Provide maintenance and support for BI production environments;
• Willing to work outside of normal business hours if required to support BI processes;
• Answer enquiries regarding business logic in SSRS reports, stored procedures, PowerBI models;
• Troubleshoot issues in reports, stored procedures, PowerBI models;
• Be able to create/modify SQL Server jobs and other database objects (views, stored procedures, triggers, etc.);
• Analyze, define, design, build and deliver dynamic and static reports in both SSRS and PowerBI;
• Continually examine how BI business applications are being utilized and recommend and implement improvements;
• Create documentation and business metadata;
• Create and communicate business reporting standards;
• Ensure only high-quality information is presented to the business community;

Skills & Qualifications:

• 4+ years of experience with knowledge of the Microsoft BI Platform (SQL Server, PowerBI, SSRS);
• 4+ years of experience with SQL/data manipulation, star schemas;
• Excellent understanding of DAX;
• 4+ years of experience in a BI Development environment, with Business Systems Analysis experience preferred;
• Experience in Azure environments (Lakehouse and Data Factory) would be a strong asset;
• Knowledge of implementing BI solutions with a specific focus on the Finance and Investments industries would be an asset;
• Strong documentation skills;
• Solid understanding of BI terminology and concepts;
• Strong business analysis, process mapping, business process redesign and implementation skills;
• Highly organized and detail oriented;
• Action oriented with excellent facilitation skills;
• Excellent written and verbal communication skills;
• Analytical with the ability to grasp abstract concepts;

All applications will be held in strict confidence.

In order to be considered for employment, candidates selected for interviews will be required to show proof of citizenship, permanent residence or eligibility to work in Canada with no restrictions.

We wish to thank all candidates for their interest but only those applicants selected for an interview will be contacted. No phone calls please. Thank you for your understanding.