Data Specialist/analyst

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/Analyst**

**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._

L



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

  • Data Analyst

    4 weeks ago


    Waterloo, Canada Region of Waterloo Full time

    **Our Story**: Committed to fostering opportunities for current and future generations, the Region of Waterloo is an inclusive, thriving and sustainable region of connected rural and urban communities with global reach. Our mission is to serve, engage and inspire, by delivering quality services to a diverse population of 630,000+, while creating a healthy,...

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


  • Waterloo, Canada Descartes Full time

    **Descartes Unites the People and Technology that Move the World** The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people...


  • Waterloo, Canada BusPlanner Inc. Full time

    **Transportation Analyst** **BusPlanner Inc. **(formerly Georef Systems Ltd.) is a Waterloo-based tech company that provides school bus route planning software solutions to the K-12 industry across North America. We believe strongly that innovation is the key to efficiency and our passion for creating intuitive solutions has made our **BusPlanner **Suite...


  • Waterloo, Canada Definity Financial Corporation Full time

    Job ID : 7395 Category : Human Resources Brand : Definity Regular/Temporary : Regular Fulltime/Parttime : Full Time Location : Waterloo, Canada Posting Range : $55,800 - $102,800 Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance...

  • Risk Data Analyst

    5 days ago


    Waterloo, Canada Equitable Full time

    At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable...


  • Waterloo, Canada Recrute Action Full time

    Job DescriptionData Analyst – InternshipWe are currently recruiting an enthusiastic and dedicated student/co-op/intern for an internship on behalf of our client in the insurance industry. This role provides an excellent opportunity for students to gain hands-on experience in a hybrid work environment. Ideal candidates are currently enrolled in Mathematics,...


  • Waterloo, Canada Recrute Action Full time

    Data Analyst – InternshipWe are currently recruiting an enthusiastic and dedicated student/co-op/intern for an internship on behalf of our client in the insurance industry. This role provides an excellent opportunity for students to gain hands-on experience in a hybrid work environment. Ideal candidates are currently enrolled in Mathematics, Computer...


  • Waterloo, Canada Recrute Action Full time

    Job DescriptionData Analyst – InternshipWe are currently recruiting an enthusiastic and dedicated student/co-op/intern for an internship on behalf of our client in the insurance industry. This role provides an excellent opportunity for students to gain hands-on experience in a hybrid work environment. Ideal candidates are currently enrolled in Mathematics,...

  • Business Data Analyst

    3 weeks ago


    Waterloo, Canada RideCo Full time

    This is an opportunity in the exciting and fast-growing transportation technology industry. Public transit is being transformed from a system of static, scheduled fixed-routes, to a dynamic on-demand network, and you’ll be one of the pioneers shaping this transformation. You’ll join a robust and rapidly growing client success team. As a Business Data...


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

  • Business Data Analyst

    3 weeks ago


    Waterloo, Canada RideCo Full time

    This is an opportunity in the exciting and fast-growing transportation technology industry. Public transit is being transformed from a system of static, scheduled fixed-routes, to a dynamic on-demand network, and you’ll be one of the pioneers shaping this transformation. You’ll join a robust and rapidly growing client success team. As a Business Data...


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

  • Statistical Analyst

    2 weeks ago


    Waterloo, Canada BeOptimized SRL Full time

    ... Waterloo putting yourself in dynamic and challenging environment within the clinical trials management area! ... Statistical Analyst & Programmer. Practice Stat ... Enable life data science boosters · Reach the next ... Waterloo. Alternant(e) RH H/F. Hybrid Remote · Data ... Statistical Analyst & Programmer. Hybrid Remote ... Keyrus Life...

  • Statistical Analyst

    2 weeks ago


    Waterloo, Canada BeOptimized SRL Full time

    ... Waterloo putting yourself in dynamic and challenging environment within the clinical trials management area! ... Statistical Analyst & Programmer. Practice Stat ... Enable life data science boosters · Reach the next ... Waterloo. Alternant(e) RH H/F. Hybrid Remote · Data ... Statistical Analyst & Programmer. Hybrid Remote ... Keyrus Life...

  • Statistical Analyst

    2 weeks ago


    Waterloo, Canada BeOptimized SRL Full time

    ... Waterloo putting yourself in dynamic and challenging environment within the clinical trials management area! ... Statistical Analyst & Programmer. Practice Stat ... Enable life data science boosters · Reach the next ... Waterloo. Alternant(e) RH H/F. Hybrid Remote · Data ... Statistical Analyst & Programmer. Hybrid Remote ... Keyrus Life...


  • Waterloo, Canada BeOptimized SRL Full time

    ... Waterloo putting yourself in dynamic and challenging environment within the clinical trials management area! ... Statistical Analyst & Programmer. Practice Stat ... Enable life data science boosters · Reach the next ... Waterloo. Alternant(e) RH H/F. Hybrid Remote · Data ... Statistical Analyst & Programmer. Hybrid Remote ... Keyrus Life...

  • Business Data Analyst

    4 weeks ago


    Waterloo, Canada Musashi Auto Parts, Inc. Full time

    4 Month Co-op Term **Job Summary**: As a Business Data Analyst - Co-op, you will bring an analytical and data science mindset to support our business systems projects in the design and development of interactive dashboards to help us share important business insights that drive digitalization across the organization. **Reports to**: Senior Manager of...

  • Eas Specialist Iii

    4 weeks ago


    Waterloo, Canada DELUXE CORPORATION Full time

    The Enterprise Application Support Specialist III role is an IT technical analyst role within the Deluxe ITMS support Team accountable to ensure the proper functioning of live, operational, customer-facing environments that are cloud-based, SaaS architectures. The team maintains availability and monitors performance as well as diagnosing problems,...