Intern, Data Engineer | Winter Term

Best Workplaces in Canada 2020 - 2025 Best Workplaces with Most Trusted Executive TeamsBest Workplaces in Financial Services & Insurance 2020 - 2025 Best Workplaces for Mental Wellness 2023 - 2025 Best Workplaces for Giving BackBest Workplaces for InclusionBest Workplaces for Women 2021 Best Workplaces in OntarioBest Workplaces for Professional Development

One of Canadas Most Trusted Investment Brands.

AtPicton Mahoney Asset Management (PICTON Investments) 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 over 203 bold thinkersone-third dedicated solely to investment managementwe are specialists not generalists. Managing $16.1 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

AtPICTON Investments 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 Investments is presently seeking a dynamicIntern 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 or at .

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

Required Experience:

Junior IC