Data Engineer (MSfabric / Azure / SQL / Python / RestAPI / Bloomberg)

MALTEM ASIA PTE. LTD.; Singapore; On-site; SGD 150,000 - 210,000; Full time

Job summary

Maltem Asia is seeking a Senior Data Engineer for our Investment Services client to design, build, and optimize scalable ETL/ELT pipelines on Microsoft Azure and Microsoft Fabric. You will develop and maintain Lakehouse, Data Warehouse, and data models for investment analytics, and integrate data from APIs, SFTP, and file-based interfaces to ensure data quality and governance.

Responsibilities include building data pipelines for portfolio holdings, positions, pricing, NAV, benchmarks, and

Qualifications

• Minimum 7+ years hands-on experience as a Senior Data Engineer.
• Strong expertise in Microsoft Azure & Microsoft Fabric (Data Factory, Lakehouse, OneLake, Data Warehouse).
• Extensive experience building ETL/ELT pipelines, data lakes, and enterprise data warehouses.
• Proficiency in SQL and Python.
• Experience in Investment Management, Asset Management, Wealth Management, or Portfolio Management domains.
• Good understanding of investment data including portfolio holdings, positions, security master, pricing, NAV, benchmarks, and risk analytics.
• Knowledge of enterprise investment platforms such as BlackRock Aladdin, MSCI BarraOne, Bloomberg, FactSet, SimCorp, Charles River IMS is desirable.
• Experience with REST APIs, SFTP, and file-based data integrations.
• Strong knowledge of data modeling, data quality, governance, and cloud-based data platforms.
• Excellent analytical, stakeholder management, and communication skills.

Responsibilities

• Design, build, and optimize scalable ETL/ELT pipelines using Microsoft Azure and Microsoft Fabric.
• Develop and maintain Lakehouse, Data Warehouse, and data models for investment analytics.
• Integrate data from multiple sources using APIs, SFTP, and file-based interfaces, ensuring data quality and governance.
• Build and support data pipelines for portfolio holdings, positions, pricing, NAV, benchmarks, and analytics datasets.
• Optimize SQL queries, data processing, and platform performance.
• Collaborate with business and technology teams to deliver scalable data engineering solutions.
• Support testing, deployment, production monitoring, troubleshooting, and continuous improvements.

Skills

Senior Data Engineer

ETL/ELT pipelines

Data modeling

Data governance

SQL proficiency

Python proficiency

Investment Management domain

Stakeholder management

Analytics

Tools

Microsoft Azure

Microsoft Fabric

Data Factory

Lakehouse

Data Warehouse

OneLake

REST APIs

SFTP

File-based interfaces

Job description

Maltem Asia is seeking aData Engineerfor our Investment Services client.

Responsibilities:

• Design, build, and optimize scalable ETL/ELT pipelines using Microsoft Azure & Microsoft Fabric.
• Develop and maintain Lakehouse, Data Warehouse, and data models for investment, portfolio, and risk analytics.
• Integrate data from multiple internal and external sources using APIs, SFTP, and file-based SQLinterfaces, ensuring data quality, validation, reconciliation, and governance.
• Build and support data pipelines for portfolio holdings, positions, security master, pricing, NAV, benchmarks, and analytics datasets.
• Optimize SQL queries, data processing, and platform performance.
• Collaborate with business and technology teams to deliver scalable data engineering solutions.
• Support testing, deployment, production monitoring, troubleshooting, and continuous platform improvements.

Skillset Requirements:

• Minimum 7+ years of hands-on experience as a Senior Data Engineer.
• Strong expertise in Microsoft Azure & Microsoft Fabric (Data Factory, Lakehouse, OneLake, Data Warehouse).
• Strong experience building ETL/ELT pipelines, data lakes, and enterprise data warehouses.
• Proficiency in both SQL & Python.
• Experience in Investment Management, Asset Management, Wealth Management, or Portfolio Management domains.
• Good understanding of investment data, including portfolio holdings, positions, security master, pricing, NAV, benchmarks, and risk analytics.
• Knowledge of enterprise investment platforms such as:
• BlackRock Aladdin
• MSCI BarraOne
• Bloomberg
• FactSet
• SimCorp
• Charles River IMS, or equivalent is highly desirable.
• Experience with REST APIs, SFTP, and file-based data integrations.
• Strong knowledge of data modeling, data quality, governance, and cloud-based data platforms.
• Excellent analytical, stakeholder management, and communication skills.