Data Operations & Solutions Analyst

Job summary

The Data Operations & Solutions Analyst will support enterprise data platforms, reporting solutions, and data integration processes to ensure data reliability. Responsibilities include monitoring ETL processes, developing SQL queries, creating Power BI dashboards, and troubleshooting production data issues.

Job details

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 Support 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. #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 Data Operations & Solutions Analyst will support enterprise data platforms, reporting solutions, and data integration processes to ensure data reliability. Responsibilities include monitoring ETL processes, developing SQL queries, creating Power BI dashboards, and troubleshooting production data issues.

Requirements

Candidates must have a bachelor's degree or equivalent in a relevant field and 3 to 5 years of experience in data, reporting, or SQL. Strong analytical skills and familiarity with relational databases and modern data platforms are required.

Listed skills

• SQL · Preferred
• Reporting · Preferred
• Data analysis · Preferred
• Power BI · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Data Operations
• Reporting
• Data Analysis
• Snowflake
• Microsoft Fabric
• Power BI
• ETL
• Data Integration
• Database Troubleshooting
• Data Modeling
• Azure Data Technologies
• Performance Analysis
• Automation
• Data Governance
• Data Reporting
• Solutions Support
• Azure Data Factory
• DataOps
• Organizational Skills
• Reporting Solutions
• Snowflake (Data Warehouse)
• Project Delivery
• Technical Support
• Microsoft Azure
• Reconciliation
• Business Intelligence
• Dashboard
• Capital Markets
• Communication
• Computer Science
• Computer Graphics
• Information Technology
• Data Validation
• Data Engineering
• Extract Transform Load (ETL)
• Data Management
• Data Quality
• Relational Databases
• Incident Response
• Securities Research
• Sales
• Financial Services
• Scalability
• Innovation
• Investment Banking
• Problem Solving
• Python (Programming Language)
• Operational Databases
• Operations

Job areas

• Data & Analytics
• Technology
• Finance & Accounting
• Software
• Data Operations Analyst
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists

More jobs from Canaccord Genuity Group Inc.