Solution & Data Architect for Data Warehouse Implementation
Implement data architecture and manage investment data for a financial data warehouse.
Overview
Implement data architecture and manage investment data for a financial data warehouse.
You have:
- An Advanced degree in a business or technical field such as finance, Economics, Engineering, Computer Science, Information Systems, Mathematics, Statistics or a related field.
- A first-level university degree in combination with qualifying experience is acceptable in lieu of the advanced university degree.
- Minimum 7 years in the investment industry.
- 5 years in implementing investment data platforms.
- 3 years with S&P Markit EDM is required.
- Deep understanding of investment data lifecycle.
- Strong technology knowledge and ability to influence various partners is required.
- Strong record of customer service and excellent communication and relationship-building skills is required.
- Thorough understanding of the investment life cycle across all asset classes.
- Experience with market data vendors like Bloomberg, MSCI, Reuters is required.
- Working knowledge of end-to-end data management workflows.
- Experience with EDM aspects, BI, and reporting is required.
- Fluency in English is required.
- Knowledge of another UN official language is desirable.
Contract
This is a Consultancy contract. More about Consultancy contracts.
Result of Service
Business requirements for the data warehouse Document current state data architecture and potential sources of data. Assist vendor with integration of their Financial Data Warehouse Document testing of new systems as they become available.
Work Location
New York
Expected duration
6 months
Duties and Responsibilities
The United Nations Secretary-General is responsible for the investment of the assets of the United Nations Joint Staff Pension Fund (UNJSPF). The Secretary-General has delegated this responsibility to the Representative of the Secretary-General for the investment of the assets of the UNJSPF (RSG). The RSG heads the Office of Investment Management (OIM), which manages a $90+ billion multi-asset class, global investment portfolio, about 85% of which is actively managed in-house. Asset classes under management comprise global equities, fixed income, foreign exchange, private equity, real estate, infrastructure, timber and commodities. OIM's staff are all based in New York but come from over 30 countries. For more information please visit OIM's website at https://oim.unjspf.org/. This position is located in the Data Analysis and Business Applications Team of OIM. The consultant will report to the Business Applications IT Project Manager at the Office of Investment Management (OIM) of the United Nations Joint Staff Pension Fund (UNJSPF) and work under his overall guidance. Through this reporting arrangement, the contractor will implement the deliverables described in this Terms of Reference (TOR) in consultation with the IT Project Manager.
Qualifications/special skills
An Advanced degree in a business or technical field such as finance, Economics, Engineering, Computer Science, Information Systems, Mathematics, Statistics or a related field. A first-level university degree in combination with qualifying experience is acceptable in lieu of the advanced university degree. Industry certification such as the CPA or CFA is a plus. Minimum 7 years in the investment industry, 5 years in implementing investment data platforms, and 3 years with S&P Markit EDM is required. Deep understanding of investment data lifecycle, and strong technology knowledge and ability to influence various partners is required. Strong record of customer service and excellent communication and relationship-building skills is required. Thorough understanding of the investment life cycle across all asset classes, and experience with market data vendors like Bloomberg, MSCI, Reuters is required. Working knowledge of end-to-end data management workflows, and experience with EDM aspects, BI, and reporting is required
Languages
English and French are the working languages of the UN Secretariat. For this position, fluency in English is required. Knowledge of another UN official language is desirable.
Additional Information
Not available.
No Fee
THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.
Potential interview questions
| Can you describe your experience with investment data platforms? | This question assesses your relevant experience in implementing data solutions for the investment industry. | Provide specific examples of platforms you've implemented and your role in the process. |
| How do you approach integrating new data sources into existing systems? | The interviewer wants to understand your integration strategies for financial data warehouses. | Pro members can see the explanation. |
| What challenges have you faced while managing investment data and how did you overcome them? | Pro members can see the explanation. | Pro members can see the explanation. |
| Can you explain your understanding of the investment data lifecycle? | Pro members can see the explanation. | Pro members can see the explanation. |
| What technologies are you familiar with that support data management in investment? | Pro members can see the explanation. | Pro members can see the explanation. |