Data Engineer/Analyst (Python/SQL)

About the job
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 SQLImplement and maintain Snowflake data warehouses with performance-optimized structuresDevelop automated Power BI dashboards with actionable insightsTransform complex investment data into clean, analysis-ready formatsCollaborate with quantitative analysts and portfolio managers to understand data needsImplement Azure-based data solutions (Data Factory, Databricks, Synapse)Ensure data quality and governance across all deliverablesTechnical 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 experienceEducation:

Bachelor’s or Master’s in Computer Science, Engineering, or a quantitative fieldFinance-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: https://directitrecruiting.com/job/data-specialist-contract-hybrid-1706/