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

Maltem Asia-Pacific; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Maltem Asia-Pacific is seeking a Senior Data Engineer to design, build, and optimize scalable ETL/ELT pipelines using Microsoft Azure and Microsoft Fabric for an Investment Services client.

You will develop Lakehouse, Data Warehouse, and data models for investment, portfolio, and risk analytics, and integrate data via APIs, SFTP, and file-based interfaces while ensuring data quality, governance, and reconciliation.

Qualifications

• Senior Data Engineer with hands-on experience in investment data environments.
• Proven expertise in Azure and Fabric-based data platforms.
• Experience building and optimizing ETL/ELT pipelines.

Responsibilities

• Design, build, and optimize scalable ETL/ELT pipelines on Azure.
• Develop and maintain Lakehouse, Data Warehouse, and data models for investment analytics.
• Integrate data from APIs, SFTP, and file-based sources with governance.
• Build data pipelines for portfolio holdings, pricing, NAV, and analytics datasets.
• Optimize SQL queries and data processing for performance.
• Collaborate with business and technology teams to deliver scalable data solutions.
• Support testing, deployment, monitoring, and platform improvements.

Skills

Senior Data Engineer

Microsoft Azure

Microsoft Fabric

ETL/ELT pipelines

SQL

Python

Investment Management domain

Data Warehouses/Lakehouse

APIs / SFTP / file-based integrations

Tools

Azure Data Factory

Lakehouse

OneLake

Data Warehouse

Job description

Maltem Asia is seeking a Data Engineer for 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 interfaces, 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.