Data Engineer Co-op

About Ratehub

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. We help over 2M Canadians per month via our digital application technology and award-winning in-house brokerages.

We have many unique businesses including mortgage brokerage, life insurance brokerage, home and auto insurance brokerage, mortgage originations and servicing business, Financial Services Marketplace, and a content business across Ratehub and MoneySense.

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

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.
• Incremental Delivery: Understand the value of getting a working version into production quickly and iterating based on feedback.

Culture Fit

• No Ego: Willing to ask questions, learn, and help execute tasks regardless of size.
• Player Coach: Mentor and teach as you execute, modeling expected behavior.
• Growth Mindset: Desire to grow and learn by trying new things.
• Helping Hand: Always offer help without being asked.
• Get S##T Done: Bias towards action and moving projects forward.
• Digs Deep: Ask questions to understand root causes and solve problems properly.

Additional Information

• This is a remote-first company and open to remote candidates for this co-op term.
• Estimated compensation range: $50,000 - $60,000.
• Accommodations are available upon request for candidates with disabilities.
• AI technology is used in the screening and assessment process of recruitment.