Data Analyst, Commercial Insurance, Strategy and Insights

Job description

Aviva Canada Inc. has an excellent opportunity in our Small Medium and Enterprise (SME) commercial insurance business unit. Our Strategy and Insights team in SME focuses on designing and creating various databases and reporting tools that are critical in managing financial, operational, and underwriting performance in Commercial Insurance. As a Data Analyst in this team, you will be equipped with strong Business Intelligence and IT, and business acumen. Your key responsibility as a Data Analyst is to liaise effectively between the business users and other IT groups to deliver the best reporting solution in order for the business to make the right decisions.

 You will have a very good understanding of database design as well as programming experience in SAS. You will demonstrate familiarity with general database structures; including design, data management, and analysis; and thrive in a fast paced, deadline driven environment.

You will proactively be involved in understanding business needs, organize and construct abstract requirements and provide valuable, actionable business solution.  You will have a high level of technical skills and system knowledge to assimilate disparate information from various systems / applications into a cohesive MI report / dashboard. 

Accountabilities:

• Build, support and enhance Business Intelligence reports, dashboards and interactive tools to meet Commercial Insurance business needs and requirements leveraging common definitions, consistent toolsets and development methodology
• Sustain monthly and weekly report SLA; build reports and provide ad-hoc data and reports to the business, respond to report intakes and provide end user training on MI report
• Contribute to development of Qlik Sense Dashboard
• Log, resolve and investigate data deficiencies and defects in the data warehouse.
• Work with various business teams to clearly understand reported issues and requirements in order to deliver what they ‘need’ in a timely fashion.
• Recommend and implement actions to improve operational and reporting efficiencies.
• Maintain high level of MI reporting quality.

Required Qualifications, Knowledge, and Skills:

• Bachelor’s degree (Computer Science, Mathematics or Business Admin.)
• Experience in Business Intelligence Analytics or Reporting
• Experience with SAS Enterprise Guide
• Experience working with Qlik Sense (or other data visualization tools)
• Experience working experience with database, data modeling, database concepts, design and structures.
• Experience with Business Objects tool suite
• Strong capability in Microsoft Excel
• Strong business knowledge and technical skills to deliver optimal, appropriate and accurate information to the business using a variety of reporting tools.
• Self-starter and proactive attitude with capability to effectively execute end-to-end deliverables.
• Ability to manage multiple tasks and meet required deadlines
• Aptitude to acquire new technical skill sets to keep pace with evolving data landscape.
• Strong analytical skills and detail oriented.
• Strong written and verbal communication skills with experience communicating at all levels.
• Previous experience working in Commercial Insurance is an asset

Additional Information:

Aviva Canada is committed to providing accommodations for people with disabilities during all phases of the hiring process including the application process. If you require an accommodation because of a disability, we will work with you to meet your needs. Applicants need to make their needs known in advance. If you are selected for an interview and require an accommodation, you are encouraged to advise the Talent Acquisition Partner who will consult with you to determine an appropriate accommodation.