Analytics 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. 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 Analytics 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 translate complex data into actionable insights that solve both long-term and immediate business problems. This is a unique opportunity to gain hands-on experience with modern BI tools and play a vital role in ensuring data integrity and trust across the organization. The ideal candidate has strong communication skills, an eye for data visualization, and a background in engineering or analytics. 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 support through data modeling and validation. Although headquartered in downtown Toronto, Ratehub is a remote-first company and we are open to remote candidates for this co-op term.

• BI Platform Migration: Play a key role in the transition from Looker to Power BI, recreating essential dashboards and ensuring reporting accuracy across platforms.
• Data Validation & QA: Perform data validation between Looker and Power BI to ensure that metrics, logic, and filters remain consistent and accurate.
• Automated Testing: Assist in developing and maintaining dbt tests (schema and data tests) to catch upstream data quality issues before they reach the reporting layer.
• Dashboard Support: Provide ad-hoc support for existing dashboards, troubleshooting data discrepancies and fulfilling custom visualization requests.
• Data Modeling & Optimization: Build clean, documented data models and optimize SQL queries to improve dashboard performance and reduce refresh times.

• Currently enrolled in a post-secondary co-op program in Data Analytics, Computer Science, or a related field.
• High proficiency in SQL (comfortable with complex joins, window functions, and CTEs).
• Familiarity with Power BI, Looker, or BI tool.
• Basic understanding of data transformation and testing tools like dbt.
• Familiarity with data quality frameworks or automated testing logic for data pipelines.

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