Data Engineer Intern

PureFacts Financial Solutions • Toronto, ON

4d

About The Position

We are seeking a Data Engineering Intern to assist in building and maintaining the foundational data pipelines that power our analytics and applications. This role focuses on the extraction of data from various source systems (SaaS APIs, internal services) and the loading of that data into our central data environment.

This is a technical, hands-on role ideal for a student or recent graduate looking to apply their programming skills to real-world data movement and orchestration challenges.

Requirements

• Proficiency in Python (specifically libraries like requests, pandas, and json).
• Strong ability to write and optimize SQL queries for data insertion and retrieval.
• Understanding of HTTP methods (GET, POST), status codes, and JSON/XML data formats.
• Experience with at least one relational database (e.g., PostgreSQL, MySQL).
• Familiarity with cloud environments, with a strong preference for Azure.
• Basic familiarity with Git for collaborative development.

Nice To Haves

• Experience or familiarity with Snowflake as a cloud data warehouse.
• Understanding of basic scheduling concepts (e.g., Cron jobs, Airflow etc.).
• A first-principles approach to solving technical bottlenecks.
• High attention to data accuracy and edge-case handling in code.
• Ability to document technical processes and explain pipeline logic clearly.

Responsibilities

• Pipeline Development: Build and maintain basic ELT/ETL pipelines to move data from external APIs and internal systems into our database.
• API Integration: Interface with RESTful and GraphQL APIs to programmatically retrieve data using standard authentication methods (OAuth2, API Keys).
• Data Transformation: Implement lightweight data cleaning and normalization during the extraction process to ensure data integrity.
• Schema Management: Assist in the design and maintenance of destination tables and schemas.
• Monitoring & Maintenance: Monitor pipeline health, identify failures, and perform basic debugging to ensure consistent data delivery.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed