Data Analyst

Corporate Background

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. The seven-member board of directors provide strategic guidance and oversight of the organization.

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, accountability, client focus, value for money, integrity, fairness

Team Values

Respect, trust, diversity, collaboration, leadership

Purpose

We are seeking a highly motivated and detail-oriented Data Analyst to join our team. As a Data Analyst, you will be responsible for interpreting data, analyzing results, and providing insights to guide business decisions. You will develop subject matter expertise and strong relationships. You will collaborate with people across the organization and fosters a culture of data-driven decision making and data literacy

Key responsibilities

Data Collection and Preparation:

• Collaborate with various teams to identify data sources and collect relevant data.

• Clean, transform, and preprocess data to ensure accuracy, consistency, and suitability for analysis.

Data Analysis:

• Utilize statistical techniques to analyze large datasets and extract meaningful insights.

• Identify trends, patterns, and correlations in the data to support business objectives.

• Perform exploratory data analysis to discover hidden insights.

Reporting and Visualization:

• Work closely with key stakeholders to identify reporting needs that will facilitate data-driven decision making.

• Develop clear and informative dashboards, charts, and visualizations to present to stakeholders.

• Create recurring reports and automate data visualization processes where possible.

Interpretation and Insight Generation:

• Translate complex data into understandable insights that drive decision-making.

• Collaborate with business teams to understand their needs and provide data-driven recommendations.

Data Quality and Integrity:

• Define, maintain, and communicate the data "source of truth" for cross-functional teams to use in assessing performance and quality.

• Identify and address data discrepancies or anomalies.

• Make recommendations to business teams, and management based on data analysis findings that support actionable solutions.

Collaboration:

• Work closely with cross-functional teams, including business analysts, managers, and directors, to understand requirements and provide analytical support.

• Communicate findings and insights effectively to both technical and non-technical stakeholders.

Continuous Improvement:

• Stay up to date with industry trends, best practices, and emerging technologies in data analysis.

• Proactively suggest process improvements and ways to enhance data analysis efficiency.

Qualifications, skills & knowledge

Must Haves:

• Bachelor's degree in a relevant field (e.g., Data Management, Information Systems, Computer Science, Mathematics).

• Demonstrated 4+ years of data-driven decision-making experience.

• Strong SQL, Python, or R skills with the ability to write complex queries to extract and manipulate data from relational databases.

• 2+ years of working with PowerBI to create interactive and visually appealing reports and dashboards.

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

Nice to Haves:

• Working knowledge of ArcGIS Enterprise Platform (ArcMap, ArcGIS Pro, ArcGIS Online, ArcGIS Server, ArcSDE) and AutoCAD.

• Proficiency in web analytics tools such as Google Analytics, Adobe Analytics, or similar platforms.

• Familiarity with data warehousing concepts and data modeling is a plus.

• Experience working with 3rd party vendors and development partners.

Other Skills:

• Excellent communication skills to convey complex findings in a clear and understandable manner.

• Ability to work collaboratively in a team-oriented environment.

• Strong analytical thinking and problem-solving skills.

• Excellent organizational skills, detail-oriented, and the ability to multitask under pressure.

Working conditions & environment

• Hybrid Environment

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.