Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Intern, Data Engineer (8 Months) role.
Rezi rewrites your resume against Picton Mahoney Asset Management's job description. Free.
Tailor your resume to this Intern, Data Engineer (8 Months) role.
Rezi rewrites your resume against Picton Mahoney Asset Management's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Intern, Data Engineer (8 Months) posting at Picton Mahoney Asset Management — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Intern, Data Engineer (8 Months) posting at Picton Mahoney Asset Management — free, in seconds.
About the Role
PICTON Investments is seeking a dynamic Intern, Data Engineer with a passion for Asset Management to join our Digital Product team for an 8-month internship. This role offers hands-on experience in data transformation projects, supporting various business stakeholders.
Responsibilities
- Assist in building and maintaining ETL (Extract, Transform, Load) or ELT processes.
- 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.
Requirements
- Currently pursuing an undergraduate degree in STEM programs (Mathematics, Computer Science, Computer Engineering, Business or any other related discipline).
- Understanding of SQL and experience with data modeling.
- Familiarity with Python, R, or other scripting languages is a plus.
- Familiarity with the concepts of ETL/ELT.
- Exposure to relational and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB) and understanding of data warehousing solutions (e.g., Redshift, Snowflake).
- Exposure to cloud platforms such as AWS, GCP, or Azure, particularly in relation to data storage (S3, BigQuery, etc.) and computing services.
- Any familiarity with data visualization tools (e.g., Tableau, Looker, Power BI).
- Strong analytical and problem-solving skills with an ability to learn quickly and work independently.
- Strong verbal and written communication skills to collaborate effectively with technical and non-technical teams.
- Collaborative and able to work well in a dynamic, fast-paced team environment.
Skills
- SQL
- Data Modeling
- Python
- R
- ETL/ELT
- Relational Databases
- NoSQL Databases
- Data Warehousing
- Cloud Platforms (AWS, GCP, Azure)
- Data Visualization Tools (Tableau, Looker, Power BI)
- Problem Solving
- Communication
- Teamwork
Location
- Canada
Work Type
- Internship
- 8 month internship
Experience Level
- Intern
Education Level
- Undergraduate degree in STEM programs (Mathematics, Computer Science, Computer Engineering, Business or any other related discipline)
Salary/Compensations
- $20.00 - $32.00 per hour
Benefits
- Corporate fitness reimbursement and discounts
- VersaFi memberships
- PICTON Investment Counseling and portfolio management services
- Volunteer and charitable donation matching
- Maternity and parental leave top-up
- Recognition awards
- Semi-annual performance bonuses
- Generous annual vacation entitlement (minimum of 15 days per year)
- Training and development reimbursement
- Extensive health and dental benefits
- Healthcare spending account
About the Company
- Picton Mahoney Asset Management (PICTON Investments) is an independent, privately run, 100% employee-owned firm with 20 years of experience challenging conventional wisdom in the investing landscape.
- They are one of Canada's most trusted investment brands, managing $19.9 billion for institutional and retail clients.
- Their mission is to bring greater certainty to investors by thinking alternatively and innovating within the investment sector.
- The company culture is entrepreneurial, dynamic, collaborative, and bureaucracy-free, empowering ambitious professionals to make an impact.
Equal Opportunity
- PICTON Investments is committed to providing an equitable and fair work environment for everyone.
- All hiring and 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.
- They welcome applications from candidates with diverse experiences globally.
- Canadian experience is not required.
- Accommodation is available throughout the application and hiring process upon request.