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

Definity Insurance Company • Waterloo, ON

7d • Hybrid

About The Position

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.

Requirements

• 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.
• 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.

Nice To Haves

• 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.

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.

Benefits

• 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.
• 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.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed