Data Engineer Intern - 8 month contract

Ratehub

1d • Remote

About The Position

Ratehub is a unique Canadian Fintech company focused on helping Canadians make better financial choices across saving, spending, borrowing, investing, and protecting. Through digital applications and award-winning brokerages, Ratehub assists over 2 million Canadians monthly in improving their finances. The company operates multiple businesses including mortgage, life insurance, home and auto insurance brokerages, mortgage origination and servicing, a Financial Services Marketplace, and content across Ratehub and MoneySense. The company is seeking a top-performing Data Engineer Co-op to join its newly created Data Team. This team captures, analyzes, and models data to provide insights to members and businesses, serving as the backbone for all business units. The intern will report to the Lead Data Engineer and contribute to high-impact projects, gaining hands-on experience with modern data stacks and critical infrastructure projects. The role requires strong communication skills, a passion for data, and an engineering background. The intern will collaborate with senior engineers, analysts, and business stakeholders. Ratehub is a remote-first company, and this co-op term is open to remote candidates.

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: Prefer simple, maintainable solutions over over-engineered abstractions.
• Effective Communicator: Comfortable asking questions and providing/receiving candid feedback to ensure project success.
• Incremental Delivery: 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. Not afraid to ask questions when trying to learn and understand things. Willing to roll up sleeves and help execute when the team needs help.
• Player Coach: Mentor and teach as you execute. Model the behavior expected from the team. Know and show how to do things at a high standard.
• Growth mindset: Desire to always continue to grow and learn. Willingness to get outside comfort zone and try new things.
• Helping Hand: Always offer to help without having to be asked. Go the extra mile to help out regardless of team and function.
• Get S##T Done: Bias towards action. Pitch in and rally to get things across the finish line. Ask what can be done today to move the needle on a project or goal.
• Digs Deep: Not afraid to ask questions to understand every issue to properly solve the root cause of the problem instead of just completing the task.

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.

Benefits

• Estimated compensation range: $50,000 - $60,000
• Accommodations are available upon request for candidates taking part in all aspects of the selection process.

What This Job Offers

• Job Type: Full-time
• Career Level: Intern
• Education Level: No Education Listed