Top Benefits
About the role
Data Engineer
📍 Toronto, ON | Hybrid
Recognized as one of Canada’s Best Workplaces™
- Best Workplaces in Canada (2020-2025)
- Most Trusted Executive Teams (2024, 2025)
- Best Workplaces for Mental Wellness (2023-2025)
- Best Workplaces for Professional Development (2025)
- …and many more.
Why Join Us?
At Picton Mahoney Asset Management (PICTON Investments) , we think differently. For 20+ years, we’ve been proudly independent, 100% employee-owned, and trusted with $15.9B in assets . We’re more than investors — we’re innovators — and our culture is built for people who want to challenge convention and make an impact.
Perks & Benefits:
✔ Competitive pay + semi-annual performance bonus
✔ Minimum 15 vacation days + maternity/parental leave top-up
✔ Comprehensive health & dental + healthcare spending account
✔ Employee investment counseling & portfolio management
✔ Training & development reimbursement + VersaFi memberships
✔ Volunteer matching, donation programs & recognition awards
The Opportunity
PICTON Investments is seeking a skilled Data Engineer to join our newly formed Data team. If you’re a tech enthusiast who thrives on innovation and enjoys turning complex data into actionable insights, this is the role for you. You will collaborate with both technical and non-technical colleagues in a highly multidisciplinary team, contributing to projects that make a real business impact.
As a Data Engineer, you will leverage your expertise in Azure Databricks, Snowflake, Azure Cloud, SQL, and programming languages to design, build, and optimize large-scale systems for data collection, storage, and analytics. Your work will directly influence high-quality pipelines and datasets that support critical business decisions.
You’ll have the opportunity to lead and learn:
- Design, develop, and maintain ETL pipelines .
- Automate data ingestion from multiple sources.
- Assemble large, complex datasets that meet business requirements.
- Optimize workflows for performance, scalability, and reliability .
- Implement data validation, deduplication, and integrity checks .
- Optimize query performance and ensure cost-efficient data storage.
- Manage data lakes, warehouses, marts, and databases .
- Build analytics tools to deliver actionable insights into customer acquisition, operational efficiency, and business performance metrics.
- Collaborate with stakeholders including Executive, Product, Data, and Development teams to solve data-related challenges.
- Document data flows, architecture, and pipeline dependencies.
- Support troubleshooting and optimization of queries and pipelines.
What we’re looking for
- Experience: 7+ years as a Data Engineer, preferably with a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
- Technical Skills:
- Designing and developing custom ETL processes using Azure Data Factory, Azure Databricks, Snowflake, Python, PySpark .
- Advanced MS-SQL and relational database experience.
- Experience designing and optimizing big data pipelines and datasets.
- Experience with big data tools : Hadoop, Spark, Kafka.
- Knowledge of Azure Cloud services including Data Factory, SQL Database, Data Warehouse, Blob Storage, Data Lake Storage, HDInsight, Cosmos DB, etc.
- Familiarity with data pipeline and workflow tools : Azkaban, Luigi, Airflow.
- Proficiency in object-oriented scripting languages such as Python or C#.
Soft Skills:
- Excellent communication skills for technical and non-technical stakeholders.
- Comfortable supporting multiple teams, systems, and products simultaneously.
- Self-directed with a proactive approach to solving complex data challenges.
Certifications: Azure certifications preferred.
Ready to Think Differently?
Join a workplace that invests in you — and help us reshape how Canadians invest.
👉 Apply now to be part of our next chapter.
About PICTON Investments
PICTON Investments is a Canadian investment firm with over $13 billion in assets under management, recognized for pioneering alternative investment strategies that challenge traditional thinking. Since 2004, we have been helping advisors and investors rethink portfolio construction by moving away from traditional models toward more resilient, diversified solutions. Leveraging deep expertise in quantitative research, fundamental analysis, and authentic hedging strategies, we champion a modern approach designed to deliver more consistent, risk-adjusted returns. Our philosophy is to “Build from the Bear Up,” embracing a bear mindset of resiliency, adaptability, and strength to provide Canadians with greater certainty.
Commissions, trailing commissions, management fees, performance fees and expenses all may be associated with mutual fund investments. Please read the prospectus before investing. Mutual funds are not guaranteed, their values change frequently and past performance may not be repeated.
This LinkedIn Account is monitored by Picton Mahoney Asset Management (“PMAM”) and its service providers for the purposes of assessing and ensuring compliance with applicable laws and regulatory requirements and to evaluate reactions to, and interactions with, postings about PMAM and its business so that PMAM may improve its products, services and marketing activities. By posting or transmitting any personal information on or to this LinkedIn Account, you are consenting to PMAM’s collection, use and disclosure of your information for such purposes and any other purposes required or permitted by applicable law. See our Privacy Policy at www.pictonmahoney.com/privacy-policy/ and our social media terms at www.pictonmahoney.com/social-media-terms/
Top Benefits
About the role
Data Engineer
📍 Toronto, ON | Hybrid
Recognized as one of Canada’s Best Workplaces™
- Best Workplaces in Canada (2020-2025)
- Most Trusted Executive Teams (2024, 2025)
- Best Workplaces for Mental Wellness (2023-2025)
- Best Workplaces for Professional Development (2025)
- …and many more.
Why Join Us?
At Picton Mahoney Asset Management (PICTON Investments) , we think differently. For 20+ years, we’ve been proudly independent, 100% employee-owned, and trusted with $15.9B in assets . We’re more than investors — we’re innovators — and our culture is built for people who want to challenge convention and make an impact.
Perks & Benefits:
✔ Competitive pay + semi-annual performance bonus
✔ Minimum 15 vacation days + maternity/parental leave top-up
✔ Comprehensive health & dental + healthcare spending account
✔ Employee investment counseling & portfolio management
✔ Training & development reimbursement + VersaFi memberships
✔ Volunteer matching, donation programs & recognition awards
The Opportunity
PICTON Investments is seeking a skilled Data Engineer to join our newly formed Data team. If you’re a tech enthusiast who thrives on innovation and enjoys turning complex data into actionable insights, this is the role for you. You will collaborate with both technical and non-technical colleagues in a highly multidisciplinary team, contributing to projects that make a real business impact.
As a Data Engineer, you will leverage your expertise in Azure Databricks, Snowflake, Azure Cloud, SQL, and programming languages to design, build, and optimize large-scale systems for data collection, storage, and analytics. Your work will directly influence high-quality pipelines and datasets that support critical business decisions.
You’ll have the opportunity to lead and learn:
- Design, develop, and maintain ETL pipelines .
- Automate data ingestion from multiple sources.
- Assemble large, complex datasets that meet business requirements.
- Optimize workflows for performance, scalability, and reliability .
- Implement data validation, deduplication, and integrity checks .
- Optimize query performance and ensure cost-efficient data storage.
- Manage data lakes, warehouses, marts, and databases .
- Build analytics tools to deliver actionable insights into customer acquisition, operational efficiency, and business performance metrics.
- Collaborate with stakeholders including Executive, Product, Data, and Development teams to solve data-related challenges.
- Document data flows, architecture, and pipeline dependencies.
- Support troubleshooting and optimization of queries and pipelines.
What we’re looking for
- Experience: 7+ years as a Data Engineer, preferably with a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
- Technical Skills:
- Designing and developing custom ETL processes using Azure Data Factory, Azure Databricks, Snowflake, Python, PySpark .
- Advanced MS-SQL and relational database experience.
- Experience designing and optimizing big data pipelines and datasets.
- Experience with big data tools : Hadoop, Spark, Kafka.
- Knowledge of Azure Cloud services including Data Factory, SQL Database, Data Warehouse, Blob Storage, Data Lake Storage, HDInsight, Cosmos DB, etc.
- Familiarity with data pipeline and workflow tools : Azkaban, Luigi, Airflow.
- Proficiency in object-oriented scripting languages such as Python or C#.
Soft Skills:
- Excellent communication skills for technical and non-technical stakeholders.
- Comfortable supporting multiple teams, systems, and products simultaneously.
- Self-directed with a proactive approach to solving complex data challenges.
Certifications: Azure certifications preferred.
Ready to Think Differently?
Join a workplace that invests in you — and help us reshape how Canadians invest.
👉 Apply now to be part of our next chapter.
About PICTON Investments
PICTON Investments is a Canadian investment firm with over $13 billion in assets under management, recognized for pioneering alternative investment strategies that challenge traditional thinking. Since 2004, we have been helping advisors and investors rethink portfolio construction by moving away from traditional models toward more resilient, diversified solutions. Leveraging deep expertise in quantitative research, fundamental analysis, and authentic hedging strategies, we champion a modern approach designed to deliver more consistent, risk-adjusted returns. Our philosophy is to “Build from the Bear Up,” embracing a bear mindset of resiliency, adaptability, and strength to provide Canadians with greater certainty.
Commissions, trailing commissions, management fees, performance fees and expenses all may be associated with mutual fund investments. Please read the prospectus before investing. Mutual funds are not guaranteed, their values change frequently and past performance may not be repeated.
This LinkedIn Account is monitored by Picton Mahoney Asset Management (“PMAM”) and its service providers for the purposes of assessing and ensuring compliance with applicable laws and regulatory requirements and to evaluate reactions to, and interactions with, postings about PMAM and its business so that PMAM may improve its products, services and marketing activities. By posting or transmitting any personal information on or to this LinkedIn Account, you are consenting to PMAM’s collection, use and disclosure of your information for such purposes and any other purposes required or permitted by applicable law. See our Privacy Policy at www.pictonmahoney.com/privacy-policy/ and our social media terms at www.pictonmahoney.com/social-media-terms/