Lead Data Architect

Building risk applications and tools for an innovative international top-tier hedge fund from the ground up, comprising systems for traders, pre-trade checks and analysis, risk and limits management, reports of trading activities, FIX connectivity, and market data providers connectivity (e.g., Bloomberg B-pipe). The team focuses on the development and maintenance of various database applications supporting Risk Management.

The successful candidate will have considerable and proven experience in database design, PL/SQL development, a good working knowledge of end-user and server-side data processing techniques, and a good understanding of SDLC and agile development methodologies.

Responsibilities:

1. Developing business-friendly data models.
2. Migration from SQL Server to Fabric and/or Azure.

Mandatory Skills:

1. Strong understanding of data modeling and data quality principles.
2. Experience across data architecture and data warehousing techniques and practices is essential.
3. Proven experience in designing and developing data models using industry best practices.
4. Experience in using code management and CI/CD tools such as GitHub, Azure DevOps, Jenkins, Bamboo, etc.
5. Senior (10+ years) MS SQL Server developer/architect.
6. Azure Fabric service experience.
7. 10+ years of experience working with ETL tools such as SSIS, ADF, or similar.
8. Good understanding and demonstrated experience working with Power Query (M query language) and DAX.
9. Management of Power BI datasets, workspaces, and the associated security requirements.
10. Familiarity with Power BI Premium capabilities, Power BI REST APIs, Python, and Databricks will be highly regarded.
11. Extensive experience designing and developing reports and performance metrics from complex and disparate platforms.

Nice-to-Have Skills:

1. Experience with Azure.
2. Risk trading system development experience.
3. Business knowledge in the trading domain/capital markets.

Languages:

English: B2 Upper Intermediate