BI & Data Analyst (12 Months Contract)

Oxford Properties Group; Toronto; Hybrid; CAD 72,000 - 108,000; Full time

Benefits offered by this job

Group benefits

Retirement plans

Incentive plan (short-term)

Job summary

Oxford Properties in Toronto, Canada, is seeking an Analyst, Business Intelligence to partner with finance and IT, driving data analytics and automating reporting with Power BI, SQL, and advanced Excel. This hybrid role requires 3+ years in data analytics and a degree in accounting, math, or CS.

You will work with diverse data sources, develop KPIs and contribute to executive-ready insights. The position offers a flexible hybrid work model with in-office collaboration multiple days per week and

Qualifications

• Undergraduate degree in Accounting, Mathematics, Computer Science or a related field.
• Have a minimum of 3+ years of demonstrated experience in a similar role (e.g. Data Analyst or BI Data Analyst).
• Team oriented with strong communication skills across groups (including non-technical audiences).
• Thrives in dynamic environments by adapting to evolving requirements and refining approaches as new information emerges.
• Strong project management and organizational skills with ability to handle multiple deadlines.
• Willingness to learn new technologies, including RPA, to improve processes.
• Experience with Power BI, SQL, and advanced Excel functionality (Power Query).
• Technical expertise in data mining/analysis and understanding of financial reporting concepts.

Responsibilities

• Collaborate with management teams to prioritize business, analytics and information needs and understand project requirements.
• Work with financial and operational data from multiple sources across stakeholder teams.
• Identify efficiency gains and drive reporting automation initiatives.
• Analyze trends and KPIs in complex data sets and report insights.
• Filter/clean data and troubleshoot data quality issues per governance policies.
• Prepare reports, presentations and materials for executive discussions.

Skills

Data analytics

Communication

Project management

Problem solving

Education

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

Tools

Power BI

SQL

Excel (Power Query)

Job description

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.

The Analyst, Business Intelligence acts as a business partner to our finance stakeholders, performing data analysis using a wide variety of applications (including Power BI and SQL), and driving automation effort. 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 and 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 3+ 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).
• Thrives in dynamic environments by adapting to evolving requirements and refining approaches as new information emerges, even when processes are not fully defined.
• 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 Power BI, SQL, and advanced Excel functionality (including Power Query) to develop automation solutions. Experience with other BI Tools and VBA would be 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.

We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other, our flexible hybrid work guideline requires teams to come in to the office 4 days per week.

This posting is for an existing vacancy.

The expected salary range for this position is $72,000.00 - $108,000.00 per year, prorated based on the term of the contract.

You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans – details on these elements of compensation are included within OMERS & Oxford offer letters.

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 Purpose@Work committee and employee recognition programs.

Artificial intelligence (AI) tools are used to support certain stages of the OMERS recruitment process. While AI assists us in our process, human judgment and decision-making remain central to our candidate experience.