Business Intelligence Analyst

Background

The Condominium Authority of Ontario (CAO) is a dynamic digital organization that supports the provinces rapidly evolving condominium sector with information education and dispute resolution services.

We value innovation collaboration creativity a get-it-done mindset and embrace modern agile/scrum IT development methodologies and client-focused solutions. Our staff have told us that CAOs culture embraces diversity and provides a collaborative environment where they can learn grow and thrive. We are committed to staff well-being and work-life balance and offer competitive compensation health benefits pension matching and a hybrid work environment. Our office is in heart of Torontos bustling financial district.

The CAO is a delegated administrative authority that supports condo living and enhances consumer protection by providing services and resources that reach all condo communities across Ontario. We are accountable to the government through and Administrative Agreement with the Minister of Public and Business Service Delivery and Procurement. The seven-member board of directors provide strategic guidance and oversight of the organization.

We are an organization driven by our vision mission and values:

• Our Vision: Strong and vibrant condominium communities in Ontario.
• OurMission: Engage and empower Ontarios condominium communities with information education and dispute resolution
• CorporateValues: Innovation trust teamwork value for money integrity fairness
• Team Values: Respect trust diversity collaboration leadership

We value flexibility and have adopted a hybrid work model whereby employees use a combination of working remotely 2 days a week and in the office for 3 days

Role Purpose

Reporting to the Manager Data Analytics &ReportingtheBusiness IntelligenceAnalyst is responsible for interpreting and analyzing data providing actionable insightsproducing comprehensive dashboards and reports and supporting business decisions. This role develops subject matter expertise and builds strong relationships across teams promoting a culture of data-driven decision-making and data literacy throughout the organization.

Please apply by June 2 2026 3:00 pm

Key Responsibilities

Data Collection and Preparation

• Collaborate with teams to identify relevant data sources and gather necessary data.
• Clean transform and preprocess data to ensure accuracy consistency and readiness for analysis.

Reporting and Visualization

• Work with stakeholders to determine reporting needs that enable data-driven decisions.
• Develop dashboards chartsreports andothervisualizations to clearly present findings.
• Automate recurring reports and data visualizations where possible to increase efficiency.

Interpretation and Insight Generation

• Translate complex data into actionable insights that drive business decisions.
• Collaborate with business teams to understand their needs and offer data-driven recommendations.

Data Analysis

• Apply statistical techniques to analyze large datasets and extract meaningful insightsand forecasts.
• Identify trends patterns and correlations to support business objectives.
• Conduct exploratory data analysis to uncovernewinsights and opportunities.

Data Quality and Integrity

• Define and maintain a source of truth for data ensuring consistency across teams.
• Identify and resolve data discrepancies or anomalies.
• Provide recommendations to business teams and management based on analysis to support actionable solutions.

Continuous Improvement

• Stay updated on industry trends best practices and emerging technologies in data analysis.
• Proactively suggest improvements to processes and ways to enhance data analysis efficiency.

Collaboration

• Partner with cross-functional teams including analysts managers and directors to gather requirements and offer analytical support.
• Communicate findings effectively to both technical and non-technical stakeholders.
• Perform other related duties as assigned.

Qualifications Skills & Knowledge

• Bachelors degree in a relevant field (e.g. Data Management Information Systems Computer Science Mathematics).
• 3 yearsof working with PowerBI to create interactive and visually appealing reports and dashboards.
• Demonstrated 4 years of data-driven decision-making experience.
• Strong T-SQL PythonPySpark or R skills with the ability to write complex queries to extract and manipulate data from relational databases.
• Experience with Google Analytics/GA4 an asset.
• Experience creating surveys and knowledge of Question Design best practices.
• Experience with standard and advanced data analysis techniques such as regression trend lines forecasting modeling clustering Hypothesis Testing Content Analysis and Narrative Analysis
• Excellent communication skills and experience collaborating with various stakeholders in a fast-paced environment.
  

What We Offer:

• Base Salary - CAD annually
• Hybrid working environment - 2work from home days per week(Mon Fri) with 3 days in-officeper week (Tues Wed Thurs)
• Comprehensive health coverage plan that includes medical dental and vision
• Vacation paid personaltimeand sick days
• Company-sponsoredevents
• Matching RRSP/TFSA contribution
• Employee gym and bike-share discounts
• Professional learning and development opportunities

DISCLAIMER

We thank everyone for their interest in joining our dynamic team but due to the volume of applications only those qualified will be contacted.

CAO is an equal opportunity employer encouraging workplace diversity. All qualified individuals will be considered without regard to race national origin gender identity/expression age religion disability sexual orientation marital status or any other characteristic protected by law.

CAO welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

Required Experience:

IC