BI & Data Analyst - Jobs in Toronto, ON

Job Description

Why join usAre 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 Director, Financial Systems and be responsible for designing and maintaining management system reports (including Power BI, Excel, HFM and JDE), performing data analysis and interpreting results using a using a wide variety of financial applications. 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 report design and generation. 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
• Identify, analyze, interpret and report on trends or patterns in complex data sets
• Financial data exploration and drawing meaningful conclusions and insights, including identifying critical metrics and KPIs
• Filter and “clean” financial 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 dashboard requirements
• Develop and support financial and operational reporting dashboards within Power BI and work closely with Oxford and OMERS teams in Canada, US, Europe and AsiaPac
• Assist with the preparation and development of reporting, presentations and various materials for discussion at the executive level
• 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

To succeed in this role, you have:

• Undergraduate degree in Accounting, Mathematics, Computer Science or a related field
• Have a minimum of 2-3 years of demonstrated experience in a similar role (e.g. Data Analyst or BI Data Analyst)
• Technical expertise in data mining and financial data analysis, with an understanding of financial reporting concepts
• Proven ability to communicate and synthesize complex ideas or large amounts of data into simple, concise presentations at the executive level
• 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
• Experience working with financial applications, primarily Hyperion Financial Management and JD Edwards EnterpriseOne is an asset but not required
• Commercial real estate experience preferred but not required
• Strong eagerness to learn new tools, topics and explore opportunities to improve efficiencies and capabilities
• Team oriented individual with strong communication skills, who is comfortable engaging with different groups within the organization
• Highly proficient in Excel (Pivot Tables, Power Query, Macros), Power BI, SQL and working with data platforms such as Microsoft Azure. Experience and exposure to Hyperion Financial Management, Global Spreadsheet Server, Other BI Tools (Tableau) an asset.
• Willingness to learn RPA and automated technologies and exposure to UI Path an asset
• Desirable: Understand database structures; coordinate with Data Team on data architecture, direct system feeds and experience using Microsoft Azure or similar data platforms.

Vaccination PolicyAt 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 be fully vaccinated or have an approved exemption before attending OMERS and Oxford premises for work or for participating in in-person work events or work meetings.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 Ontarios municipal employees.For more information on Oxford, visit www.oxfordproperties.comOMERS 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 PolicyAt 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.Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected