Data Architect in Asset Management
Location: Switzerland, Zürich
This position demands a strong Architectural background on Data Analysis and experience on End-to-End large Enterprise level Project Delivery and Business Development in Asset Management.
As a Data Architect, you are supposed to perform the following tasks:
Technical Competencies - Data Architecture and Data Analysis
- Data Warehouse (NoSQL) setup and ETL implementation using MarkLogic DataHub Framework using XQuery module, Optic API , Rest API, Reporting and Performance Optimization, RDF Triples.
- MarkLogic Data integration experience with other BI/Analytical tools like Spark/Scala, QlikSense, Microsoft Power BI, Apache Nifi etc.
- Proven Data Management experience using Markit EDM CADIS – Design Data Management Solutions and workflows using Markit EDM components.
- NoSQL based Entity Modelling – Migrating Relational Data Model to NOSQL Semantic Data Model, Data Delivery using API, Rest API, Custom XQuery modules etc.
- Data Analytics by using Big Data Platform using Hadoop, Integration of MarkLogic & Hadoop as Tiered Storage.
- Design Tactical Solution on Data Migration from Oracle and MS SQL Server to MarkLogic for large volume of data.
- Several years of experience in financial industry experience in Data Science using Cython/Python/R.
Business Data Analysis & Reporting :
- Blackrock Aladdin Asset Management Integration, BRS Aladdin Interfaces and Modules, experience on Aladdin Integration on ADX, Green Package and Accounting Packages End to End.
- Integrate - Trade & Order management, Client Reporting Platform, Hedging, Settlement, Transaction processing, Swift, Cash management, Portfolio & Fund Accounting, Portfolio Performance & Attribution, Portfolio Optimization.
- Design and Integrate Client reporting and Mandate Billing Framework considering Fee Structure, Swiss Stamp Tax, Commission, Discount, Performance Management etc. for various types of Mandates.
- Client Reporting & Integration by using BMPI vCAIRE System.
- Establish Master Data Management – Data Model, Work Flow, Data Steward, Data Lineage, Data Governance, Exception Management between Blackrock Aladdin and other Marketdata Providers.
- Integrate Market Data from Several data providers ex: FACTSET, Reuters, Bloomberg, VDPS etc.
- Asset Management Data Integration, Data Archival and Data Quality Management.
As a Data Architect, you work closely with the Business and IT Key Stakeholders to identify their needs and Design & Deliver the target solutions. In addition, close interaction with all the associated Upstream/Downstream systems to deliver the product End-to-End. Furthermore, you interact with Software Consultants– in house and with outsourcing partners.
Requirements
- It requires minimum 10+ years development and delivery expertise in handling ETL process both in RDBMS and NoSQL Databases, ETL tools, Master Data Management, Must be experienced with Blackrock Aladdin Asset Management Data Integration and very strong Business knowledge on Swiss Banking Asset Management division.
- Must be experienced with - Trade & Order management, Client Reporting Techniques, Hedging, Settlement, Transaction processing, Swift, Cash Management, Portfolio & Fund Accounting, Portfolio Performance & Attribution, Portfolio Optimization.
- Strong organisational and analytical skills with disciplined and structured approach
- Excellent interpersonal andcommunicationskills
- Experience of managing complex and demanding Clients
- Experience in 3rd Party Vendor Implementations
- Modeling skills (Business Processes and Data Modelling)
- Degree in Information Systems or a related discipline or an equivalent combination of education and experience from which comparable knowledge and skills may be acquired