Top Hat logo

Top Hat

Junior Analytics Engineer

🇨🇦 Remote - CA 🕑 Full-Time 💰 TBD 💻 Data Science 🗓️ August 8th, 2026
SQL Python Tableau

Edtech.com's Summary

Top Hat is hiring a Junior Analytics Engineer to support its Business Analytics team by maintaining data pipelines and generating actionable insights for operational teams such as Revenue, Finance, and Customer Success. The role involves developing and optimizing data models, monitoring pipelines for inconsistencies, and building internal dashboards while applying software engineering best practices.

Highlights
  • Develop, maintain, and optimize data models to ensure data integrity and pipeline reliability.
  • Monitor data pipelines and resolve inconsistencies.
  • Translate stakeholder needs into efficient SQL queries under senior guidance.
  • Build, document, and maintain internal dashboards and troubleshoot reporting issues.
  • Assist with ad-hoc data requests and perform data quality checks.
  • Apply software engineering best practices including version control and automated testing.
  • Requires 1-2+ years of experience in analytics or data engineering.
  • Proficient in SQL (CTEs, window functions, query optimization) and Python.
  • Familiarity with data modeling and BI tools such as Looker or Tableau.
  • Bonus for experience in tech startups or higher education roles.

Junior Analytics Engineer Full Description

We are looking for a Junior Analytics Engineer to help maintain data pipelines and surface key insights at Top Hat. You will be part of Business Analytics, a small but impactful data team serving our Operational teams (Revenue, Finance, Customer Success,Marketing, etc.), helping to ensure our data is trusted and ready to support the needs of Top Hat’s growth.

You will:

  • Develop, maintain, and optimize data models to ensure data integrity and pipeline reliability.

  • Monitor data pipelines, identifying and resolving inconsistencies in existing processes.

  • Learn our business, translating stakeholder requirements into clean, efficient SQL queries under the guidance of senior team members.

  • Build, document, and maintain internal dashboards; troubleshooting issues to ensure accurate reporting.

  • Assist with ad-hoc data requests and perform data quality checks.

  • Apply software engineering best practices, including version control and automated testing.

About you:

  • 1-2+ years of experience in analytics, data engineering, or similar quantitative work.

  • Degree in Computer Science, Statistics, Engineering or equivalent practical experience.

  • Solid foundation in SQL (CTEs, window functions, query optimization) and Python.

  • Familiarity with data modeling and Business Intelligence tools (e.g., Looker, Tableau).

  • Eagerness to learn and apply modern data tools (dbt, Airflow) and software engineering best practices (Git, testing).

  • Detail-oriented, with a drive to solve technical problems in collaborative, hands-on settings.

  • Bonus points for: Experience working in tech products, particularly in startups. Recent experience in higher ed as a teacher or student.

Why team members love working at Top Hat:

  • A noble mission that creates meaningful, fulfilling work

  • A team that cares deeply for customers and for each other

  • Flexible, remote first work environment

  • Professional learning and development for all role levels

  • An awesome and welcoming Toronto HQ

  • Competitive health benefits that start on day one

  • A management team focused on performance, growth, engagement and connection

  • Our winning strategy and market potential

  • Innovative PTO policy with lots of time and space for self-care

  • Passionate customers that believe in us—and what we do

  • A chance to work with new tech like generative AI—and see the customer impact