Data Engineer Co-op

About

We’re a unique Canadian Fintech that is the one‑stop shop for all financial needs of the consumer – Save, Spend, Borrow, Invest, and Protect. We help over 2 million Canadians per month make a positive impact on their finances through digital application technology and award‑winning in‑house brokerages. Our businesses include mortgage, life insurance, home and auto insurance brokerages, mortgage originations and servicing, a Financial Services Marketplace, and a content business across Ratehub and MoneySense.

The newly created Data Team captures, analyzes, and models data to provide meaningful insights to our Members and businesses. We are looking for a top‑performing Data Engineer Co‑op to join this team, reporting to the Lead Data Engineer, contributing to high‑impact projects and enabling data use to solve business problems.

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.

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.

Compensation

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

Inclusion

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.