Data Engineer Intern

Best Workplaces™ in Canada 2022 - 2026 | Best Workplaces™ with Most Trusted Executive Teams 2024 - 2026 | Best Workplaces™ in Financial Services & Insurance 2022 - 2026 | Best Workplaces™ for Mental Wellness 2023 - 2026 | Best Workplaces™ for Giving Back 2022 & 2024 | Best Workplaces™ for Inclusion 2021, 2024, 2026 | Best Workplaces™ for Women 2021 | Best Workplaces™ in Ontario™ 2024 - 2025 | Best Workplaces™ for Professional Development 2025  | Best Workplaces™ for Young Talent 2026  

One of Canada’s Most Trusted Investment Brands.

At Picton Mahoney Asset Management (PICTON Investments), being alternative isn’t just what we do, it’s who we are.

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

Thinking Alternatively is in Our DNA. 

With a team of 250 bold thinkers, one-third dedicated solely to investment management, we are specialists, not generalists. Managing $20.8 billion (October 31, 2026) for institutional and retail clients, we navigate markets with conviction, resilience, and a forward-thinking approach.

We’re more than investors we’re 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 human, always approachable.
• Succeed together, one investment at a time.

These aren’t just words. They define how we think, how we invest, and how we work. 

Now, we’re entering our next chapter. We’re 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 what’s next.

Thriving in Our Entrepreneurial Culture

At PICTON Investments, you’ll thrive in our creative and dynamic workplace, where collaboration and support are at the core of everything we do. At our firm, you’ll 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. You’ll 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, you’ll have everything you need to develop both now and over the longer term.

The Opportunity

PICTON Investments is presently seeking a dynamic Intern, Data Engineer with a passion about Asset Management to join our Digital Product team for an 8 month internship. The Intern will have the opportunity to gain hands-on experience in data transformation projects while supporting various business stakeholders across sales, investment, portfolio management, operations, compliance, HR, and marketing.

The expected hourly pay range for this internship position is $20.00 - $32.00. The final compensation offered within this range will be determined based on factors such as relevant education, skills, experience and internal equity.

You will have the opportunity to learn and lead:

• Assist in building and maintaining ETL (Extract, Transform, Load) or ELT
• Help automate data ingestion from multiple sources (APIs, databases, flat files, etc.).
• Support the implementation of data validation and quality checks.
• Work with data engineers and analysts to clean, structure, and transform raw data into usable formats.
• Write SQL or Python scripts to merge and transform datasets.
• Collaborate with different teams to understand data needs.
• Document workflows, data dictionaries, and processes.

What you bring:

• Currently pursuing in an undergraduate degree in STEM programs (Mathematics, Computer Science, Computer Engineering, Business or any other related discipline).
• Technical Proficiency: Understanding of SQL and experience with data modeling. Familiarity with Python, R, or other scripting languages is a plus.
• Data Pipeline Knowledge: Familiar with the concepts of ETL/ELT.
• Database Experience: Exposure to relational and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB) and understanding of data warehousing solutions (e.g., Redshift, Snowflake).
• Cloud Experience: Exposure to cloud platforms such as AWS, GCP, or Azure, particularly in relation to data storage (S3, BigQuery, etc.) and computing services.
• Data Visualization & Analysis: Any familiarity with data visualization tools (e.g., Tableau, Looker, Power BI).
• Problem Solving: Strong analytical and problem-solving skills with an ability to learn quickly and work independently.
• Communication: Strong verbal and written communication skills to collaborate effectively with technical and non-technical teams.
• Team-Oriented: Collaborative and able to work well in a dynamic, fast-paced team environment.

Our Commitment to Employees

At PICTON Investments, 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 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 Investments is committed to providing an equitable, fair, and accessible work environment for everyone. All hiring and other employment decisions are made without regard to race, colour, creed, religion, sex, disability, gender identity, gender expression, family status, age, language, or national origin. We welcome applications from candidates with diverse experiences from around the world, and Canadian work experience is not required. We are committed to providing an accessible recruitment process, with accommodations available upon request at any stage of the application and selection process. If you require an accommodation to support your participation, please contact Human Resources at (416) 955-4108 or [email protected].

PICTON Investments 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.

Please note: We use AI-assisted tools to support parts of our recruitment process, including summarizing interview notes and aligning candidate profiles with job requirements. All decisions are made by our hiring team.