Maltem Asia is seeking a Data Engineer for our Asset Management 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:
- MUST HAVE strong exposure and hands-on experience in managing data within the Asset Managementor Financial Markets domain.
- Strong hands-on experience using SQL as a core tool for complex window functions (PARTITION BY), stored procedures, indexing strategies, recursive queries, and query plan analysis.
- 5 to 8 years as a Data Engineer.
- Strong expertise in Microsoft Azure and Microsoft Fabric (Data Factory, Lakehouse, OneLake, Data Warehouse).
- Strong experience using Python.
- Strong experience building ETL/ELT pipelines, data lakes, and enterprise data warehouses
- 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 a plus.
- 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.
