Developer, Business Intelligence

Job summary

The BI Developer will be responsible for the analysis, design, development, and maintenance of BI applications using Microsoft tools. This role involves troubleshooting reports, managing database objects, and providing business intelligence to support organizational planning and measurement.

Job details

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. Our success is built on deep sector expertise, strong relationships, and a commitment to delivering value across our business - for clients, colleagues, partners, and stakeholders. 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 the people and markets we serve, and bringing thoughtful and innovative, solutions to our work. Our entrepreneurial and collaborative culture will challenge you to learn and grow every day. We value great work and are looking for talented people who thrive in a fast-paced environment and want to make an impact through innovative ideas, sound judgement and industry leading best practices. Come be a part of our Canadian success story and help contribute to the work that drives our business forward. 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 to join our team. Reporting to the Senior Manager, Business Intelligence Team, this role will be responsible for the analysis, design, development and support 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. 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; 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; Canaccord Genuity Corp. welcomes and encourages applications from all qualified individuals including persons with disabilities. We will provide reasonable accommodations upon request for candidates taking part in all aspects of the recruitment and selection cycle. Qualified applicants are invited to submit a resume and covering letter including salary expectations. All applications will be held in strict confidence. To apply, please Click Here. We recommend that all internal applicants advise their direct manager/supervisor about their interest in other job opportunities prior to sending in their job application. In order to be considered for employment at Canaccord Genuity, 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. #LI-SK1 #LI-Onsite #INDHP 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. Protecting your online safety: Canaccord Genuity and its affiliates do not use text messages for recruitment purposes. If you have received a text message claiming to be from CG or an authorized representative regarding job recruitment, please treat as fraudulent and do not respond. 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.

What you’ll do

The BI Developer will be responsible for the analysis, design, development, and maintenance of BI applications using Microsoft tools. This role involves troubleshooting reports, managing database objects, and providing business intelligence to support organizational planning and measurement.

Requirements

Candidates must have at least 4 years of experience with the Microsoft BI platform, including SQL Server, PowerBI, and SSRS. Strong proficiency in data manipulation, star schemas, and DAX is required, along with excellent business analysis and communication skills.

Listed skills

• Microsoft Azure · Preferred
• Documentation · Preferred
• Process Mapping · Preferred
• Communication Skills · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL Server
• PowerBI
• SSRS
• DAX
• Data manipulation
• Star schemas
• Business systems analysis
• Azure
• Lakehouse
• Data Factory
• Process mapping
• Business process redesign
• Documentation
• Analytical skills
• Communication skills
• Business Systems Analysis
• Action Oriented
• Azure Data Factory
• Process Mapping
• Data Analysis Expressions (DAX)
• Planning
• Business Logic
• Microsoft Azure
• Business Intelligence
• Business Intelligence Development
• Business Analysis
• Business Process Reengineering
• Management
• Investments
• Capital Markets
• Computer Graphics
• Finance
• Securities Research
• Sales
• Financial Services
• Innovation
• Investment Banking
• Microsoft Business Intelligence
• Operations
• Wealth Management
• Power BI
• Stored Procedure
• SQL (Programming Language)
• SQL Server Reporting Services
• Troubleshooting (Problem Solving)
• Verbal Communication Skills
• Securities (Finance)
• Star Schema
• Detail Oriented

Job areas

• Data & Analytics
• Technology
• Finance & Accounting
• Software
• Business Intelligence Developer
• Business Intelligence Developer / Architect
• Software Developers

More jobs from Canaccord Genuity Group Inc.