BI & Data Analyst

Oxford Properties Group; Toronto; On-site; CAD 60,000 - 80,000; Full time

Job summary

A global real estate company in Toronto is seeking a highly motivated BI & Data Analyst. The ideal candidate will collaborate with finance stakeholders to perform data analysis and drive automation efforts. Successful candidates will have a background in data analytics and a knack for solving complex problems. This role offers opportunities for growth and contributes to strengthening communities through real estate.

Qualifications

• Minimum of 1-2 years of experience in a similar role.
• Strong communication skills for engaging with various groups.
• Experience with various BI & AI tools is an asset.

Responsibilities

• Collaborate with management teams to understand project requirements.
• Analyze, interpret and report trends or patterns in complex data sets.
• Assist with preparation and development of reports for executives.

Skills

Data analysis

Project management

Communication

Data mining

Problem-solving

Education

Undergraduate degree in Accounting, Mathematics, Computer Science or related field

Tools

Power BI

SQL

UiPath

Power Platform

Excel (Power Query, VBA)

Job description

Overview

Choose a workplace that empowers your impact.

Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and passion. A place where you can personalize your employee journey to be — and deliver — your best.

We are a leading global real estate investor, developer and manager. We combine our capital with our capabilities to create real estate that strengthens economies and communities. By prioritizing people, partnerships and places, we generate meaningful returns for OMERS members, enhance value for our capital partners and create a brighter world for our customers.

Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.

Don’t just work anywhere — come build tomorrow together with us.

Know someone at OMERS or Oxford Properties?

Great If you’re referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.

Are you looking to join an innovative, global real estate company who builds communities and connects people to exceptional places? If so, we would love to tell you our story.

At Oxford, our culture is truly one of a kind. Across business lines and around the world, we embrace the complex and tackle opportunities with speed and agility. We are ambitious and humble, forward looking and service-focused. We get stuff done, and have fun doing it. We take great pride in contributing to the communities where we live. We believe that what is good for the environment is good for business. Together we deliver exceptional experiences to our over 2 million daily customers.

We are looking for a highly motivated BI & Data Analyst to join the Financial Systems Team in Toronto. This role will report to the Senior Manager, Finance Data and Automation and be responsible for acting as a business partner to our finance stakeholders, performing data analysis using a wide variety of applications (including Power BI, Power Platform, UiPath, SQL and various AI tools), and driving automation efforts within the Finance team. To succeed in this role, candidates must be able to drive project completion with strong communication and project management, combined with experience in data analytics, big data mining, and data flow & structure. This role will require effective customer service management, with a proven ability to build relationships between the business groups, financial team and IT department, while being able to multitask in a complex environment.

As a Member Of This Team, You Will

• Collaborate with management teams to prioritize business, analytics and information needs and understand project requirements
• Work with financial and operational data from primary or secondary data sources from different stakeholder teams and business functions
• Seek efficiencies in existing processes and execute process improvement initiatives, including exploring and identifying potential new tools and technologies for enhancing reporting automation capabilities
• Identify, analyze, interpret, and report on trends or patterns in complex data sets
• Exploring large data sets and drawing meaningful conclusions and insights, including identifying critical metrics and KPIs
• Filter and \"clean\" data by reviewing extracts, reports, printouts, and performance indicators to identify, troubleshoot and resolve problems, including data quality, integrity issues and follow data governance policies
• Assist with the preparation and development of reporting, presentations and various materials for discussion at the executive level

To Succeed In This Role, You Have

• Undergraduate degree in Accounting, Mathematics, Computer Science or a related field.
• Have a minimum of 1-2 years of demonstrated experience in a similar role (e.g. Data Analyst or BI Data Analyst).
• Team oriented individual with strong communication skills, who is comfortable engaging with different groups within the organization (including non-technical audiences).
• Strong project management and organizational skills and ability to work under pressure and manage high priority projects with multiple or competing deadlines.
• Willingness to learn new technologies, including RPA, with a strong inclination to improve processes and not settle for 'status quo' to generate efficiencies and improve capabilities.
• Experience with UiPath Studio, Power Platform, Power BI, SQL, Copilot, and advanced Excel functionality (including Power Query, VBA) to develop automation solutions. Experience with other BI & AI tools is an asset.
• Technical expertise in data mining and analysis, with an understanding of financial reporting concepts.
• Demonstrate strong problem-solving skills and innovative approaches for resolution

Oxford's purpose is to strengthen economies and communities through real estate.

Our people-first culture is at its best when our workforce reflects the communities where we live and work — and the customers we proudly serve.

From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our committee and employee recognition programs.