Investment Fund Analyst

TELUS HOLDINGS PTE. LTD.; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

A financial services company in Singapore is seeking an Investment & Funds Analyst to join their team. The role involves portfolio management, performance analysis, and ensuring data accuracy per the CIO’s investment strategy. Ideal candidates will have a relevant Bachelor's degree and 3-5 years of finance-related experience, along with strong Excel and programming skills in VBA and Python. Proficiency in financial markets and investment products is essential. The position offers a chance to contribute to financial decision-making and reporting.

Qualifications

• 3-5 years of relevant experience in finance, accounting, treasury, or investment operations.
• Experience with portfolio management or brokerage environments is an advantage.
• Strong proficiency in Excel for data analysis and reporting.

Responsibilities

• Manage investment and fund management functions and ensure data accuracy.
• Prepare portfolio reports including performance summaries and holdings analysis.
• Conduct investment performance evaluations and manage cash flow operations.

Skills

Attention to detail

Analytical thinking

Proactive mindset

Strong communication

Microsoft Excel skills

Knowledge of financial markets

Education

Bachelor’s degree in Accounting, Finance, Economics, Data Analytics, or related field

Tools

Microsoft Excel

VBA

Python

Investment tracking systems

Job description

Investment & Funds Analyst

About the Role

We are looking for a detail-oriented and proactive Investment & Funds Analyst to join our investment team. This role will assist with portfolio management, performance analysis, and reporting, ensuring data accuracy and alignment with the Chief Investment Officer’s (CIO) investment strategy.

Key Responsibilities

• Actively manage investment and fund management functions, including month-end and year-end processes, ensuring all financial data is accurate, complete, and timely.
• Prepare and maintain comprehensive portfolio reports, including performance summaries, holdings analysis, and multi-asset class risk exposure details.
• Maintain and update detailed portfolio records covering capital investments, fixed income instruments, equities, and deposits.
• Conduct investment performance evaluations, including yield calculations, return tracking, and variance analysis against projections.
• Manage cash flow operations, fixed deposit placements, bank balance monitoring, and fund transfers, ensuring accurate reconciliations.
• Work closely with external institutions (banks, brokers, and fund managers) to ensure smooth execution, settlement, and reporting of transactions.
• Collaborate closely with the CIO to support investment planning, reporting, and decision-making.
• Leverage advanced Microsoft Excel skills (pivot tables, formulas, macros), as well as VBA and Python programming, for data processing, portfolio tracking, and reporting automation.
• Prepared investment valuation documents and materials required for management and statutory review.
• Ensure data in all internal systems and reports is consistent, accurate, and complete.

Minimum Requirements

Education

• Bachelor’s degree in Accounting, Finance, Economics, Data Analytics, or a related field.

Experience

• Minimum 3 - 5 years of relevant experience in finance, accounting, treasury, or investment operations.
• Experience with portfolio management, banking, or brokerage environments is an advantage.

Technical Skills

• Strong proficiency in Microsoft Excel (pivot tables, formulas, dashboards, and data analysis).
• Working knowledge of VBA and/or Python for automation and reporting.
• Familiarity with investment tracking systems, financial software, and data visualization tools.

Minimum Requirements (Chinese Speaking)

Education

• Bachelor’s degree in Accounting, Finance, Economics, Data Analytics, or a related field.

Experience

• Minimum 3 - 5 years of relevant experience in finance, accounting, treasury, or investment operations.
• Experience with portfolio management, banking, or brokerage environments is an advantage.

Technical Skills

• Strong proficiency in Microsoft Excel (pivot tables, formulas, dashboards, and data analysis).
• Working knowledge of VBA and/or Python for automation and reporting.
• Familiarity with investment tracking systems, financial software, and data visualization tools.
• Knowledge of various investment products (fixed income, equities, FX, funds, structured products).

Knowledge

• Good understanding of financial markets, investment principles, and treasury operations.
• Awareness of compliance standards and reporting requirements in financial operations.

Personal Attributes

• Meticulous and detail-oriented: ensures all reports are accurate, consistent, and tally with financial records.
• Analytical and structured: able to process large datasets, identify trends, and provide clear insights.
• Proactive and self-driven: takes initiative to improve processes and systems.
• Strong communicator and collaborator: able to work effectively with cross-functional teams and external partners.
• Tech-savvy and adaptable: comfortable using new financial tools, software, and automation methods.