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