Data Engineer Intern - 8 month contract

WHO IS RATEHUB? We’re a company on a mission. We are a unique Canadian Fintech that is the one‑stop shop for all financial needs of the consumer – Save, Spend, Borrow, Invest, and Protect. Every single team member, from product & engineering to sales & marketing, finance, operations, and everything in between, is obsessed with one thing: helping Canadians make better financial choices. Via our digital application technology and our award‑winning in‑house brokerages, we help over 2 million Canadians per month make a positive impact on their finances. We have many unique businesses – a mortgage brokerage, a life insurance brokerage, a home and auto insurance brokerage, a mortgage originations and servicing business, a Financial Services Marketplace and a content business across Ratehub and MoneySense. 365 days a year we deliver our users the best online mortgage experience, personalized credit card and loan options, and cheaper auto & home insurance policies than they typically get from their existing financial adviser.

Changing how people make financial choices isn’t easy, but it is rewarding. The newly created Data Team is capturing, analyzing, and modeling data to provide meaningful insights to our Members and our businesses. We’re looking for a top‑performing Data Engineer Co‑op to join this team, which serves as the backbone for all our business units. Reporting to the Lead Data Engineer, you will be a key contributor to high‑impact projects, helping to enable the use of data to solve both long‑term and immediate business problems. This is a unique opportunity to gain hands‑on experience with modern data stacks and assist in critical infrastructure projects. The ideal candidate has strong communication skills, a passion for data, and a background in engineering. You will work closely with senior engineers, analysts, and business stakeholders.

Your Responsibilities

Support 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.

Your Qualifications Technical Qualifications

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.

Academic or project experience with dbt, Airflow, or Snowflake is highly preferred.

Exposure to cloud environments (AWS or GCP) and an understanding of data warehousing concepts.

Familiarity with DevOps practices or NoSQL databases (MongoDB) is considered a definite asset.

Core Competencies

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.

Culture Fit

No Ego: No task is too big or small. Never afraid to ask questions or roll up sleeves to help execute.

Player Coach: Mentor and teach as you execute. Model the behavior you expect from your team.

Growth Mindset: Desire to always continue to grow and learn, with a willingness to step outside your comfort zone.

Helping Hand: Offer to help without being asked; go the extra mile regardless of team or function.

Get S##T Done: Bias towards action, pitching in to get things across the finish line.

Digs Deep: Ask questions to understand every issue, solving the root cause rather than merely completing a task.

The estimated compensation range for this position is $50,000 – $60,000.

Ratehub welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process.

#J-18808-Ljbffr