Data Engineer Intern - 8 month contract

Data Engineer Co-Op

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. And we're pretty great at it, too. Via our digital application technology and our award-winning in-house brokerages, we help over 2M 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 Loans 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, though. We know that achieving our mission is full of challenges; challenges that can be complex and often unexpected, but that are always interesting, rewarding, and fun to solve as a team. This is where you come in. We are on the hunt for the right kind of people to join us and help lead us forward to continued growth.

We have a newly created Data Team that 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 get the opportunity to work closely with senior engineers, analysts, and business stakeholders to learn different facets of the company while providing valuable technical support. Although headquartered in downtown Toronto, Ratehub is a remote-first company and we are open to remote candidates for this co-op term.

Your Responsibilities

• Support the Migration: Assist the engineering team in the migration of data assets from Amazon Redshift to Snowflake, ensuring data integrity and performance.
• Infrastructure Provisioning: Work closely with lead engineers to provision and configure the Insurance BU data infrastructure, gaining hands-on experience with cloud architecture.
• Pipeline Development: Build and maintain data pipelines using Airflow and dbt to handle ongoing ad-hoc requests and automate financial data workflows.
• Data Transformation: Help create clean, modular, and maintainable code by refactoring complex queries into streamlined transformation layers.
• Cross-functional Collaboration: 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 (Mongo DB) is considered a definite asset.

Core Competencies

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

Culture Fit:

• 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 behavior 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.

This job posting is for a currently open vacancy.

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.