Data Analyst and Project Manager (1 Year Contract)

The Ottawa Real Estate Board; Ottawa; On-site; CAD 70,000 - 95,000; Full time

Job summary

The Ottawa Real Estate Board is seeking a Data Analyst and Project Manager for a critical role. This position focuses on analyzing real estate market trends and overseeing projects to improve member services. Candidates should possess analytical skills, project management experience, and a relevant degree. A successful hire will drive strategic initiatives to enhance the effectiveness of the association and optimize member experiences.

Qualifications

• 3-5 years of experience in data analysis and project management.
• Proficiency in data analysis tools and project management software.
• Strong understanding of agile and waterfall methodologies.

Responsibilities

• Analyze real estate market data and financial reports to provide insights.
• Lead and oversee association projects, ensuring they're on schedule and budget.
• Develop dashboards and reports for tracking performance metrics.

Skills

Data Analysis

Project Management

Communication

Organization

Education

Bachelor's degree in Business Administration, Data Science, Real Estate, Economics, Statistics, or Finance

PMP certification

Tools

Excel

Power BI

Tableau

SQL

Python

CRM software

Project Management Software

Job description

Data Analyst and Project Manager (1 Year Contract)

The Data Analyst & Project Manager plays a critical role in driving data-informed decision-making while ensuring smooth execution of projects that enhance member services, operational efficiency, and strategic goals.

This position involves analyzing and interpreting real estate market trends, membership data, and other performance metrics, with the goal of enhancing OREB’s suite of offerings to our members. Simultaneously, the role oversees implementation of key projects, including technology implementations and member / brokerage engagement initiatives, ensuring they are delivered on time, within budget, and with adequate user acceptance testing.

By combining analytical expertise with project management skills, this role supports the association’s mission to optimize real estate professionals’ success, enhance member experiences / services, and improve operational effectiveness through data-driven strategies and well-managed projects.

This is a one-year contract with the possibility to transition to permanent full-time position.

Major Responsibilities

• Data Analysis & Reporting

Collect, clean, and analyze real estate market data, membership trends, and financial reports to provide strategic insights.

• Develop and maintain dashboards and reports using tools like Excel, Power BI, or Tableau to track association performance.
• Identify key metrics and trends to support decision-making for leadership, board members, and stakeholders.
• Conduct surveys and analyze member feedback to improve services and engagement strategies.
• Ensure data accuracy and integrity in association management systems (AMS) and customer relationship management (CRM) platforms.
• Project Management & Execution

Lead and oversee association projects, including technology upgrades, new service rollouts, and member engagement initiatives.

• Develop project plans, set timelines, and coordinate with stakeholders to ensure project goals align with the association’s mission.
• Track project progress, identify risks, and implement solutions to keep initiatives on schedule and within budget.
• Oversee vendor relationships for software solutions, data management platforms, and member engagement tools.
• Technology & Process Improvement

Identify and implement data-driven tools to streamline operations and enhance member services.

• Support the integration and optimization of CRM systems for better member tracking and engagement.
• Automate reporting and data collection processes to improve efficiency.
• Work in cooperation with IT to prioritize, advise, and provide guidance for technical projects where appropriate, keeping them to plan in accordance with the Board’s strategic objectives.
• Other

Support IT and Member Support teams as required.

• Draft and review communications products going to membership as required.

Qualifications

• Education & Training

Bachelor's degree or equivalent on-the-job experience in Business Administration, Data Science, Real Estate, Economics, Statistics, Finance, or a related field.

• PMP (Project Management Professional) certification or equivalent is preferred.
• Experience in real estate, property management, or association management is highly desirable, though not mandatory.
• Experience

3-5 years of experience in data analysis, project management, or a related role.

• Technical Skills

Proficiency in data analysis tools (Excel, SQL, Python, Tableau, or Power BI).

• Experience with project management software (Asana, Trello, ClickUp, etc.).
• Knowledge of real estate databases, MLS systems, and CRM software (e.g., Salesforce, Yardi, AgentBook).
• Experience with data visualization tools (Tableau, Google Data Studio, Power BI).
• Project Management Skills

Strong understanding of agile and waterfall project management methodologies is preferred.

• Ability to develop project roadmaps, define KPIs, and track progress.
• Experience in budgeting, resource allocation, and risk management.
• Strong organizational skills to manage multiple projects simultaneously.