Salary Range:$100,000 to $110,000Our 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 ResponsibilitiesData 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
