Total 2 job vacancies by Telus Holdings Pte. Ltd.

Employment Type

Project-Based Contract / Professional Consulting Assignment

Position Summary

We are seeking an experienced Investment Performance & Excel Model Review Consultant to independently review, validate, and enhance existing Excel-based investment performance models and related calculation methodologies.

The successful candidate will assess the accuracy, consistency, and reliability of performance measurement calculations, including Internal Rate of Return (IRR), Time-Weighted Return (TWR), Money-Weighted Return (MWR), bond yields, and portfolio returns. The role involves identifying calculation errors, methodological inconsistencies, and control weaknesses, while providing practical recommendations aligned with industry standards and best practices.

Key Responsibilities

• Review existing Excel model structures, formulas, assumptions, data inputs, and cash flow treatment methodologies.
• Validate the accuracy of IRR, XIRR, TWR, MWR, bond yield, and portfolio return calculations.
• Assess the appropriateness of existing investment performance measurement methodologies against market practices and recognised standards.
• Identify formula errors, methodological inconsistencies, manual adjustments, and model control weaknesses.
• Recommend enhancements to improve model accuracy, transparency, auditability, and operational robustness.
• Prepare concise documentation outlining calculation methodologies, key assumptions, limitations, and recommended controls.
• Present findings and recommendations to management in a clear and practical manner.

Key Deliverables

• Model Review Findings Report
• Recommended Calculation Methodologies and Assumptions
• Revised or Enhanced Excel Model (where applicable)
• Management Summary Report
• Documentation of Key Controls and Validation Procedures

Essential Requirements

• Degree in Finance, Accounting, Investment Management, Mathematics, Statistics, Economics, or a related discipline.
• Professional qualification in investment performance measurement, such as CIPM, or equivalent professional expertise in investment performance analysis and model validation.
• Proven experience in investment performance measurement, portfolio return analysis, performance attribution, or investment reporting.
• Strong knowledge of IRR, XIRR, TWR, MWR, bond yield calculations, and portfolio performance methodologies.
• Advanced proficiency in Microsoft Excel, including financial modelling, formula validation, data reconciliation, and analytical review.
• Strong analytical, documentation, and communication skills, with the ability to explain technical concepts to non-technical stakeholders.

Preferred Experience

• Experience reviewing or validating investment performance models used by investment managers, asset management firms, family offices, private funds, or financial institutions.
• Familiarity with industry standards and best practices relating to investment performance measurement and reporting.
• Experience supporting management reporting, governance reviews, audit reviews, or investment oversight functions.

Project Duration

Project-based engagement with deliverables to be completed within an agreed timeframe.

Job Summary

We are seeking a meticulous and organised Part-Time Finance & Property Reporting Analyst to support finance and property management reporting, investment and asset tracking, bank reconciliation, external coordination, and process improvement for group and overseas property matters.

Responsibilities

• Prepare and maintain monthly finance, property, investment, and management reports to provide accurate financial insights.
• Report on profit and loss, balance sheet items, shareholder accounts, capital movements, cashflow, budgets, expenses, and asset positions to support management decisions.
• Assist with entity-level and consolidated reporting, including preparing reconciliations, supporting schedules, and management reporting files for comprehensive financial oversight.
• Prepare and update bank, cashflow, payment, deposit, and account movement records to ensure accurate financial tracking.
• Reconcile bank accounts, credit cards, e-wallets, petty cash, and other cash-related records to maintain financial accuracy.
• Maintain property, investment, and asset tracking schedules, including overseas property-related records, to support asset management.
• Support property management reporting by tracking property income and expenses, payment schedules, ownership or title document status, insurance records, service provider updates, and pending follow-up matters.
• Coordinate with overseas finance and property teams on finance records, property documentation, payment follow-up, bank matters, adviser updates, and management reporting requirements to ensure alignment and accuracy.
• Follow up on property agreements, title documents, ownership records, payment records, insurance records, adviser updates, and other supporting documents to ensure completeness and proper documentation.
• Track and update document status, pending matters, and completion timelines for management review to facilitate timely decision-making.
• Coordinate with banks, auditors, tax agents, corporate service providers, consultants, property agents, property management teams, and other external parties to support financial and property operations.
• Maintain proper records, filing structure, approval trails, and supporting documents for management review and audit purposes.
• Assist in improving finance workflows, reporting processes, approval routes, and document management procedures to enhance operational efficiency.
• Prepare SOPs, checklists, trackers, meeting notes, timelines, and follow-up reports to support process standardisation and accountability.
• Support ad hoc finance, banking, property management, reporting, or documentation matters assigned by management.

Required Competencies and Certifications

• Bachelor’s degree in Accounting, Finance, Business, Economics, Data Analytics, or a related discipline.
• Minimum 3 to 5 years of relevant experience in finance reporting, accounting operations, property accounting or documentation, bank reconciliation, external party coordination, property management reporting, or multi-entity reporting.
• Strong Microsoft Excel skills, including formulas, pivot tables, reconciliation schedules, and reporting templates.
• Good understanding of accounting, bank reconciliation, financial reporting, property-related records, asset tracking, and document control.
• Ability to manage multiple reports, documents, deadlines, and follow-up matters independently.
• Good communication and coordination skills.
• Ability to review finance, property, investment, and management documents in English.

Preferred Competencies and Qualifications

• Experience in family office, investment holding companies, real estate investment, property management, fund administration, or multi-entity group reporting.
• Ability to review Chinese-language supporting documents will be useful, as some supporting records may be in Chinese.
• Experience preparing management reports, consolidated schedules, asset trackers, payment schedules, SOPs, audit files, or reporting support documents will be useful.
• Knowledge of VBA, Power Query, Python, accounting systems, or reporting automation tools will be useful.
• Experience supporting overseas property-related reporting, property management records, asset tracking, document follow-up, or external adviser coordination will be useful.
• Experience coordinating with overseas teams on finance, property, banking, documentation, or reporting matters will be useful.