Internship: Global Markets, Asset Liability Management/Portfolio Intelligence Unit [Jan - Jun 2027]

OCBC Bank; Singapore; On-site; SGD 20,000 - 33,000; Full time

Benefits offered by this job

Competitive base salary

Holistic benefits

Professional development opportunities

Wellbeing and growth

Job summary

OCBC Bank is seeking a student intern to support the Asset Liability Management Portfolio Intelligence Unit. You will assist in analytics, modelling, automation, and dashboarding to provide insights for portfolio performance and risk monitoring.

The role offers hands-on exposure to market data, financial modelling, and data visualization tools using VBA, Python, and Tableau. You will collaborate with portfolio managers and treasury professionals on data-driven initiatives.

Qualifications

• Currently pursuing an undergraduate or postgraduate degree.
• Strong analytical and quantitative skills.
• Proficient in Excel with VBA and Python.
• Familiarity with Tableau and dashboard development.
• Interest in financial markets and portfolio management.

Responsibilities

• Portfolio Analytics: monitor ALM portfolio performance and risk metrics.
• Financial Modelling: develop/maintain models for portfolio analysis and scenarios.
• Process Automation: build VBA and Python tools to automate reporting.
• Dashboard Development: create Tableau dashboards for portfolio insights.
• Data Mining & Analysis: analyze market data and company financials.
• Predictive Analytics: support forecasting and trend analysis.
• Market Research: monitor financial markets and industry developments.
• Reporting & Administrative Support: prepare management reports and presentations.
• Ad-hoc Projects: assist on strategic analytics initiatives.

Skills

Excel

VBA

Python

Tableau

Analytical skills

Education

Pursuing undergraduate or postgraduate degree

Tools

Tableau

Excel

Python

VBA

Job description

WHO WE ARE

As Singapore’s longest established bank, we have been dedicated to enabling individuals and businesses to achieve their aspirations since 1932. How? By taking the time to truly understand people. From there, we provide support, services, solutions, and career paths that meet their individual needs and desires. Today, we are on a journey of transformation. Leveraging technology and creativity to become a future-ready learning organisation. But for all that change, our strategic ambition is consistently clear and bold, which is to be Asia’s leading financial services partner for a sustainable future. We invite you to build the bank of the future. Innovate the way we deliver financial services. Work in friendly, supportive teams. Build lasting value in your community. Help people grow their assets, business, and investments. Take your learning as far as you can. Or simply enjoy a vibrant, future-ready career. Your Opportunity Starts Here.

Why Join

Be part of a team that leverages data, analytics, and market expertise to support balance sheet management and investment decision-making.

How You Succeed

To excel in this role, you'll need to be analytical, intellectually curious, and comfortable working with both financial and market data. You'll collaborate closely with portfolio managers and stakeholders to monitor portfolio performance, analyse risk exposures, and develop tools that enhance decision-making. Your ability to combine financial knowledge, programming skills, and data analytics will help drive efficiencies and generate valuable insights for the team.

What You Do

• Portfolio Analytics: support the monitoring and analysis of ALM portfolios, including Profit & Loss (P&L), issuer limits, PV01, CS01, and other key portfolio risk metrics
• Financial Modelling: develop, maintain, and enhance financial models used for portfolio analysis, scenario assessment, and investment decision support
• Process Automation: build and maintain VBA- and Python-based tools to improve workflow efficiency, automate reporting processes, and strengthen analytical capabilities
• Dashboard Development: create and enhance Tableau dashboards and analytics tools to provide actionable insights on portfolio performance, market developments, and investment opportunities
• Data Mining & Analysis: analyse market data, economic indicators, and company financial information to support portfolio monitoring and investment research
• Predictive Analytics: support forecasting, trend analysis, and predictive modelling initiatives to identify potential risks and opportunities
• Market Research: monitor financial markets and industry developments to generate insights and support the evaluation of trade and investment ideas
• Reporting & Administrative Support: assist in preparing management reports, portfolio updates, presentations, and other materials required for business reviews and decision‑making
• Ad‑hoc Projects: provide support on strategic initiatives, data analytics projects, and process improvement activities as assigned

Who You Work With

The Asset Liability Management Portfolio Intelligence Unit supports the management of the bank's investment portfolios through analytics, research, risk monitoring, and data‑driven insights. You'll work alongside portfolio managers, treasury professionals, and analysts who oversee balance sheet investments and portfolio risk management. Through this role, you'll gain valuable exposure to portfolio management, financial markets, treasury activities, and the analytical tools that support investment decision‑making within a leading financial institution.

Who You Are

• Open to learning and feedback
• Strong interest in financial markets, economics, and portfolio management
• Good understanding of financial modelling and market concepts
• Strong analytical and quantitative skills
• Proficient in Microsoft Excel with experience in VBA and Python programming
• Familiarity with Tableau and dashboard development
• Knowledge of data analytics, predictive modelling, and forecasting techniques
• Comfortable working with large datasets and performing quantitative analysis
• Able to work independently and manage multiple priorities effectively
• Good communication and interpersonal skills
• Detail‑oriented with a strong problem‑solving mindset
• Currently pursuing an undergraduate or postgraduate degree

Learning Objectives

• Exposure to portfolio management and balance sheet analytics within a leading financial institution
• Hands‑on experience monitoring portfolio performance and key risk measures such as issuer limits, PV01, and CS01
• Opportunities to develop financial modelling, forecasting, and quantitative analysis skills
• Experience building automation tools and analytical solutions using VBA, Python, and Tableau
• Exposure to market research, economic analysis, and investment idea generation
• Opportunities to develop dashboarding, business intelligence, and data visualisation capabilities
• Experience applying data analytics and predictive modelling techniques to real‑world financial datasets
• Exposure to collaboration with portfolio managers, treasury professionals, and business stakeholders
• A deeper understanding of how data, technology, and market intelligence support portfolio management and risk oversight within Global Markets
• Practical experience contributing to strategic initiatives that enhance decision‑making, efficiency, and portfolio performance across the business

What we offer

• Competitive base salary.
• A suite of holistic, flexible benefits to suit every lifestyle.
• Community initiatives.
• Industry‑leading learning and professional development opportunities.
• Your wellbeing, growth and aspirations are every bit as cared for as the needs of our customers.

Lets build the bank we need for the future we want.

Find the best version of yourself in a friendly, supportive team.

Build lasting value in your community.

Help people grow their assets, business, and investments.

Take your learning as far as you can.

Or simply enjoy a vibrant, future-ready career.

Your Opportunity Starts Here

As the longest established Singapore bank, formed in 1932 from the merger of three local banks, we have grown from strength to strength to become a regional financial services group. With a deep history in Asia, we offer the most comprehensive coverage across ASEAN and Greater China, complemented with a presence in the leading economies of New York, London and Sydney. We are the second largest financial services group in Southeast Asia by assets with one of the world’s highest credit rating (Aa1 by Moody’s and AA- by both Fitch and S&P). We offer private banking services through our wholly‑owned subsidiary, Bank of Singapore, which operates on a unique open‑architecture product platform to source for the best‑in‑class products to meet its clients’ goals. Our insurance subsidiary, Great Eastern Holdings, is the oldest and most established life insurance group in Singapore and Malaysia.