Investment Reporting Analyst

Choose a workplace that empowers your impact. 

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

We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 665,000 members, placing their best interests at the heart of everything we do.

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.

Reporting to the Senior Manager, Total Plan Investment Reporting, works as a member of the Total Plan Performance team in providing clients investment reporting and analysis for the fund. Using and maintaining the performance analytics system, the data warehouse and other analytics tools, the position is responsible for preparing and analyzing daily, the performance of programs and the consolidated fund.

Reporting produced includes performance and attribution reports, exposure reports, and internal and external compliance reports across various entity and asset classes that comprise the fund. The reporting and analysis seek to decompose the various investment factors and characteristics of the fund that contributed to the overall results for given time periods.

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. Our hybrid work guideline requires teams to come to the office a minimum of 4 days per week.

You will be responsible for:

• Ensure daily that data for the performance measurement and exposure reporting are collected, input, balanced and reconciled in an efficient manner for our Total Fund Dashboard and any issues arising from the processes are either resolved or escalated as required

• Build and maintain Power BI Dashboards

• Co-ordinate with other investment support and finance areas to ensure inputs for reporting are received and are accurate as required and to understand any issues on valuation, accounting etc. that impact reporting. 

• Calculate performance results and attribution factors at a Total Fund level and asset class or business unit levels.

• Calculate exposure reporting such as country, currency, sector, etc. at a Total Fund level, asset class and business unit levels.

• Monitor portfolio compliance against defined internal and external regulatory policies.

• Ensure that all reporting deadlines are met on a daily, weekly and monthly basis.

• Recommend and implement continuous improvements to the efficiency, timing and reliability of reporting processes.

• Develop an ongoing working relationship with colleagues in Investment, Finance and Risk to understand new product developments, strategies, policies and other activities, as they pertain to performance measurement and exposure reporting.

• Maintain up-to-date knowledge of industry standards in the performance reporting field (GIPS).

• Collect information, data and provide comprehensive reports and analysis on pension industry performance results, public market survey results and their contributing factors in a timely fashion.

• Add value to the Investment processes at OMERS by providing in-depth analysis and ad hoc reporting to Senior Management.

• Participate in projects as required.

• Establish and maintain an effective, team oriented and collaborative working relationship with all staff and management, and act in a manner consistent with OMERS core values.

Required Skills and Experience

• Experience supporting investment performance measurement, attribution analysis, exposure reporting, and financial reporting for investment portfolios and funds.

• Understanding of investment products and asset classes wit the ability to resolve issues and support reporting requirements

• Strong technical skills in Excel, Power BI, and SQL, with experience building dashboards, analyzing large datasets, reconciling investment data, and producing accurate and timely management reporting.

Preferred Skills and Experience

• 2-4 years of experience in a financial institution at the Analyst level assembling and delivering financial information related to performance and exposure of investment products and portfolios.

• Understanding of investment performance and attribution, risk, exposure, and financial reporting issues.

• An understanding of investment products including bonds, equities, derivatives and alternative investments, such as: private equity, real estate and infrastructure.

• University degree in Business, Math or related discipline; required to hold a CFA or CIPM designation or be working towards qualification; CPA designation would be an asset, but not required

• Demonstrated ability to perform complex analysis and manage/resolve issues.

• Demonstrated ability to identify and implement process enhancements to ensure that activities are completed in an efficient manner and add value.

• Proficient in Microsoft Office Suite, with strong expertise in Excel, PowerPoint, and Power BI, capable of developing advanced spreadsheets/BI dashboards, conducting data analysis, and creating impactful visual presentations and dashboards.

• Solid working knowledge of SQL (e.g., Microsoft SQL Server) is required to support data extraction and reporting; expert-level proficiency is not necessary, but comfort with writing and understanding basic queries is expected.

• Ability to establish and maintain effective working relationships and work as part of a team, with strong written and verbal communication skills.

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.

As one of Canada’s largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work — and the members 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.