Data Specialist - Claim Operations Management - Fall 2026 Co-op/Intern

Data Specialist - Claim Operations Management - Fall 2026 Co-op/Intern Waterloo, ONT, Canada 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.

YOUR NEXT CO-OP PLACEMENT

Work term: Fall 2026

Work term length: 4-month

From classroom to co-op to career, every step of your journey has an impact on your future. That’s why it makes sense to choose a co-op placement with a company that offers truly rewarding work and real-life experience. At Definity®, your contributions, creativity, and energy will be put to good use, and you’ll get to be involved with initiatives that support our strategic goals and use your skills in a supportive team environment.

If you’re looking for a company that takes care of its people — full time, part time, and co-ops alike — and has a track record of doing big things, get ready to love it here.

What can you expect in this role?

We are seeking a motivated and detail-oriented Co-op Student to join our Claims team for a critical project. The legacy Claims Data System (CDS) is being decommissioned in February 2027, and we must ensure our business users retain access to historical claims data for investigations and reporting.

This role will be instrumental in a special project focused on consolidating complex claims data and developing a user-friendly interface to make this data accessible. The successful candidate will work closely with our data and business teams to transform raw data into a valuable business asset.

Your Responsibilities

• Collaborate with data engineers and business SMEs to understand data requirements.
• Design, develop, and implement a 'semantic' data layer, consolidating approximately 150 tables from the legacy CDS system into a collection of business-ready data products within our Google Cloud Platform (GCP) environment.
• Develop a user interface (UI) in Excel, leveraging the newly created data products to allow business users to easily look up and analyze historical claims information.
• Create and maintain comprehensive documentation for the data aggregation processes and the final UI tool.
• Participate in knowledge transfer sessions to hand off the completed solution and documentation to the business and IT support teams.
• Assist in user acceptance testing (UAT) to ensure the solution is accurate, reliable, and meets business needs.
  

What do you bring to the role?

• Currently enrolled in a post-secondary program in Computer Science, Data Science, Engineering, Business Technology Management, or a related field.
• Strong proficiency with Microsoft Excel, including advanced functions, Power Query, and creating user-friendly interfaces.
• Experience with data manipulation and analysis. Familiarity with SQL or Python for data transformation is a significant asset.
• A foundational understanding of cloud platforms (e.g., Google Cloud Platform) is preferred.
• Excellent problem-solving skills and the ability to work with complex, multi-source datasets.
• Strong communication and documentation skills, with the ability to work both independently and as part of a team.
• A keen interest in data, analytics, and building practical solutions to business problems.
  

Did you know?

• We care about our co-ops: Definity’s co-op students are considered the best pipeline of talent for our full-time, permanent positions.
• We care about students: Definity distributes $85,000 in scholarships to students across Canada each year.
• We care about our community: Definity donates more than $1 million every year to causes that drive true change in the neighbourhoods in which we live and work.

What can Definity offer you?

• Meaningful work forwarding our purpose of building a better world by helping our clients and communities adapt and thrive in their hardest times of need.
• Culture of accountability, empowerment, and collaboration.
• Opportunities to support personal and professional growth through real-life experience and unique learning opportunities. Our Leadership Essentials program builds knowledge and skills to Team Leaders to Directors
• Opportunity to join our employee groups - focused on women's empowerment, LGBTQ+, anti-racism and cultural equity, and environmental activism
• Determined to create positive change for our environment, our people, and our communities, now and in the future. Check our !

This position is being posted to fill an existing vacancy.

The hourly compensation for the role starts at $22.50 per hour and will increase based on factors including but not limited to, skills, education, experience, and the recommended rates as set by the respective educational institution.

We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.

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 accessibility@economical.com.

Background checks

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