Staff Analytics Engineer

Jobgether; Canada; Remote; CAD 245,000 - 259,000; Full time

Benefits offered by this job

Competitive salary USD 175,000–185,000

Fully remote work environment

Annual discretionary bonus

Medical, dental, vision insurance

401(k)

Mental health support

Paid time off and parental leave

Professional development

Job summary

Jobgether in Canada seeks a Staff Analytics Engineer to design and scale data infrastructure for analytics in a large education technology environment.

You will lead ELT/ETL pipelines, develop analytical data models, and build semantic layers to transform data into reliable business insights. Collaboration with data scientists and engineers is essential to improve data accessibility and quality.

Qualifications

• 8+ years in software/data engineering or analytics engineering.
• At least 5 years in analytics engineering or ELT/ETL systems.
• Advanced SQL and hands-on dbt development experience.
• Strong analytical data modeling knowledge (Kimball).
• Experience designing scalable data workflows and semantic layers.
• Cloud data warehouse exposure (Snowflake) and data storage concepts.
• Experience with Airflow, Fivetran, and Matillion.
• Familiarity with BI/semantic tools (Looker/Tableau/Cube.dev).
• Strong collaboration, leadership, and mentoring abilities.

Responsibilities

• Design, develop, and maintain scalable ELT/ETL pipelines (dbt, Airflow, SQL).
• Build clean analytical data models and semantic layers for BI and product analytics.
• Architect data warehouse schemas and transformation workflows for performance and scalability.
• Develop reliable datasets for student performance and educational insights.
• Maintain slowly changing dimensions across school-year transitions.
• Improve data deployment, testing, CI/CD, and data reliability.
• Establish data quality standards and monitoring across analytics systems.
• Collaborate with data scientists, engineers, analysts, and stakeholders.
• Mentor analytics engineers and contribute to technical standards and reviews.
• Help define long-term analytics strategy and architectural decisions.

Skills

SQL

Data modeling

ETL/ELT design

Kimball dimensional modeling

Mentoring/leadership

CI/CD pipelines

Data quality/validation

Analytics engineering

Tools

dbt

Airflow

Snowflake

Fivetran

Matillion

Looker/Tableau/Cube.dev

Git

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Staff Analytics Engineer based in Canada.

As a Staff Analytics Engineer, you will play a pivotal role in designing and scaling the data infrastructure that powers analytics, reporting, and strategic decision-making across a large education technology environment. You will lead the development of robust ELT/ETL pipelines, high-quality analytical data models, and semantic layers that transform complex datasets into reliable business insights. Working with modern technologies such as dbt, SQL, Airflow, and Snowflake, you will help build scalable data systems supporting millions of students and educators. You will collaborate closely with data scientists, software engineers, analysts, and business stakeholders to improve data accessibility, quality, and performance. Beyond hands-on engineering, you will mentor colleagues, establish technical standards, and influence the long-term analytics engineering strategy. This is an opportunity to combine technical leadership, architectural ownership, and meaningful impact in an organization focused on improving educational outcomes through data.

Accountabilities:

• Design, develop, and maintain scalable ELT/ETL pipelines using dbt, Airflow, SQL, and modern cloud-based data technologies.
• Build clean, reusable, and well-documented analytical data models and semantic layers that support business intelligence, reporting, and product analytics.
• Architect and optimize data warehouse schemas, transformation workflows, and metrics systems to ensure performance, scalability, and long-term maintainability.
• Develop reliable datasets that support student performance analysis, adaptive learning platforms, educational insights, and operational decision-making.
• Design and maintain slowly changing dimensional models that accurately account for school-year transitions, student movements, and evolving educational data structures.
• Improve data deployment workflows, testing infrastructure, CI/CD pipelines, and overall data reliability through automation and engineering best practices.
• Establish data quality standards, monitoring practices, and validation processes to ensure consistency and accuracy across analytical systems.
• Collaborate with data scientists, software engineers, analysts, and business stakeholders to translate business requirements into scalable data solutions.
• Mentor analytics engineers and contribute to technical standards, documentation, code reviews, and knowledge-sharing initiatives.
• Help define the long-term analytics engineering strategy, influence architectural decisions, and drive continuous improvements across the data organization.

Requirements:

• 8+ years of professional experience in software engineering, data engineering, analytics engineering, or a closely related technical discipline.
• At least 5 years of specialized experience in analytics engineering, data modeling, or modern ELT/ETL systems.
• Advanced proficiency in SQL and extensive hands-on experience with dbt, including developing and maintaining production-grade data transformation pipelines.
• Strong expertise in analytical data modeling, particularly Kimball dimensional modeling principles and modern warehouse architecture.
• Proven experience designing scalable data workflows, transformation processes, and semantic data layers.
• Solid understanding of cloud data warehouse technologies, particularly Snowflake, and cloud-based storage systems.
• Practical experience with orchestration and data ingestion tools such as Airflow, Fivetran, and Matillion.
• Familiarity with business intelligence and semantic modeling platforms such as Looker, Tableau, or Cube.dev.
• Strong knowledge of Git, automation, CI/CD pipelines, testing frameworks, and modern software engineering workflows.
• Excellent analytical and problem-solving abilities, with a strong focus on data quality, reliability, and performance optimization.
• Demonstrated technical leadership experience, including mentoring engineers, leading technical initiatives, and influencing engineering standards.
• Strong communication and collaboration skills, with the ability to work effectively across technical and non-technical teams.

Nice to Have:

• Fluency in Python or another programming language for automation, data processing, and engineering workflows.
• Familiarity with metadata management and data governance platforms such as Atlan.
• Experience building business intelligence dashboards, reporting frameworks, and self-service analytics solutions.
• Previous experience in education technology or highly regulated data environments.
• Passion for mentorship, knowledge sharing, teaching, and fostering a strong engineering culture.
• Open-source contributions, personal technical projects, or a demonstrated interest in exploring emerging data technologies.

Benefits:

• Competitive annual base salary ranging from USD 175,000 to USD 185,000, depending on experience and qualifications.
• Eligibility for an annual discretionary performance-based bonus.
• Comprehensive medical, dental, and vision insurance coverage.
• 401(k) retirement savings plan.
• Mental health and wellness support.
• Paid time off and parental leave.
• Professional development opportunities and learning programs.
• Fully remote working environment.
• Opportunity to influence data architecture and analytics engineering strategy at an organizational level.
• Exposure to modern data technologies, large-scale analytical systems, and complex data infrastructure.
• Opportunity to mentor talented engineers and contribute to meaningful educational initiatives impacting millions of students and educators.