Analytics Engineer: Semantic Layer & AI-Driven Analytics

Ignition; Vancouver; Hybrid; CAD 120,000 - 160,000; Full time

Job summary

A global SaaS company in Metro Vancouver is looking for an Analytics Engineer to improve data accessibility through effective modeling and stakeholder enablement. This role includes designing and maintaining data models, developing a semantic layer in Looker, and conducting investigations across the data stack. Candidates should have a strong understanding of data modeling and advanced SQL skills, with experience in Snowflake and dbt. The role offers competitive compensation and emphasizes a collaborative culture.

Benefits

Employee share options

Health, dental, and vision benefits

Flexible working arrangements

Annual education allowance

Quarterly wellness allowance

Qualifications

• Strong understanding of facts vs dimensions, grain, slowly changing dimensions.
• Experience in Snowflake or modern data warehouse platforms.
• Ability to clarify and diagnose problems.

Responsibilities

• Design and maintain data models in dbt.
• Develop the semantic layer in Looker.
• Conduct end-to-end investigations of data issues.

Skills

Data modeling fundamentals

Advanced SQL skills

Production analytics codebases

Engaging with stakeholders

Daily use of AI tools

Tools

Snowflake

Looker

dbt

Python

Job description

A global SaaS company in Metro Vancouver is looking for an Analytics Engineer to improve data accessibility through effective modeling and stakeholder enablement. This role includes designing and maintaining data models, developing a semantic layer in Looker, and conducting investigations across the data stack. Candidates should have a strong understanding of data modeling and advanced SQL skills, with experience in Snowflake and dbt. The role offers competitive compensation and emphasizes a collaborative culture.