Senior Data Analyst

Job summary

Analyze large commercial insurance datasets to identify trends and optimize underwriting business rules. Partner with stakeholders to translate complex analytical findings into actionable business recommendations.

Job details

Senior Data Analyst About the Opportunity Our client, one of Canada's leading insurance providers, is seeking a Senior Data Analyst to join their Commercial Underwriting team. This position will support a strategic Advanced Commercial Underwriting (ACU) initiative focused on leveraging data to improve underwriting decisions, optimize business rules, and deliver actionable insights to key stakeholders. This is a highly visible, business-facing role where you'll partner directly with underwriting teams to analyze complex data, uncover trends, and provide recommendations that drive smarter business outcomes. The ideal candidate combines strong technical skills with the ability to communicate insights effectively to non-technical stakeholders. Key Responsibilities Analyze large underwriting and commercial insurance datasets to identify trends, risks, and opportunities. Develop and execute complex SQL queries to support reporting, analytics, and business decision-making. Work with data platforms including Azure Synapse and Databricks to access, transform, and analyze data. Evaluate underwriting business rules and assess their effectiveness through data-driven analysis. Partner closely with underwriting and business stakeholders to understand requirements and deliver analytical solutions. Translate complex analytical findings into clear, actionable recommendations. Support strategic initiatives through data storytelling, reporting, and insights generation. Operate independently while managing stakeholder relationships across multiple business groups. Required Qualifications 5+ years of experience as a Data Analyst, Senior Data Analyst, or similar analytics-focused role. Advanced SQL skills with the ability to write and optimize complex queries. Hands-on experience with Azure Synapse Analytics and Databricks. Experience within the Insurance industry, preferably supporting: Commercial Insurance Underwriting Risk Analysis Policy Analytics Strong stakeholder management skills and the ability to work independently. Excellent communication and collaboration skills. Experience translating business questions into data-driven solutions. Compensation: $40/hr to $55/hr Exact compensation may vary based on several factors, including skills, experience, and education. Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as short-term and long-term disability, life insurance and AD&D. Employees will also have access to a registered retirement savings account with employer matching. Employees in this role are also entitled to sick leave and/or other paid time off as provided by applicable law. We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position. Vacancy: This posting is for a currently vacant role, and the successful candidate will be hired into an existing open position.

What you’ll do

Analyze large commercial insurance datasets to identify trends and optimize underwriting business rules. Partner with stakeholders to translate complex analytical findings into actionable business recommendations.

Requirements

Requires over 5 years of experience as a Data Analyst with advanced SQL skills and hands-on experience in Azure Synapse and Databricks. Previous experience in the insurance industry, specifically in commercial underwriting or risk analysis, is preferred.

Benefits

• Medical Insurance • Dental Insurance • Vision Insurance • Short-term Disability • Long-term Disability • Life Insurance • AD&D • Registered Retirement Savings Account • Employer Matching • Sick Leave • Paid Time Off

Listed skills

• SQL · Preferred
• Data analysis · Preferred
• Communication · Preferred
• Reporting · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Azure Synapse Analytics
• Databricks
• Data Analysis
• Commercial Insurance Underwriting
• Risk Analysis
• Policy Analytics
• Stakeholder Management
• Data Storytelling
• Reporting
• Business Rule Evaluation
• Communication

Job areas

• Data & Analytics
• Finance & Accounting
• Consulting
• Technology