Senior Data Engineer – Capital Markets

Hiring: Senior Data Engineer – Capital Markets

📍 Location: Mississauga, ON, Canada

🏢 Work Model: Hybrid

💼 Experience: 8+ Years

We are looking for an experienced Senior Data Engineer with strong Capital Markets, SQL, Data Warehousing, and Snowflake expertise to join our technology team in Mississauga.

The ideal candidate will have hands-on experience building scalable data pipelines, optimizing cloud data warehouses, and processing complex financial datasets supporting trading, risk management, market data, and regulatory reporting.

🔑 Must-Have Skills

• Capital Markets domain knowledge — trading, securities, equities, fixed income, derivatives, market data, or risk management
• Expert SQL — complex queries, joins, window functions, stored procedures, and performance tuning
• Snowflake — hands-on development, data loading, optimization, Snowpipe, Streams, and Tasks
• Data Warehousing — dimensional modeling, Star/Snowflake schemas, data marts, and historical data management
• Python / PySpark — ETL/ELT pipelines, large-scale data processing, data validation, and automation
• 8+ years of experience in Data Engineering, Data Warehousing, or related roles

Key Responsibilities

• Design and optimize enterprise-scale data pipelines and Snowflake data warehouse solutions.
• Develop complex SQL queries, data transformations, and ETL/ELT frameworks.
• Build scalable data models for analytics, financial reporting, and regulatory compliance.
• Ensure data quality, governance, security, and data integrity.
• Collaborate with business analysts, trading teams, risk teams, and other stakeholders.
• Troubleshoot performance issues and support production deployments.

Nice to Have

• SSIS development and support
• Legacy ETL migration to cloud data platforms
• Experience scheduling and monitoring ETL workflows