Data Operations & Solutions Analyst in Vancouver

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 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

• 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.