Job description for Data Engineer (MSfabric / Azure / SQL / Python / RestAPI / Bloomberg) at Maltem Group
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.
