Intern, Data Engineer (8 Months)

Picton Mahoney; Toronto; Sur place; CAD 28 000 - 44 000; Plein temps

Avantages offerts par ce poste

Fitness reimbursement

VersaFi membership

Portfolio management services

Volunteer and charitable donation-math

Parental leave top-up

Performance bonuses

Vacation entitlement (min 15 days)

Training & development reimbursement

Health and dental benefits

Healthcare spending account

Résumé du poste

PICTON Investments is offering an 8-month internship for an Intern, Data Engineer on the Digital Product team in Toronto. You will gain hands-on experience transforming data and supporting stakeholders across sales, investment, portfolio management, operations, compliance, HR and marketing.

The role emphasizes collaboration, cloud and SQL/data modeling proficiency, and exposure to data warehousing, with a competitive hourly range and strong learning opportunities.

Qualifications

• Currently pursuing 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).

Responsabilités

• Gain hands-on experience in data transformation and support stakeholders across sales, investment, portfolio management, operations, compliance, HR, and marketing.

Connaissances

SQL

Data modeling

ETL/ELT

Python OR R scripting

PostgreSQL

MySQL

MongoDB

Redshift

Snowflake

AWS/GCP/Azure

Tableau/Looker/Power BI

Communication

Team collaboration

Formation

Undergraduate degree in STEM

Outils

Tableau

Looker

Power BI

Description du poste

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.

AtPicton 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 233 bold thinkers, one-third dedicated solely to investment management, we are specialists, not generalists. Managing $19.9 billion (as of September 30, 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

AtPICTON 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 dynamicIntern, 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.

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

AtPICTON 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 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. We welcome applications from candidates with diverse experiences globally. Canadian experience is not required. If you require an accommodation at any point in time throughout the application and hiring process, please contact Human Resources at [phone] or at [e-mail].

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.