Junior Analytics Engineer
Socket.dev · Toronto, Canada ·
- Work mode
- Remote
- Seniority
- Junior
- Category
- Data analytics
- Experience
- 2+ years
Socket.dev · Toronto, Canada ·
Delivery Hero · Barcelona, es
Pargo · Cape Town, South Africa
datamaxis · Okemos, United States
boosted · Canada
Junior Analytics Engineer at Top Hat (Toronto) supporting the Business Analytics team: maintaining and optimizing data pipelines, writing SQL data models, building internal dashboards, and handling ad-hoc data requests for business teams. Core tools: SQL, Python, dbt, Airflow, Git, and BI tools like Looker/Tableau.
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.
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.
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
TEKsystems · Colorado Springs, Colorado