Sr SQL Developer - Capital Markets

CG Consulting Group; Canada; Remote; CAD 60,000 - 80,000; Full time

Job summary

A global IT services firm is seeking a Senior SQL Developer to contribute to risk applications for a prominent capital markets firm. This remote position requires extensive experience with data modeling, Microsoft Fabric, and ETL tools. Ideal candidates will have a strong background in database design and a passion for creating robust data solutions.

Qualifications

• 5+ years of experience with ETL tools such as SSIS, ADF or similar.
• Hands-on experience with Microsoft Fabric.
• Extensive experience designing and developing reports.

Responsibilities

• Development and maintenance of database applications supporting Risk Management.
• Work on risk applications and tools for capital markets.

Skills

Data modelling

Data quality principles

Microsoft Fabric

ETL tools (SSIS, ADF)

Power Query (M language)

DAX

CI/CD tools (GitHub, Azure DevOps)

Tools

Microsoft Fabric

MS Azure

Job description

Overview

Sr SQL Developer - Capital Markets (Data Analyst). This is with a global IT services firm for a leading US based hedge fund / Capital Markets firm.

Location: USA (remote work from home). Contract: 6 months, possible renewal.

Project description: Work on a team 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, risks and limits management, reports of trading activities, FIX connectivity, and market data providers connectivity (e.g., Bloomberg B-pipe). Experience with Microsoft Fabric - unified MS Cloud Analytics platform.

Responsibilities

• The team focuses on 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 development, a good working knowledge of end-user and server-side data processing techniques, and a good understanding of SDLC and agile development methodologies.

Qualifications

• Must have – Strong understanding of data modelling and data quality principles.
• Hands-on experience with Microsoft Fabric - unified MS Cloud Analytics platform.
• Experience across data architecture and data warehousing techniques and practices (eDW, Data Lake).
• Proven experience in designing and developing data models using industry best practices.
• Experience with code management and CI/CD tools (GitHub, Azure DevOps, Jenkins, Bamboo, etc.).
• 5+ years of experience with ETL tools such as SSIS, ADF or similar.
• Good understanding and demonstrated experience with Power Query (M language) and DAX.
• Extensive experience designing and developing reports and performance metrics from complex and disparate platforms.
• MS Azure.

Nice to have

• Risk/trading system development experience.
• Business knowledge in trading domain / capital markets.
• Solid understanding and demonstrated experience with Power Query (M language) and DAX.
• Experience with code management and CI/CD tools (GitHub, Azure DevOps, Jenkins, Bamboo, etc.).