Data Operations & Solutions Analyst
Role Overview
Supports enterprise data platforms, reporting solutions, and data integration while helping ensure reliable, high-quality business-critical data services.
Works on the Enterprise Data Management team across operational support, SQL development, reporting, and data analysis.
The role offers experience with Snowflake, Microsoft Fabric, SQL Server, Power BI, and Azure data technologies.
Key Skills for This Role
Full Job Posting
Role overview
Supports enterprise data platforms, reporting solutions, and data integration while helping ensure reliable, high-quality business-critical data services.
Works on the Enterprise Data Management team across operational support, SQL development, reporting, and data analysis.
The role offers experience with Snowflake, Microsoft Fabric, SQL Server, Power BI, and Azure data technologies.
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, document resolutions, escalate issues, and maintain operating procedures.
- Monitor overnight weeknight ETL processes by responding to database alerts and escalations; provide weekend database support as required.
SQL, development, and reporting
- Develop and maintain SQL queries, views, stored procedures, and scripts; support integration, transformation, troubleshooting, and performance analysis.
- Participate in testing and validation and help automate recurring operational and reporting tasks.
- Develop and maintain reports and dashboards; respond to business-user reporting requests and data inquiries.
- Monitor data quality and report accuracy, document business definitions and reporting standards, and identify improvements.
Data platforms and architecture
- Assist with enterprise data solution implementation and support Snowflake and Microsoft-based data platforms.
- Contribute to data modeling, integration, migration, governance, and quality initiatives.
- Work with senior Data Engineers and Data Architects on project delivery.
Required qualifications
- Bachelor's degree, diploma, or equivalent experience in IT, Computer Science, Data Analytics, or a related field.
- 3–5 years of experience 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, problem-solving, communication, and organizational skills; able to learn technologies and processes quickly.
Preferred qualifications
- Experience with SQL Server or Snowflake and Power BI, SSRS, or similar reporting tools.
- Familiarity with ETL or data integration; exposure to Microsoft Fabric, Azure Data Factory, or cloud technologies.
- Business application or production support experience; financial services knowledge is an asset.
- PowerShell, Python, or automation tools experience is an asset.
Salary range
- The description lists a salary range of CAD 100,000 to CAD 110,000 without stating a 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 Group Inc.
Senior Wealth Advisor
Vancouver, CAN
Stenner Wealth Partners+ seeks a Senior Wealth Advisor to serve ultra-high-net-worth families, grow client relationships and assets, and deliver investment and wealth-planning advice. Candidates need 7–10 years of releva
Equity Research Associate - Metals & Mining
Toronto, CAN
Canaccord Genuity is seeking an Equity Research Associate to support its Metals & Mining research team. The role focuses on financial modeling, company and industry research, investment theses, reporting, and institution