Investment Fund Analyst

TELUS Communications; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading investment firm in Singapore is seeking an Investment & Funds Analyst to manage investment portfolios and perform detailed analysis. Candidates should have a Bachelor's degree in a relevant field and 3–5 years of experience. Strong skills in Microsoft Excel, VBA, and Python are essential. This role involves preparing portfolio reports and collaborating closely with the Chief Investment Officer.

Qualifications

• 3–5 years of relevant experience in finance, accounting, treasury, or investment operations.
• Experience with portfolio management, banking, or brokerage environments is an advantage.
• Familiarity with various investment products (fixed income, equities, FX, funds, structured products).
• Good understanding of financial markets, investment principles, and treasury operations.

Responsibilities

• Actively manage investment and fund management functions.
• Prepare and maintain comprehensive portfolio reports.
• Conduct investment performance evaluations, including yield calculations.
• Manage cash flow operations and ensure accurate reconciliations.
• Collaborate closely with the CIO to support investment planning.

Skills

Microsoft Excel proficiency

VBA programming

Python programming

Analytical skills

Detail-oriented

Education

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

Tools

Investment tracking systems

Financial software

Data visualization tools

Job description

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 investment strategy.

Key Responsibilities

• Actively manage investment and fund management functions, including month‑end and year‑end processes.
• 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), VBA and Python programming for data processing, portfolio tracking, and reporting automation.
• Prepare investment valuation documents and materials required for management and statutory review.
• Ensure data in all internal systems and reports is consistent, accurate, and complete.

Qualifications

• Bachelor’s degree in Accounting, Finance, Economics, Data Analytics or a related field.
• 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.
• Strong proficiency in Microsoft Excel (pivot tables, formulas, dashboards, 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).
• 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 in line with financial records.
• Analytical and structured: processes large datasets, identifies trends, and provides clear insights.
• Proactive and self‑driven: takes initiative to improve processes and systems.
• Strong communicator and collaborator: works effectively with cross‑functional teams and external partners.
• Tech‑savvy and adaptable: comfortable using new financial tools, software, and automation methods.