SQL jobs

Who We Are

With every job, there’s always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It’s because at some point, we’ve all needed someone there for us.

At the OTIP Group of Companies (OGC), we believe that something special happens when employees feel valued for the work they do, supported as the people they are, and included in the very fabric of the organization: they bring their best to work every day. And that's why we mean it when we say we put our people at the centre of everything we do. Join us as we grow our way into a future that reimagines what it means to deliver meaningful benefits support and service.

What You’ll Do:
The Bilingual Business Analyst is responsible for engaging with stakeholders as an advocate for the business to identify and describe business needs in terms of process and business requirements that will provide the best available solution to satisfy the need. Reporting to the Business Analysis Manager, the core parts of your role will be to:

• Gather information from various stakeholders, perform needs/requirements analysis, and assist with the identification of problem statements.
• Examine business needs and goals. Capture and assess requirements, process and business problems to propose solutions and recommendations that improve existing business processes and promote effective and appropriate system solutions.
• Contribute to the evaluation of current state and future state business processes, perform gap analysis, and develops / implements process improvement solutions. Document business requirements including creation of process models, maps, workflows, and diagrams.
• Additional activities may include leading/participating in working groups, information sessions, strategic planning, business capability planning, etc.
• Contribute to the development of test plans as required and the execution of the test plans in conjunction with business units and the project and/or initiative stakeholders.
• Collaborate with stakeholders to determine project scope, vision, cost benefit analysis, risk factors. Contribute to the development of detailed plans in support of business goals and in compliance with project methodology.
• Translate conceptual business requirements into a clear, comprehensible, simplified manner that is comprehensible to all stakeholders.
• Follow organizational standards to maintain quality of service and confidentiality.
• Support the development of practices and processes to ensure adherence to quality standards, change management and release management processes. Identify strategic opportunities to add value to the business through the improved processes, standards, and methodologies.
• Manages and tracks the status of requirements and clearly illustrates the connectivity between business goals/needs, defined requirements, delivered solutions, testing and validation throughout the project lifecycle.
• Provide consulting services to departments and users to enhance the use of existing information systems and processes.
• Analyze metrics and provides recommendations/requirements/solutions to improve business intelligence to support management decisions.

Let’s Talk About You:
This is the unique blend of skills and experience we would love to see in an ideal candidate:

• Bilingualism in English and French is required for this role.
• A university degree, college diploma, or certification in a related field with knowledge of best practices employed by the IIBA and BABOK.
• Three to five years of experience in Business Analysis, Project Management, Operations, IT, or equivalent relevant experience.
• Ability to elicit and document requirements, analyze and map business processes, and facilitate stakeholder workshops and meetings.
• Experience within the personal insurance industry is considered an asset. Specifically, Home and Auto Insurance.
• Experience supporting UAT activities, including planning, test script development, and coordination with stakeholders/testers/developers.
• Experience supporting solution evaluation and validation, including business case development for new technology and ROI analysis.
• Familiarity with one or more of the following technologies is considered an asset: Call Centre applications (preferably NICE in Contact), Broker Management System (preferably Applied Epic), Marketing Automation tools (preferably Pathway) and Web development tools or platforms.
• Data warehousing and business intelligence experience is considered an asset.
• Practical knowledge of SQL or other database query languages is considered an asset.
• Process related certification/designation or commitment to complete. Lean, Six Sigma, Kaizen, 5S and other Lean disciplines connected with cross functional team leadership of business improvement is required.
• Demonstrated ability to use innovative and effective methods to analyze data and produce business solutions that meet process requirements.

We also consider your potential. If you know you have what it takes to do the job, but your experience doesn’t exactly match the qualifications above, we encourage you to apply and provide us with more details about why you think you would be a great fit.

Salary Range:
This position offers a competitive salary within a range of $69,630 to $95,604, along with rewarding bonuses that recognize your dedication.
At the OTIP Group of Companies (OGC), we value transparency and take multiple factors into account when determining your starting salary, including your skills, experience, and alignment with the role as well as internal equity, while positioning you for continued growth and recognition over time.

Some of the Perks We Offer:
We offer best-in-class pension and benefits, total reward programs and comprehensive mental wellness support to set you up for every success in and outside of work. Here are just some of the reasons you’ll love working here:

• Defined benefit pension plan for a financially confident retirement
• 100% coverage of approved continuing education and licensing fees (including RIBO courses in Ontario)
• Access to a wealth of learning resources, including LinkedIn Learning for professional development
• Flexible work-from-home and hybrid options
• Unlock your potential with opportunities for advancement

Let’s work together! If you are interested in this opportunity, please apply online.

The OTIP Group of Companies (“OGC”) is a group of affiliated organizations operating under a shared purpose and values. OGC is comprised of Ontario Teachers Insurance Plan (OTIP), Curo Claims Services, and Orbit Insurance Services.

Candidate communications may refer to OGC when referencing any of the affiliated organizations applied to.

This recruitment process uses artificial intelligence tools to assist with screening and assessing applications. All hiring decisions include human review.

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

We are an equal opportunity employer and encourage applications from all qualified individuals. We thank all applicants for their interest; however, only candidates selected for an interview will be contacted.