BI & Data Analyst

仕事内容

Why join us?

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.

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 Manager, Financial Systems and be responsible for designing and validating management system reports (including Power BI, Power Query and Excel), performing data analysis using a wide variety of applications, and driving automation efforts within the Finance team (specifically focused on Robotic Process Automation). To succeed in this role, candidates will have a strong aptitude towards working with large volumes of data, experience in data analytics, ability to mine data, and understanding data flow & structure. This role requires strong attention to detail as well as the ability to multitask in a complex environment. The preferred candidate will have a strong focus on customer service and be a team player with a proven ability to build relationships between the business groups, financial team and IT department.

As a member of this team, you will be responsible for
Work with financial and operational data from primary or secondary data sources
Seek efficiencies in existing processes and execution of process improvement initiatives, including exploring and identifying potential new tools and technologies for enhancing reporting automation capabilities, including the use of Robotic Process Automation (RPA)
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
Work with management teams to prioritize business, analytics and information needs and understand project requirements
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).
Willingness to learn RPA and automated technologies, with a strong inclination to improve processes and not settle for ‘status quo’ (exposure to UI Path an asset).
Advanced Excel knowledge (including Pivot Tables, Power Query, VBA Macros), and proficient in Power BI, and SQL.
Experience and exposure to Hyperion Financial Management, Global Spreadsheet Server, and other BI Tools (e.g. Tableau) an asset.
Strong eagerness to learn new tools, topics and explore opportunities to leverage technology to generate efficiencies and improve capabilities.
Team oriented individual with strong communication skills, who is comfortable engaging with different groups within the organization (including non-technical audiences).
Technical expertise in data mining and analysis, with an understanding of financial reporting concepts.
Demonstrate strong problem-solving skills and innovative approaches for resolution.
Strong project management and organizational skills and ability to work under pressure and manage high priority projects with multiple or competing deadlines.

Our story:
Oxford Properties Group (“Oxford”) is a leading global real estate investor, asset manager and business builder. It builds, buys and grows defined real estate operating business with world-class management teams. Established in 1960, Oxford and its portfolio companies manage approximately C$70 billion of assets across four continents on behalf of their investment partners. Oxford’s owned portfolio encompasses office, logistics, retail, multifamily residential, life sciences and hotels; it spans more than 150 million square feet in global gateway cities and high-growth hubs. A thematic investor with a committed source of capital, Oxford invests in properties, portfolios, development sites, debt, securities and real estate businesses across the risk-reward spectrum. Together with its portfolio companies, Oxford is one of the world’s most active developers with over 100 projects currently underway globally across all major asset classes. Oxford is owned by OMERS, the Canadian defined benefit pension plan for Ontario’s municipal employees.

For more information on Oxford, visit www.oxfordproperties.com

OMERS is committed to having a workforce that reflects the communities in which we live and work. We are an equal opportunity employer committed to a barrier-free recruitment and selection process. At OMERS inclusion and diversity means belonging. How we create a sense of belonging is through our employees and our vast network of Employee Resource Groups. Whether you are passionate about gender, pride, or visible minorities, we have groups that are focused on making a difference in all of our lives.

Vaccination Policy

At OMERS and Oxford the office or worksite is our primary place of work. We are committed to providing work environments which promote the health, safety and well-being of all employees in accordance with public health regulation and guidance. Accordingly, employees are required to provide evidence of full vaccination or have an approved exemption.