Junior Analytics Engineer - Data Pipelines & Insights

Socket.dev; Toronto; Hybrid; 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

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.