Data Operations & Solutions Analyst

CGC Canaccord Genuity Corp.; Vancouver; On-site; CAD 100,000 - 110,000; Full time

Job summary

CGC Canaccord Genuity Corp. is seeking a Data Operations & Solutions Analyst in Vancouver to support enterprise data platforms, reporting, and data integration. You will troubleshoot data issues, monitor pipelines, and contribute to scalable data solutions, including Snowflake, Power BI, and Azure data technologies.

The role offers exposure to modern data platforms, collaboration with senior data engineers, and opportunities to grow in a fast-paced financial services environment in Canada.

Qualifications

• Bachelor's degree or diploma in IT/CS/Analytics or related field.
• 3–5 years of experience in data, reporting, SQL, BI, or application support.
• Strong SQL and relational database knowledge.
• Interest in data engineering or enterprise data platforms.
• Strong analytical and communication skills.

Responsibilities

• Monitor data loads, ETL processes, and reporting activities.
• Investigate data, reporting, and application issues and resolve them.
• Develop and maintain SQL queries, views, and procedures.
• Create and update Power BI reports and dashboards.
• Support data platforms like Snowflake and Microsoft-based tools.

Skills

Data analysis

SQL

Problem solving

Communication

Organizational skills

Continuous learning

Education

Bachelor's degree or diploma in IT/CS/Data Analytics

Tools

SQL

Power BI

Snowflake

Azure Data Factory

Python

SSRS

Job description

Salary Range:

$100,000 to $110,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 Data Operations & Solutions Analyst who will be responsible for supporting enterprise data platforms, reporting solutions, and data integration processes while ensuring the reliability and quality of business-critical data services. Working as part of the Enterprise Data Management team, this role combines operational support, SQL development, reporting, and data analysis responsibilities. The successful candidate will assist with troubleshooting data issues, monitoring data pipelines, supporting reporting environments, and contributing to the development of scalable data solutions. This role provides an excellent opportunity to develop expertise in modern data platforms including Snowflake, Microsoft Fabric, SQL Server, Power BI, and Azure data technologies.

Key Responsibilities

Data Operations & Support

• Monitor scheduled data loads, ETL processes, and reporting activities.
• Investigate and resolve data, reporting, and application support issues.
• Perform data validation and reconciliation activities.
• Assist with incident response and problem resolution.
• Escalate issues appropriately and document resolutions.
• Maintain support and operational procedures.
• Monitor overnight production data processes (ETL) on weeknights by responding to database-related alerts and escalations
• Provide database-related support on weekends as required

SQL & Data Development

• Develop and maintain SQL queries, views, stored procedures, and scripts.
• Support data integration and transformation processes.
• Assist with database troubleshooting and performance analysis.
• Participate in testing and validation activities for data initiatives.
• Help automate recurring operational and reporting tasks.

Reporting & Analytics

• Develop and maintain reports and dashboards using Power BI and other reporting platforms.
• Support business users with reporting requests and data inquiries.
• Monitor data quality and report accuracy.
• Assist in documenting business definitions and reporting standards.
• Identify opportunities for reporting and process improvements.

Data Platform & Architecture

• Assist with implementation of enterprise data solutions
• Support Snowflake and Microsoft-based data platforms.
• Contribute to data modeling, integration, and migration initiatives.
• Participate in data governance and quality activities.
• Work closely with senior Data Engineers and Data Architects on project delivery.

Required Qualifications

• Bachelor's degree, diploma, or equivalent experience in Information Technology, Computer Science, Data Analytics, or a related field.
• 3 to 5 years experience working with data, reporting, SQL, business intelligence, or application support.
• Working knowledge of SQL and relational databases.
• Interest in data engineering, analytics, or enterprise data platforms.
• Strong analytical and problem-solving skills.
• Ability to learn new technologies and processes quickly.
• Strong communication and organizational skills.

Preferred Qualifications

• Experience with SQL Server or Snowflake.
• Experience with Power BI, SSRS, or similar reporting tools.
• Familiarity with ETL or data integration concepts.
• Exposure to Microsoft Fabric, Azure Data Factory, or cloud technologies.
• Experience supporting business applications or production environments.
• Knowledge of financial services is an asset.
• Experience with PowerShell, Python, or automation tools is an asset.

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.

Through its principal subsidiaries, Canaccord Genuity Group Inc. (“Company”) is a leading independent, full‑services financial firm, with operations in two principal segments of the securities industry: wealth management and capital markets Since its establishment in 1950, the Company has been 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 services and investment banking services. The Company has Wealth Management offices located in Canada, the UK, Guernsey, Jersey, the Isle of Man and Australia. Canaccord Genuity, the international capital markets division, operates in North America, UK & Europe, Asia, Australia and the Middle East.