Senior Data Engineer – Capital Markets
- Mississauga, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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
More about this job
Responsibilities
Design and optimize enterprise-scale data pipelines, Snowflake data warehouse solutions, and data models for analytics, financial reporting, and regulatory compliance. Maintain data quality, governance, security, and integrity; collaborate with business and trading stakeholders; and troubleshoot performance issues and support production deployments.
Requirements
Requires 8+ years of experience in data engineering, data warehousing, or a related role, with expertise in capital markets, SQL, Snowflake, and data warehousing. Hands-on Python or PySpark experience building ETL/ELT pipelines, processing large datasets, validating data, and automating workflows is also required.
Skills
- Capital Markets
- SQL
- Snowflake
- Data Warehousing
- Python
- PySpark
- ETL/ELT
- Data Pipelines
- Dimensional Modeling
- Data Modeling
- Data Quality
- Data Governance
- Performance Tuning
- SSIS
- Workflow Scheduling and Monitoring
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
- Software
Keywords
- Capital Markets
- Trading
- Securities
- Equities
- Fixed Income
- Derivatives
- Market Data
- Risk Management
- Regulatory Reporting
- SQL
- Snowflake
- Snowpipe
- Streams
- Tasks
- Data Warehousing
- Dimensional Modeling
- Star Schema
- Snowflake Schema
- Data Marts
- Historical Data Management
- Python
- PySpark
- ETL
- ELT
- Data Pipelines
- Data Validation
- Data Quality
- Data Governance
- SSIS
- Cloud Data Platforms