Business Intelligence Analyst

Condominium Authority of Ontario • Toronto, ON

3d • CA$70,000 - CA$80,000 • Hybrid

About The Position

The Condominium Authority of Ontario (CAO) is a dynamic, digital organization that supports the province's 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 CAO’s 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 Toronto’s 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. Our Mission: Engage and empower Ontario’s condominium communities with information, education, and dispute resolution. Corporate Values: 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.

Requirements

• Bachelor's degree in a relevant field (e.g., Data Management, Information Systems, Computer Science, Mathematics).
• 3+ years of working with PowerBI to create interactive and visually appealing reports and dashboards.
• Demonstrated 4+ years of data-driven decision-making experience.
• Strong T-SQL, Python, PySpark, or R skills with the ability to write complex queries to extract and manipulate data from relational databases.
• 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.

Nice To Haves

• Experience with Google Analytics/GA4 an asset.

Responsibilities

• 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.
• Work with stakeholders to determine reporting needs that enable data-driven decisions.
• Develop dashboards, charts, reports, and other visualizations to clearly present findings.
• Automate recurring reports and data visualizations where possible to increase efficiency.
• Translate complex data into actionable insights that drive business decisions.
• Collaborate with business teams to understand their needs and offer data-driven recommendations.
• Apply statistical techniques to analyze large datasets and extract meaningful insights and forecasts.
• Identify trends, patterns, and correlations to support business objectives.
• Conduct exploratory data analysis to uncover new insights and opportunities.
• 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.
• 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.
• 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.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level