Specialist, Reporting

Definity Financial Corporation; Southwestern Ontario; Hybrid; CAD 74,000 - 124,000; Full time

Benefits offered by this job

Company share ownership

Pension and RRSP matching

Volunteer days

Tuition assistance

Inclusion programs

Wellness programs

Product/service discounts

Job summary

Definity Financial Corporation's Claims Analytics team is looking for a data-savvy analyst to turn data into actionable insights. You will build dashboards using Tableau, perform SQL-driven data manipulation, and collaborate with stakeholders to translate business needs into reporting solutions.

You will leverage BigQuery and Google Cloud Platform, contribute to an analytics culture, and support training and documentation for dashboards.

Qualifications

• University or college degree in data analytics, big data analytics, business analysis or similar field; masters or equivalent preferred.
• Experience using SQL for data manipulation, aggregation and insights.
• 2-5 years of experience using Tableau to create dashboards and derive insights.
• Experience with BigQuery and Google Cloud Platform is a strong asset.
• Experience in the P&C Insurance industry is a strong asset.
• Experience with agile analytics development; JIRA & Confluence an asset.
• Excellent communication and organizational skills; able to work independently.

Responsibilities

• Transform reports into dashboards to deliver actionable insights and improve the analytics environment.
• Gather requirements from stakeholders and steer meetings with data management and business teams.
• Design analytical wireframes and develop dashboards; recommend visual analytical solutions.
• Conduct preliminary analyses and address data inconsistencies to support reporting integrity.
• Organize data for use by other analysts and business users within Claims.
• Support the business by developing training materials and documentation on dashboards.

Skills

Tableau

SQL

BigQuery

Google Cloud Platform

Agile

JIRA

Confluence

P&C Insurance

Education

University/college degree in data analytics or related field

Tools

Tableau

SQL

Job description

Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. Our ambition is to be one of Canada’s leading and most innovative property and casualty insurers. We can’t do that without our people, so we embrace and encourage a culture that’s collaborative, ambitious, rewarding, and empowering.

We offer a flexible, hybrid work experience where employees work from the office and virtually depending on the type of work they are doing and who they are working with. Bring your true self and be a part of our journey. It’s better here.

TheOpportunity

The successful candidate will be responsible for turning data into meaningful insights and reporting. The key will be understanding the claims data and report the trends using visualization tools. This opportunity will place you at the forefront of leveraging data visualization tools and strategize the transformation of data into insights within Definity Claims Team.

WhattoExpect

• Discover opportunities to transform reports into dashboards to deliver more actionable insights and continuously improve the claims analytics environment
• Gather reporting or dashboarding requirements from stakeholders; steer meetings with data management team to understand data and facilitate meetings with business stakeholders to accurately assess the analytical need for building reports/dashboards
• Be passionate and creative in designing analytical wireframes and developing dashboards
• Recommend effective visual analytical solutions which drive an analytical mindset within the organization
• Conduct preliminary analyses on data involving basic statistical approaches and provides solutions to treat various data inconsistencies to support reporting integrity
• Organize data for use by other analyst roles and business users within Claims
• Support the business by developing and providing training and documentation on dashboards

What youBring

• University or college degree in data analytics, big data analytics, business analysis or similar field, preferably masters or equivalent experience
• 2-5 years of experience of using Tableau to create dashboards and develop value-creating business insights from operational performance indicators and scorecards
• Experience using SQL for data manipulation, aggregation and generation of meaningful insights
• Experience with BigQuery and Google Cloud Platform for analytics is a strong asset
• Experience in the P&C Insurance industry is a strong asset
• Experience with agile methodology for analytics development; experience with JIRA & Confluence an asset
• Excellent communication and organizational skills; comfortable with ambiguity and ability to work independently with minimal supervision

Salary Range: $73,500 - $123,500

High degree ofproficiencywith Englishrequiredto service customers, both internal to the company and external, across Canada.

Actual salary for the role may vary depending on work location of the successful candidate and other factors including but not limited to, skills, education, experience, working conditions and the local labour market.

This position is being posted to fill an existing vacancy.

Interested in this role, but don’t meet every requirement?

We know from experience that a candidate doesn’t need 100% of the qualifications listed to bring incredible value to our team. We’re actively seeking diverse backgrounds and perspectives to help us make insurance better. At Definity, inclusion, diversity, and equity aren’t just “nice to have” — they’re essential to our success.

What’s in it for you?

• Company share ownership program
• Incentive Program - Eligible employees may participate in various incentive plans which are paid out at the discretion of the company and subject to individual and company performance.
• Pension and savings programs, with company-matched RRSP contributions
• Paid volunteer days and company matching on charitable donations
• Educational resources, tuition assistance, and paid time off to study for exams
• Focus on inclusion with employee groups, support for gender affirmation surgery, access to BIPOC counsellors, access to programs for working parents
• Wellness and recognition programs
• Discounts on products and services

Go ahead and expect a lot — you deserve it.

It’s better here — but don’t take our word for it. Definity was named by Great Place to Work as one of the Best Workplaces in Canada for women, for youth, and for inclusion.

Our inclusive work environment welcomes diversity and supports accessibility. If you require accommodation at any time during the recruitment process, please let us know by contacting [e-mail].

As part of Definity’s commitment to reconciliation, we acknowledge that our work, meetings, and travel take place on the lands now known as Canada, and recognize the enduring presence, wisdom, and stewardship of the First Nations, Métis, and Inuit peoples who have long cared for these lands.

Background checks

This role requires successful clearance of background checks (including criminal checks and leadership references).

#LI-Hybrid

• Job Identification 9291
• Job Category Data, Analytics and Business Intelligence