Senior SQL Developer with Capital Markets

CG Consulting Group; Remote; CAD 90,000 - 130,000; Full time

Job summary

A global IT services firm seeks a Senior Database Developer for a remote position in Canada, focused on building risk applications for a top-tier hedge fund. Candidates should have over 5 years of experience in database design and tools like Microsoft T-SQL and KQL. The role involves developing applications supporting Risk Management, utilizing best practices in data modelling, and engaging with varied data processing techniques. A hands-on approach with ETL tools is essential, along with a good understanding of agile methodologies.

Responsibilities

• Develop and maintain database applications for Risk Management.
• Design data models using industry best practices.
• Develop reports and performance metrics from complex platforms.

Skills

Data modelling principles

Microsoft Fabric

Kusto Query Language (KQL)

Data architecture techniques

Data warehousing best practices

Code management tools (Github, Azure DevOps)

ETL tools (SSIS, ADF)

Power Query (M query language)

DAX

Report development

Job description

Senior Database Developer with Capital Markets

This is with a global IT services firm for an international top-tier hedge fund. Work will be remote, WFM in Canada. Contract - 6 months, possible renewal.

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.

Mandatory Skills

• Strong understanding of data modelling and data quality principles
• Hands‑on exp with Microsoft Fabric
• Extensive experience with Kusto Query Language (KQL)
• 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 Skills

• Risks trading system development experience.
• Business knowledge in trading domain / capital markets Good