Senior SQL Developer (with Capital markets exp)

Role-Senior SQL Developer (with Capital markets exp)
Duration-Contract
Location-Remote (Canada)

Project description
Building a risk applications and tools for innovative international top-tier hedge fund from the ground up, comprising the systems for traders, pre-trade checks and analysis, risks and limits management, reports of trading activities, FIX connectivity, market data providers connectivity (e.g. Bloomberg B-pipe), etc

Responsibilities
The Team is focused on the development and maintenance of various database applications supporting Risk Management. The successful candidate will have considerable and proven experience in database design, Microsoft T-SQL developer, a good working knowledge of end-user and server-side data processing techniques, a good understanding of SDLC and agile development methodologies.

Skills
Must have
Strong understanding of data modelling and data quality principles
Experience across data architecture and data warehousing techniques and practices is essential.
Proven experience in designing and developing data models using industry best practices
Experience in using code management and CI/CD tools such as Github, Azure Devops, Jenkins, Bamboo etc.
5+ years of experience working with ETL tools such as SSIS, ADF or similar.
Good understanding and demonstrated experience working with Power Query (M query language) and DAX.
Extensive experience designing and developing reports and performance metrics from complex and disparate platforms

Nice to have
Risks trading system development experience.
Business knowledge in trading domain / capital markets Good
understanding and demonstrated experience working with Power Query (M query language) and DAX. Experience in using code management and CI/CD tools such as Github, Azure Devops, Jenkins, Bamboo etc.