Great Place to Work 2020 - 2025 | Best Workplaces with Most Trusted Executive Teams 2024, 2025 | Best Workplaces in Financial Services & Insurance 2020 - 2024 | Best Workplaces for Mental Wellness 2023, 2024 | Best Workplaces for Giving Back 2022, 2024 | Best Workplaces for Inclusion 2024 | Best Workplaces in Ontario 2024

One of Canadas Most Trusted Investment Brands.

At Picton Mahoney Asset Management, being alternative isnt just what we doits who we are.

Founded by industry pioneer David Picton, weve spent 20 years challenging conventional wisdom and redefining the investing landscape. As one of Canadas most trusted investment brands, we are proudly independentprivately run, 100% employee-owned, and deeply committed to delivering results for our clients.

Thinking Alternatively is in Our DNA.

With a team of 160 bold thinkersone-third dedicated solely to investment managementwe are specialists, not generalists. Managing $13.6 billion for institutional and retail clients, we navigate markets with conviction, resilience, and a forward-thinking approach.

Were more than investors were innovators. We challenge traditional investment mindsets, constantly pushing the boundaries to achieve our mission: To bring greater certainty to investors.

Our success is built on four guiding principles:

Treat investors money like our own.

Redefine the way investors invest.

Be humanalways approachable.

Succeed together, one investment at a time.

These arent just wordsthey define how we think, how we invest, and how we work.

Now, were entering our next chapter. Were transforming our brand and reshaping the way the world invests. If you think alternatively, embrace an entrepreneurial spirit, and thrive in a dynamic, bureaucracy-free environment, join us and be part of whats next.

Thriving in Our Entrepreneurial Culture

At Picton Mahoney, youll thrive in our creative and dynamic workplace, where collaboration and support are at the core of everything we do. At our firm, youll have the opportunity to take on significant responsibilities, work in a flexible environment, and tackle challenging projects from the outset. Our culture is designed for ambitious professionals who want to make an immediate impact while continuing to push boundaries and achieve our greater mission. Youll be empowered with a high level of responsibility, trust, and flexibility, providing an exciting and creative space for you to help reshape how the world views alternative investments. With competitive total rewards, performance-based bonuses, and a clear path for career growth, youll have everything you need to develop both now and over the longer term.

The Opportunity

Picton Mahoney Asset Managementis presently seeking a Data Engineer to join the newly formed Data team. Using your excellent communication skills, you are capable of conversing with both technical and non-technical colleagues and are comfortable contributing to a highly multidisciplinary team. If you believe that you are a true techie at heart and feel empowered working on innovative technology that makes a difference, this could be the opportunity for you!

Leveraging a rich knowledge of Azure cloud and SQL database design and multiple programming languages, the Data Engineer will be responsible for designing, building, and optimizing systems for data collection, storage, and analytics at scale. The successful incumbent will play a crucial role in collecting, managing, and converting raw data into high quality and high impact pipelines as well as constructing dataset procedures that will have an immediate and transformative impact on the business.

The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Data Engineer will support our software developers, database architects, data product owners, web solutions architect and others on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or re-designing our companys data architecture to support our next generation of products and data initiatives. This opportunity requires a successful candidate to work in a flexible hybrid model out of our head office in Toronto, Ontario.

Youll have the opportunity to lead and learn:

• Design, develop, and maintain ETL pipelines.
• Automate data ingestion from different data sources.
• Assemble large, complex data sets that meet functional 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 that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Development teams to assist with data-related technical issues and support their data needs.
• Document data flows, architecture, and pipeline dependencies.
• Provide support for troubleshooting and optimizing queries/pipelines.

What were looking for

• The ideal candidate will have 5+ years of experience in a Data Engineer role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• Certifications: Azure Certifications preferred
• Advanced working MS-SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience building and optimizing big data data pipelines and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Experience on designing and developing scripts for custom ETL processes and automation in Azure data factory, Azure data bricks, Snowflake, Python, Pyspark etc.
• Good knowledge of AZURE Cloud platform services stack - Azure Data Factory, Azure SQL Database, AZURE Data Warehouse, Azure data bricks, Snowflake, Azure Blob Storage, Azure Data Lake Storage, HD Insight, Cosmos DB, etc.
• Experience using the following software/tools:
  • Big data tools: Hadoop, Spark, Kafka, etc.
  • MS-SQL
  • Azure cloud services
  • Data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
  • Object-oriented/object function scripting languages: C#, python.
    

Our Commitment to Employees

At Picton Mahoney Asset Management, we take pride in enhancing our employees' experiences through a comprehensive suite of exceptional perks and programs. Our benefits include corporate fitness reimbursement and discounts, VersaFi memberships (formerly Women in Capital Markets), Picton Wealth investment counseling and portfolio management services, volunteer and charitable donation matching, maternity and parental leave top-up, recognition awards, semi-annual performance bonuses, a generous annual vacation entitlement (minimum of 15 days per year), training and development reimbursement, extensive health and dental benefits, a healthcare spending account, and more.

These offerings are designed to support your career growth, well-being, and overall success. Join us and thrive in an environment that values and invests in you!

Picton Mahoney Asset Management is committed to providing an equitable and fair work environment for everyone and all hiring and other personnel actions will be taken without regard to race, colour, creed, religion, sex, disability, gender identity, gender expression, family status, age, language or national origin. If you require an accommodation at any point in time throughout the application and hiring process, please contact Human Resources at (416) 955-4108 or at [email protected]
.

Picton Mahoney Asset Management does not accept unsolicited resumes, emails, calls, or any other form of communication from third-party recruitment agencies. Any unsolicited outreach, including commercial electronic messages, will neither be acknowledged nor considered.

Job Posting Closing Date: Wednesday, March 19th at 5:00 PM EST

Please note that while we carefully review each application, only those candidates selected for further consideration will be contacted. We wish you all the best in your job search and future endeavors.