Business Analyst/ Data Developer

Salary Range

• $80/hour - $90/hour

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 building lasting client relationships - we achieve this by generating value for our individual, institutional, and corporate clients through comprehensive investment solutions, brokerage, and investment banking services. We are the 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, tailored 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 accommodations throughout the interview process and beyond, please let us know.

Position Overview

Our Canadian operation, Canaccord Genuity Corp., is seeking a hybrid Business Analyst / Data Developer for a 4-month contract to complete the implementation of our in-house VIA (Vendor Invoice Allocation) system and deliver executive-level reporting. VIA is a SQL-based platform used to manage vendor invoices, allocate expenses to departments and individuals, manage platform entitlements (e.g., Bloomberg, LSEG Workspace), and store contract metadata. The contractor's primary focus will be to complete the data integration from our existing Accounts Payable system (Concur) to the VIA database, ensure that all required financial and associated vendor contract data is correctly recorded and develop a reporting interface on VIA data model, focusing on vendor and financial management.

Responsibilities

VIA System Completion & Data Modeling

• Review existing VIA SQL schema, invoice allocation logic, entitlement structures, and Contracts module.
• Complete outstanding implementation components of VIA to support accurate financial reporting and analytics.
• Optimize SQL views, tables, and stored procedures to support reporting requirements.

Concur Integration (API / Batch Processing)

• Implement API or batch-based ingestion of expense data from Concur into VIA.
• Map Concur expense data to VIA entities (vendors, platforms, entitlements, departments, individuals).
• Automate data refreshes and ensure data integrity, reconciliation, and auditability.

Expense Dashboard Enablement

• Use the existing dashboard wireframe to define data requirements and measures.
• Build Power BI datasets and semantic models backed by VIA SQL data.
• Create DAX measures to support key metrics, including: expense trends by fiscal year, top vendor spend, contract-linked expenses.
• Ensure dashboards are performant, intuitive, and aligned with senior leadership expectations.

Business Analysis & Stakeholder Collaboration

• Work with business and finance stakeholders to validate reporting logic and business rules.
• Translate dashboard and reporting requirements into technical data structures.
• Document data models, integrations, and assumptions for long-term maintainability.

Skills & Qualifications

• 3-5+ years in a Business Analyst / Data Developer / BI Developer role.
• Advanced SQL skills (complex queries, transformations, performance tuning).
• Strong Power BI experience (data modeling, DAX, dataset design).
• Experience integrating third-party systems via API or scheduled batch processes.
• Experience