PICTON Investments Logo

PICTON Investments

Intern, Data Engineer | Winter Term

Posted Yesterday
Be an Early Applicant
In-Office
Toronto, ON
Internship
In-Office
Toronto, ON
Internship
The intern will assist in data transformation projects, working with ETL processes, automating data ingestion, and collaborating with teams to enhance data quality and usability.
The summary above was generated by AI

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

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 over 203 bold thinkers—one-third dedicated solely to investment management—we are specialists, not generalists. Managing $16.1 billion 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. 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.


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

Top Skills

AWS
Azure
GCP
Looker
MongoDB
MySQL
Postgres
Power BI
Python
R
Redshift
Snowflake
SQL
Tableau

Similar Jobs

An Hour Ago
Hybrid
Toronto, ON, CAN
Mid level
Mid level
Gaming • Information Technology • Mobile • Software
The Cloud Security Engineer will improve cloud security posture, manage vulnerabilities, automate asset discovery, and collaborate with IT and Security teams to ensure secure connectivity and compliance.
Top Skills: AWSAws Security HubAzureAzure Security CenterCC#C++CnappCspmGCPKubernetesOrcaPowershellPrisma CloudPythonVbscriptWiz
3 Hours Ago
Easy Apply
Hybrid
Toronto, ON, CAN
Easy Apply
Expert/Leader
Expert/Leader
Artificial Intelligence • Cloud • Information Technology • Machine Learning • Software • Big Data Analytics • Automation
The Strategic Customer Success Manager builds relationships with key stakeholders to guide customers through their digital journey and ensure successful product adoption, while delivering business value and managing risks.
Top Skills: SaaS
3 Hours Ago
Hybrid
Toronto, ON, CAN
Mid level
Mid level
AdTech • Big Data • Digital Media • Marketing Tech
As an Advertising Account Manager, you'll manage client relationships, optimize campaigns, analyze results, and seek growth opportunities within a dynamic book of business.
Top Skills: Programmatic AdvertisingWeb Marketing

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account