NOTE: Hybrid Work Model, office located in Toronto. Work 2 days/week in office.

Status: 12-Month Contract, 8 hour work day, 40 hours/week

Work Experience: 3+ years data analyst, Python, SQL, Snowflake, Spark, Databricks, Power BI, Tableau, Azure, AWS, GCP

Industry: Bank, Finance

DESCRIPTION:

Overview:

The Data Specialist will partner with investment teams to deliver scalable data solutions that drive strategic decision-making. This role focuses on building robust data pipelines and analytical tools to support our investment platform.

Core Responsibilities:

• Design and optimize high-performance ETL pipelines using Python (Pandas) and SQL
• Implement and maintain Snowflake data warehouses with performance-optimized structures
• Develop automated Power BI dashboards with actionable insights
• Transform complex investment data into clean, analysis-ready formats
• Collaborate with quantitative analysts and portfolio managers to understand data needs
• Implement Azure-based data solutions (Data Factory, Databricks, Synapse)
• Ensure data quality and governance across all deliverables

Technical Requirements:

• 5+ years of production experience with:
• Python (ETL/automation focus)
• SQL (complex query optimization)
• Snowflake (including streams/tasks/clustering)
• Power BI (DAX, data modelling)
• Strong Azure cloud expertise (ADF required; Databricks preferred)
• Financial services data experience (asset management preferred)

Preferred Qualifications:

• Experience with investment data systems (Bloomberg, FactSet)
• Knowledge of financial regulations (PIPEDA, SEC compliance)
• Agile development methodology experience

Education:

• Bachelor's or Master's in Computer Science, Engineering, or a quantitative field
• Finance-related coursework or certification a plus

We openly welcome and invite applications from persons with disabilities or those protected by the human rights code and, upon request, provide accommodation during all stages of the recruitment and hiring process.

Please note that AI is used to assist in the recruiting process.

To Apply: