Data Operations & Solutions Analyst
Role Overview
Support enterprise data platforms, reporting solutions, and data integration while maintaining reliable, high-quality business-critical data services.
The role combines operational support, SQL development, reporting, and data analysis within the Enterprise Data Management team.
The description identifies Snowflake, Microsoft Fabric, SQL Server, Power BI, and Azure data technologies as modern platforms relevant to the role.
Key Skills for This Role
Full Job Posting
Role Overview
Support enterprise data platforms, reporting solutions, and data integration while maintaining reliable, high-quality business-critical data services.
The role combines operational support, SQL development, reporting, and data analysis within the Enterprise Data Management team.
The description identifies Snowflake, Microsoft Fabric, SQL Server, Power BI, and Azure data technologies as modern platforms relevant to the role.
Data Operations and Support
- Monitor scheduled data loads, ETL processes, and reporting activities.
- Investigate and resolve data, reporting, and application support issues; validate and reconcile data.
- Assist with incident response, escalate issues, document resolutions, and maintain operational procedures.
- Monitor overnight production ETL processes on weeknights by responding to database-related alerts and escalations; provide database support on weekends as required.
SQL and Data Development
- Develop and maintain SQL queries, views, stored procedures, and scripts.
- Support data integration and transformation processes, database troubleshooting, and performance analysis.
- Participate in testing and validation for data initiatives and help automate recurring operational and reporting tasks.
Reporting and Analytics
- Develop and maintain reports and dashboards using Power BI and other reporting platforms.
- Support business users with reporting requests and data inquiries and monitor data quality and report accuracy.
- Document business definitions and reporting standards and identify opportunities for reporting and process improvement.
Data Platform Support
- Assist with implementing enterprise data solutions and support Snowflake and Microsoft-based data platforms.
- Contribute to data modeling, integration, and migration initiatives and participate in data governance and quality activities.
- Work 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–5 years of 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 technologies and processes quickly, and strong communication and organizational skills.
Preferred Qualifications
- Experience with SQL Server or Snowflake is preferred.
- Experience with Power BI, SSRS, or similar reporting tools is preferred.
- Familiarity with ETL or data integration concepts is preferred.
Salary Range
- The description lists a salary range of $100,000 to $110,000; it does not state the pay cadence.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Canaccord Genuity Corp.
Investment Banking Associate - Mining
Toronto, CAN
Canaccord Genuity is seeking an Investment Banking Associate to support advisory and financing transactions in the mining sector. Candidates need a business-related university degree, at least two years of investment ban
Cyber Security Specialist
Toronto, CAN
The employer is seeking a Cyber Security Specialist to identify cybersecurity concerns and strengthen technical security controls. The role includes reviewing security systems, analyzing SIEM alerts, supporting incident
Internal Auditor (10-Month Contract)
Toronto, CAN
Canaccord Genuity is seeking an Internal Auditor for a 10-month contract to perform complex assurance and advisory audits and strengthen risk, control, and governance processes. The role requires internal audit standards
Senior Associate, Client Services (Licensed)
Vancouver, CAN
Stenner Wealth Partners+ seeks a licensed senior client-services professional to support high-net-worth clients and their investment accounts. The role covers account administration, transactions, tax reporting coordinat
Vice President, Compliance – Wealth Management
Toronto, CAN
Canaccord Genuity is seeking a Vice President to lead compliance oversight and advisory for its Wealth Management division in Canada. Candidates need at least 10 years of progressive financial-services compliance experie
Administrative Assistant
Vancouver, CAN
Canaccord Genuity is hiring an Administrative Assistant to support the Lead Investment Advisor and Stenner Wealth Partners+ with day-to-day coordination and client service. The role manages calendars, meetings, travel, d
Senior Wealth Advisor
Vancouver, CAN
Stenner Wealth Partners+ is seeking a Senior Wealth Advisor to serve ultra-high-net-worth client families, deliver tailored wealth advice, and contribute to business and asset growth. The role calls for a detail-oriented
Developer, Business Intelligence
Vancouver, CAN
Canaccord Genuity is seeking a BI Developer to build, maintain, and improve business intelligence applications, reports, and production environments. Candidates need at least four years of BI development and SQL experien
Investment Banking Associate - Mining
Toronto, CAN
Cyber Security Specialist
Toronto, CAN
Internal Auditor (10-Month Contract)
Toronto, CAN
Senior Associate, Client Services (Licensed)
Vancouver, CAN
Vice President, Compliance – Wealth Management
Toronto, CAN
Administrative Assistant
Vancouver, CAN
Senior Wealth Advisor
Vancouver, CAN
Developer, Business Intelligence
Vancouver, CAN