Data Engineer Intern - 8 month contract

Ratehub•Toronto, ON

1d•Remote

About The Position

We are looking for a top-performing Data Engineer Co-op to join our newly created Data Team. This team is responsible for capturing, analyzing, and modeling data to provide meaningful insights to our Members and businesses, serving as the backbone for all business units. This role offers a unique opportunity to gain hands-on experience with modern data stacks and assist in critical infrastructure projects. You will work closely with senior engineers, analysts, and business stakeholders to learn different facets of the company while providing valuable technical support. Ratehub is a remote-first company, and we are open to remote candidates for this co-op term.

Requirements

Currently enrolled in a post-secondary co-op program in Computer Science, Software Engineering, Data Science, or a related technical field.
Strong foundational knowledge of SQL and Python.
Exposure to cloud environments (AWS or GCP) and an understanding of data warehousing concepts.
Simplicity First: You prefer simple, maintainable solutions over over-engineered abstractions.
Effective Communicator: You are comfortable asking questions and providing/receiving candid feedback to ensure project success.
Incremental Delivery: You understand the value of getting a working version into production quickly and iterating based on feedback.
No Ego: No task is too big or small. You are never afraid to ask questions when you are trying to learn and understand things. You have no problem rolling up your sleeves and helping to execute when the team needs help. This humility extends to all aspects of your work and interaction with teammates.
Player Coach: You mentor and teach as you execute. You model the behaviour you expect from your team. You don’t just tell others what to do, you know and show how to do it at a high standard.
Growth mindset: You have a desire to always continue to grow and learn. This means a willingness to get outside your comfort zone and try new things because you view these as opportunities to gain skills and knowledge.
Helping Hand: You always offer to help without having to be asked. You go the extra mile to help out regardless of your team and function.
Get S##T Done: Your bias is towards action. This means pitching in and rallying to get things across the finish line. Rather than putting off work ask yourself what you can do today to move the needle on a project or goal.
Digs Deep: You aren't afraid to ask questions because you want to understand every issue so that you can properly solve the root cause of the problem instead of just completing the task you are given.

Nice To Haves

Academic or project experience with dbt, Airflow, or Snowflake is highly preferred.
Familiarity with DevOps practices or NoSQL databases (Mongo DB) is considered a definite asset.

Responsibilities

Assist the engineering team in the migration of data assets from Amazon Redshift to Snowflake, ensuring data integrity and performance.
Work closely with lead engineers to provision and configure the Insurance BU data infrastructure, gaining hands-on experience with cloud architecture.
Build and maintain data pipelines using Airflow and dbt to handle ongoing ad-hoc requests and automate financial data workflows.
Help create clean, modular, and maintainable code by refactoring complex queries into streamlined transformation layers.
Partner with both engineering and business teams to understand requirements and deliver data solutions that provide immediate value.