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

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