About the role#
PICTON Investments is seeking an Intern, Data Engineer to join the Digital Product team for an 8-month internship. You will gain hands-on experience in data transformation projects while supporting business stakeholders across departments including investment, portfolio management, sales, operations, compliance, HR, and marketing.
What you'll do#
- Assist in building and maintaining ETL or ELT processes.
- Help automate data ingestion from multiple sources.
- 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'll need#
- Currently pursuing an undergraduate degree in Mathematics, Computer Science, Computer Engineering, Business, or a related discipline.
- Understanding of SQL and experience with data modeling.
- Familiarity with Python, R, or other scripting languages.
- Familiarity with the concepts of ETL/ELT.
- Exposure to relational and NoSQL databases such as PostgreSQL, MySQL, or MongoDB.
- Understanding of data warehousing solutions like Redshift or Snowflake.
- Exposure to cloud platforms such as AWS, GCP, or Azure.
- Familiarity with data visualization tools like Tableau, Looker, or Power BI.
- Strong analytical and problem-solving skills.
- Ability to learn quickly and work independently.
- Strong verbal and written communication skills.
- Ability to work well in a collaborative team environment.
Location & details#
- Location: Toronto, Ontario, Canada.
- Work Modality: Hybrid.
- Term: 8 months, rolling.
- Type: Full-time, paid internship.
- Compensation: $20.00 - $32.00 per hour.
About PICTON Investments
PICTON Investments is a Canadian financial services firm based in Toronto. Founded in 2004, the company manages over 19 billion dollars in assets. It employs approximately 251 people and operates as a partnership. The firm focuses on alternative investment strategies, quantitative research, and fundamental analysis to assist investors with portfolio construction.
How to get in at PICTON Investments
Applying early gives you a distinct advantage at PICTON Investments, as recruiters often review candidates before the applicant pool grows too large. Intern Insider sends an instant alert the moment a role matching your target is published, helping you apply among the first. This timing ensures your materials are seen while the team is still actively filling the pipeline. You can also improve your response rates by reaching out to the recruiters behind the firm's roles directly. Intern Insider surfaces these specific contacts so you can ask about the role or a referral. Connecting with the right person often makes the difference between a buried application and a conversation.
