Data Engineer Intern - 8 month contract

Auto Import

<p style="line-height:1.3800000000000001;margin-bottom:8px;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#000000;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">WHO IS RATEHUB?</span></span></span></span></span></span></p><p style="line-height:1.3800000000000001;margin-bottom:8px;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#000000;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">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. </span></span></span></span></span></span></p><p style="line-height:1.3800000000000001;margin-bottom:8px;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#000000;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">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.</span></span></span></span></span></span></p><p style="line-height:1.3800000000000001;margin-top:16px;margin-bottom:16px;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#000000;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">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 </span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#000000;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Data Engineer Co-op</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#000000;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> 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.</span></span></span></span></span></span></p><br><br><br> <h2 style="line-height:1.3800000000000001;margin-left:24px;text-indent:-18pt;background-color:#ffffff;margin-top:24px;padding:0pt 0pt 4pt 18pt;"><span style="font-size:17pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">YOUR RESPONSIBILITIES</span></span></span></span></span></span></h2><ul><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Support the Migration:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> Assist the engineering team in the migration of data assets from Amazon Redshift to Snowflake, ensuring data integrity and performance.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Infrastructure Provisioning:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> Work closely with lead engineers to provision and configure the Insurance BU data infrastructure, gaining hands-on experience with cloud architecture.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Pipeline Development:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> Build and maintain data pipelines using Airflow and dbt to handle ongoing ad-hoc requests and automate financial data workflows.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Data Transformation:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> Help create clean, modular, and maintainable code by refactoring complex queries into streamlined transformation layers.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Cross-functional Collaboration:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> Partner with both engineering and business teams to understand requirements and deliver data solutions that provide immediate value.</span></span></span></span></span></span></li></ul><h2 style="line-height:1.3800000000000001;margin-left:24px;text-indent:-18pt;background-color:#ffffff;padding:6pt 0pt 4pt 18pt;"><span style="font-size:17pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">YOUR QUALIFICATIONS</span></span></span></span></span></span></h2><h3 style="line-height:1.3800000000000001;margin-left:24px;text-indent:-18pt;background-color:#ffffff;padding:10pt 0pt 4pt 18pt;"><span style="font-size:13pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Technical Qualifications</span></span></span></span></span></span></h3><ul><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">Currently enrolled in a post-secondary co-op program in Computer Science, Software Engineering, Data Science, or a related technical field.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">Strong foundational knowledge of SQL and Python.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">Academic or project experience with dbt, Airflow, or Snowflake is highly preferred.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">Exposure to cloud environments (AWS or GCP) and an understanding of data warehousing concepts.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">Familiarity with DevOps practices or NoSQL databases (Mongo DB) is considered a definite asset.</span></span></span></span></span></span></li></ul><h3 style="line-height:1.3800000000000001;margin-left:24px;text-indent:-18pt;background-color:#ffffff;padding:2pt 0pt 4pt 18pt;"><span style="font-size:13pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Core Competencies</span></span></span></span></span></span></h3><ul><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Simplicity First:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> You prefer simple, maintainable solutions over over-engineered abstractions.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Effective Communicator:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> You are comfortable asking questions and providing/receiving candid feedback to ensure project success.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Incremental Delivery:</span></span></span></span></span></span><span style="font-size:11pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> You understand the value of getting a working version into production quickly and iterating based on feedback.</span></span></span></span></span></span></li></ul><p style="line-height:1.3800000000000001;background-color:#ffffff;padding:0pt 0pt 6pt 0pt;"></p><p style="line-height:1.3800000000000001;background-color:#ffffff;margin-bottom:8px;"></p><p style="line-height:1.3800000000000001;background-color:#ffffff;padding:0pt 0pt 6pt 0pt;"></p><p style="line-height:1.3800000000000001;background-color:#ffffff;margin-bottom:8px;padding:0pt 0pt 12pt 0pt;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Culture Fit:</span></span></span></span></span></span></p><ul><li style="list-style-type:disc;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">No Ego</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">: 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 n</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">o</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;"> 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.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Player Coach</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">: 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. </span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Growth mindset</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">: 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.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Helping Hand</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">: You always offer to help without having to be asked. You go the extra mile to help out regardless of your team and function.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Get S##T Done</span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">: 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.</span></span></span></span></span></span></li><li style="list-style-type:disc;"><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:700;"><span style="font-style:normal;"><span style="text-decoration:none;">Digs Deep: </span></span></span></span></span></span><span style="font-size:12pt;font-variant:normal;white-space:pre-wrap;"><span style="font-family:Arial, sans-serif;"><span style="color:#222222;"><span style="font-weight:400;"><span style="font-style:normal;"><span style="text-decoration:none;">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.</span></span></span></span></span></span></li></ul><div style="list-style-type:disc;"> <p>This job posting is for a currently open vacancy.</p><p>AI technology is used in the screening and assessment process of our recruitment.</p><p>The estimated compensation range for this position is $50,000 - $60,000.</p><p></p></div><p>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.</p>

Back to blog