Data Specialist

2 weeks ago


Waterloo, Canada Ontario Teachers Insurance Plan (OTIP) Full time

Company Description

OTIP (Ontario Teachers Insurance Plan) is a member-focused, service-driven organization. We are committed to putting our people first by fostering a positive and inclusive work environment, providing a competitive total compensation package and investing in career development. Our team is currently looking for a:
**Data Specialist**

**Job Description**:

- Act as a key liaison for OTIP with respect to electronic file exchanges and the file requirements. Attend meetings to share information as needed with internal stakeholders, and external clients. Gather, analyze, and document client data to facilitate the successful load of data to the systems and transmission of files between OTIP and the customer.
- Confidently manage and report on the files to and from the OTIP administration systems via SFTP, or other means, with customers/3rd party partners, including tracking, reconciliation, active follow-up and correction activities.
- Provide expertise on related systems, procedures, file specifications, automated file transfers, error handling etc.
- Participate in trouble-shooting and problem analysis related to transfer of electronic files.
- Determine root cause of file-related issues (i.e. data issue, format, system set up, transfer errors, board practices etc.) Participate in developing solutions and facilitate discussions with internal stakeholders and external clients to resolve. Manage and track all phases of issue resolution and data cleanup activities as they pertain to the member lifecycle.
- Collaborate and communicate effectively across teams to achieve a positive result for members and stakeholders.
- Provide information and responds to inquiries from board administrators and members regarding benefit maintenance and procedure issues, coverage, effective dates and outstanding information.
- Manage workload effectively to prioritize the customer requirements with internal requirements for win/win solutions.
- Ensure that quality control and service standards are attained with every transaction.
- Participate in project related activities as necessary for the related Data Specialist job functions. Could include review/document requirements, testing and validation of results.
- Actively pursue continuous improvement related to work processes, reporting, and system improvements.

**Qualifications**:

- A minimum 3 years in technical role; preferably related to review, loading and/or data reconciliation / manipulation / testing of large data files, often requiring analysis and problem solving.
- Proven experience with MS office, with advanced Microsoft Excel and Access experience. Skills in working with SQL would be additional benefit.
- Customer service skills and experience with an aptitude for relationship building and negotiation. Skill is required to interact with both internal stakeholders and external customers to resolve file-related issues, prioritize work, and ensure files are successfully transmitted.
- Documentation and communication skills for a technical and administrative audience (both verbal and written).
- Working knowledge of the Group Benefits industry. Strong knowledge of health and dental insurance, life, long term disability, as it pertains to contractual and administrative provisions.
- Aptitude for learning, self-study and independent problem solving along with the ability to work within the team environment.
- Continuous Improvement aptitude with ability to execute on improvement ideas. Champion for change across the organization; respond positively to challenges and opportunities.
- Prioritization, time-management skills to deliver on commitments and service levels.
- Results driven with a high degree of accuracy and attention to detail.
- Proficiency and Expert Knowledge of Ariel would be an asset.
- The ability to communicate in French will be considered an asset.
- Post-secondary education would be an asset.

Additional Information
**What we offer**:

- Competitive salary and bonus structure
- Industry-leading employer-paid group benefits that start on your first day
- Defined benefit pension plan
- 100% coverage of continuing education and licensing fees (including RIBO and AIC courses)
- Flexible work from home and hybrid options
- Opportunities for advancement
- OTIP and its group of companies strive to create an accessible and inclusive work environment where everyone is treated with respect and dignity. Upon individual request, we will endeavour to remove any barrier to the recruitment and selection processes and provide accommodations for persons with disabilities._
- As a business, we protect what matters most to our members. As an employer, we value what matters most in our workplace. Together, this includes fostering a diverse, equitable and inclusive environment for all. We are committed to learning and evolving so we can continue to celebrate what makes us special. You are who you are, and our differences are what make us unique._

