Business Intelligence Analyst

Ontario Teachers Insurance Plan; Waterloo; Hybrid; CAD 60,000 - 95,000; Full time

Job summary

Join a forward-thinking organization as a Business Intelligence Analyst, where your insights will drive innovation and continuous improvement. In this role, you will collaborate with various stakeholders to leverage business data, enhance operational efficiencies, and contribute to strategic projects across all business lines. This is an exciting opportunity to be part of a team that values your contributions and supports your professional growth while providing a flexible work environment. If you are passionate about data and have a knack for problem-solving, this role is designed for you!

Benefits

Rewarding salary and bonuses

100% premium coverage group benefits

Defined benefit pension plan

100% coverage of continuing education fees

Access to LinkedIn Learning

Flexible work-from-home options

Opportunities for advancement

Qualifications

• 3+ years of experience in business analysis or related field required.
• Advanced knowledge of BI reporting tools and Microsoft Power Platform.

Responsibilities

• Collaborate with stakeholders to identify opportunities for business intelligence.
• Synthesize data to identify trends and present results effectively.

Skills

Business Analysis

Data Synthesis

Communication Skills

Problem-Solving

Coaching and Mentoring

Education

University Degree or College Diploma

Certification in Related Field

Tools

MS Reporting Tool

Microsoft Power Platform

SQL

Microsoft Excel

Job description

Enterprise Solutions Office location_on Waterloo, ON

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.

Job Description

What You’ll Do:

The Business Intelligence Analyst role is responsible to support OTIP business solutions initiatives, including those which leverage business data for greater insights. Intended to drive continuous improvement and efficiencies, this role includes participation in strategic projects and business objectives across all lines of business with a focus on rapid innovation and emerging technologies.

Reporting to the Business Intelligence Manager, you’ll be responsible for:

• Collaborating with business stakeholders to identify high-value opportunities for the application of business intelligence and emerging technologies.
• Collaborating as part of a team of analysts to devise strategies, alternatives, and recommendations for effective delivery of business solutions that meet stakeholder needs, leveraging business intelligence and emerging technologies.
• Supporting cross-functional stakeholders by providing analytical support and recommendations through the design, build and operationalization of business intelligence and emerging technologies.
• Building strong internal customer relationships with colleagues, key stakeholders, and business leaders to proactively understand strategic objectives within all areas of the business.
• Synthesizing large amounts of data to identify key trends and presenting the results in a logical and concise manner effectively to stakeholders.
• Supporting the analysis and ongoing continuous improvement of datasets, including connection points across all channels, such as social media platforms, website/mobile, etc.
• Contributing to organizational effectiveness through the development, analysis, and implementation of business intelligence and emerging technologies initiatives.
• Actively seeking out external benchmarks and best practices to improve our competitive advantage.

Qualifications

Let’s Talk About You:

This is the unique blend of skills and experience we would love to see in an ideal candidate:

• A university degree, college diploma or certification in a related field with knowledge of best practices employed by the IIBA and BABOK.
• 3+ years of experience in business analysis or related field.
• Advanced knowledge of MS reporting tool or equivalent BI reporting suite.
• Understanding of JSON, Python, API and Webhooks considered an asset.
• Proven ability to coach and mentor on technical solutions.
• Intermediate knowledge of business analysis and design techniques; including strong understanding of the Microsoft Power Platform.
• Microsoft certifications considered an asset: Power Platform Fundamentals, MS Power BI.
• Excellent oral and written communication, presentation, facilitation and influencing skills.
• Process related certification/designation or commitment to complete. Lean, Six Sigma, Kaizen.
• Demonstrated ability to translate technical solutions into non-technical details.
• Knowledge of SQL or any database query language.
• Excellent organization, communication, and problem-solving skills.
• Advanced PC skills, Microsoft Excel, Word, Access.

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.

Additional Information

Some of the Perks We Offer:

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

• Rewarding salary and bonuses that truly value your dedication.
• Industry-leading group benefits with 100% premium coverage (excluding LTD) that start on your first day.
• 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.

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.