Junior Analytics Engineer

Socket.dev; Toronto; On-site; CAD 55,000 - 85,000; Full time

Benefits offered by this job

Remote-first work environment

Professional learning & development

Toronto HQ

Competitive health benefits starting

Growth-oriented leadership

Job summary

Top Hat is seeking a Junior Analytics Engineer to help maintain data pipelines and surface key insights at the heart of our Business Analytics team. You will support our operational teams—Revenue, Finance, Customer Success, Marketing, and more—ensuring data is trusted and ready for growth.

You will work with SQL and Python, build dashboards, and apply software engineering practices in a collaborative, startup-like environment that values learning and impact.

Qualifications

• 1–2+ years of 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 BI tools like Looker and Tableau.
• Interest in modern data tools such as dbt and Airflow; Git and testing practices.
• Detail-oriented with hands-on collaboration to solve technical problems.
• Bonus for startup/tech product experience, or higher-ed teaching/student background.

Responsibilities

• Develop, maintain, and optimize data models to ensure data integrity and pipeline reliability.
• Monitor data pipelines, identifying and resolving inconsistencies in existing processes.
• Translate stakeholder requirements into clean, efficient SQL queries under guidance of seniors.
• Build, document, and maintain internal dashboards; troubleshoot 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.

Skills

SQL

Python

Data modeling

Looker

Tableau

dbt

Airflow

Git

Testing

Education

Degree in CS/Statistics/Engineering

Job 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