LI-Hybrid



  • Waterloo, Canada Ontario Teachers Insurance Plan (OTIP) Full time

    Company Description OTIP (Ontario Teachers Insurance Plan) is a member-focused, service-driven organization. We are committed to putting our people first by fostering a positive and inclusive work environment, providing a competitive total compensation package and investing in career development. Our team is currently looking for a: **Data...


  • Waterloo, Canada Definity Full time

    Job Description Reporting to the HR Systems leader, the Data & Reporting Specialist will play a key role in providing accurate and timely reporting of our people data across HR systems.  You will collaborate with a variety of stakeholders to develop and maintain HR reports and dashboards that provide insights into people & culture...


  • Waterloo, Canada University of Waterloo Full time

    Overview: The Data Analyst and Evaluation Specialist provides data analysis and insights to support operational and strategic decision making pertinent to student success. This includes responsibility for sourcing, understanding, consolidating, and analyzing data to support university wide, faculty specific and department level student success initiatives...


  • Waterloo, ON, Canada Equitable Life of Canada Full time

    it's about being part of a workplace that helps you grow and reach your full potential. Position Title: Data Governance and Quality Specialist Reports To: Head of Data Governance and Quality Corporate / Impact Term: Permanent Full-Time You will work in our office in Waterloo, ON a minimum of two (2) assigned, consecutive days every other week,...


  • Waterloo, Canada University of Waterloo Full time

    Overview: Accountable to the Associate Director, Prospect Research and in support of University fundraising activity, the Research Data Specialist is responsible for promoting the use and integrity of prospect information in our database of record. This includes creating queries, developing exports, running reports, assisting with data entry, supporting Team...


  • Waterloo, Canada Geosyntec Consultants, Inc. Full time

    If you’re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Specialist** to work with our team of consulting scientists and engineers in...


  • Waterloo, Canada Geosyntec Consultants Full time

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Specialist** to work with our team of consulting scientists and engineers in...

  • Manager, Data Quality

    4 weeks ago


    Waterloo, Canada University of Waterloo Full time

    Overview: **Term: 19 months** This position is responsible for sustaining the ongoing quality, accuracy and completeness of operational data for the Office of Advancement, working within a pre-defined data governance structure. The role will also recommend and implement data quality improvements in their domain. The Manager, Data Quality will maintain the...

  • Marketing Specialist

    4 weeks ago


    Waterloo, Canada University of Waterloo Full time

    Overview: The Marketing Specialist is responsible for the research, development, coordination and promotion of marketing efforts for a defined area within the Waterloo Undergraduate Student Association (WUSA). The incumbent is responsible for developing, implementing and monitoring strategic marketing initiatives designed to maximize awareness of their...

  • Lifecycle Specialist

    4 weeks ago


    Waterloo, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...


  • Waterloo, Canada People Corporation Full time

    We are seeking Client Service Specialists to join our team in Waterloo, ON. This is an exciting time to join People Corporation. Our high level of acquisition activity and our consistent organic growth continue to define and further enhance our benefits, pension, and HR products and services and how they are delivered to our clients. We are in search of a...


  • Kitchener-Waterloo, Canada Mayk Ideas Full time

    **About Mayk**: Mayk Ideas is a marketing and growth advisory consultancy, providing firm, brand and talent strategies and execution capabilities that impact revenue, brand visibility and equity, talent perception, M&A, and succession. We serve challenger brands and industries ranging from financial and professional services, technology, and impact...


  • Waterloo, Canada Huntington Society of Canada Full time

    **FUNDRAISING & GRANTS SPECIALIST** **Position: Fundraising & Grants Specialist** **Reports to: National Director of Development** **Department: Development** **Location: Waterloo, ON (National Office)** **Status: Permanent, Full Time** **Purpose**: The Fundraising & Grants Specialist is responsible for supporting revenue generation through the...


  • Waterloo, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...


  • Waterloo, Canada University of Waterloo Full time

    Overview: **Term: 1 year contract.** The Marketing and Communications Specialist develops, supports, and executes communications and marketing initiatives for incoming and current domestic undergraduate and graduate students (including international student populations), parents, staff, and faculty on behalf of all units within the Student Success Office...

  • Equity Specialist

    4 weeks ago


    Waterloo, Canada University of Waterloo Full time

    Overview: Reporting to the Director of Equity, the Equity Specialist is a member of the Equity Office responsible for planning, implementing and monitoring equity initiatives. The Specialist provides campus members support and guidance on navigating University procedures. The Specialist manages initiatives in line with the Office of Equity, Diversity,...

  • Marketing Specialist

    2 weeks ago


    Waterloo, Canada Alexis Data Solutions Inc Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Advertising, marketing and public relations agency **Tasks**: - Train and supervise staff - Advise clients on advertising or sales promotion strategies - Answer written and oral inquiries - Assist in the preparation of brochures, reports, newsletters and other...


  • Waterloo, Canada University of Waterloo Full time

    Overview: **Term: 2 years** The Information Technology Specialist (IT Specialist) is responsible for the provision and support of all information technology and related computing systems in the Faculty of Arts. These responsibilities include management of computing environments and supporting infrastructure enabling and improving outcomes for...

  • Refresh Specialist

    4 weeks ago


    Waterloo, Canada A & A Merchandising Ltd. Full time

    SiriusXM is hiring part time! Do you thrive in independent work environments offering flexibility and autonomy? If yes, join the SiriusXM Field Team as a Refresh Specialist! In this role you will be responsible for reactivating satellite radios in preowned vehicles at dealerships. **Your role**: - Utilizing the SiriusXM Dealer App, resend satellite...


  • Waterloo, Canada Compugen Inc Full time

    **Job Title** - Database Integration Specialist **Vacancy No** - VN5943 **Work Location** - Waterloo, ON **Job Details** **About Compugen** Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire, integrate and operate technology. Our mission is to help organizations realize...