Closed listing
Data Engineer
- Mississauga, ON, Canada
Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Full-time
- Closing date
- Experience
- 10+ years of experience in Data Engineering, Data Warehousing, or related roles
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
🚨 Hiring: Data Engineer (SSIS) – Capital Markets
📍 Location: Mississauga, ON – Hybrid
🏢 Interview: In-person interview required
We are looking for an experienced Data Engineer to join our Capital Markets Technology team and help build and optimize enterprise-scale data platforms supporting trading, risk management, market data, securities, and regulatory reporting.
🔹 Key Responsibilities
- Design, develop, and maintain scalable data pipelines and data engineering solutions
• Build and optimize enterprise data warehouses using Snowflake
• Develop complex SQL queries, stored procedures, views, and transformation logic
• Build and support ETL/ELT frameworks for large-volume financial data
- Develop data models for reporting, analytics, and regulatory requirements
- Ensure data quality, integrity, governance, and security
- Troubleshoot and optimize database/data warehouse performance
- Collaborate with Business Analysts, Traders, Risk teams, and other data consumers
- Support production deployments and ongoing enhancements
- Create technical documentation, data lineage, and operational procedures
🔹 Required Qualifications
- Bachelor's degree in Computer Science, Engineering, Information Systems, or related field
• 10+ years of experience in Data Engineering, Data Warehousing, or related roles
• Strong Capital Markets / Financial Services domain experience
• Strong understanding of trading, market data, reference data, securities, equities, fixed income, derivatives, risk, or regulatory reporting
- Experience working in Agile environments
🔹 Must-Have Technical Skills
✅ Expert SQL – complex joins, analytical/window functions, stored procedures, performance tuning
✅ Snowflake – development, architecture, data loading, transformation, optimization
✅ Data Warehousing – dimensional modeling, Star/Snowflake schemas, Data Marts, historical data
✅ ETL/ELT – enterprise data integration and high-volume data pipelines
✅ Python / PySpark – data ingestion, transformation, API integration, validation, and Spark optimization
🛂 Work Authorization
• USC (U.S. Citizen) – Workable
• GC (Green Card) – Workable
• H-1B Transfer – Workable
• C2C – Only candidates with their own corporation
📩 Interested candidates can send their resume to:
bella.patel@talent-matics.com
Data Engineer | Senior Data Engineer | Lead Data Engineer | Snowflake | SQL | SSIS | ETL | ELT | Python | PySpark | Data Warehouse | Data Modeling | Capital Markets | Trading | Market Data | Securities | Risk Management | Financial Services
Please share your updated resume along with your location, work authorization, and availability.
More about this job
Responsibilities
Design, develop, and optimize scalable data pipelines, Snowflake data warehouses, and high-volume ETL/ELT solutions for capital markets data. Ensure data quality, security, and performance while supporting reporting and regulatory needs, production deployments, documentation, and collaboration with business and trading teams.
Requirements
Requires a bachelor's degree in a related field and 10 or more years of data engineering or data warehousing experience, including strong capital markets or financial services domain knowledge. Candidates should have expert SQL, Snowflake, data warehousing, ETL/ELT, and Python or PySpark skills, as well as experience working in Agile environments.
Skills
- SQL
- Snowflake
- Data Warehousing
- ETL/ELT
- Python
- PySpark
- SSIS
- Data Modeling
- Dimensional Modeling
- Data Pipeline Development
- Data Integration
- Performance Tuning
- Data Quality
- Capital Markets
- Financial Services
- Agile
Visa sponsorship
Not detected in the job text
Hiring contact
Bella Patel
Hiring contact email
bella.patel@talent-matics.com
Categories
- Data & Analytics
- Technology
- Software
- Finance & Accounting
Keywords
- Data Engineering
- Capital Markets
- Financial Services
- Snowflake
- SQL
- SSIS
- ETL
- ELT
- Python
- PySpark
- Data Warehousing
- Data Pipelines
- Data Integration
- Data Modeling
- Dimensional Modeling
- Star Schema
- Snowflake Schema
- Data Marts
- Data Loading
- Data Transformation
- Stored Procedures
- Window Functions
- Performance Tuning
- Data Quality
- Data Governance
- Data Security
- Trading
- Market Data
- Regulatory Reporting
- Agile