Back to job search
Cactus Club Cafe logo

Senior Analytics Engineer

  • Vancouver, BC
  • On-site
  • Posted Nov 6, 2026
  • 1 position

$170,000–$195,000 / year

Opens LinkedIn

Sign in to save this job
Employment type
Full-time
Experience level
Senior
Posting language
English

Job summary

Build and maintain governed semantic layers, ELT pipelines, and data models in Snowflake to support business intelligence, operational reporting, and AI workflows. Improve data freshness and performance, support visualization developers, contribute to data architecture and AI-readiness planning, and mentor the growing team.

Job details

At Cactus Club Cafe, we love what we do, and we love the people we do it with. As one of the most innovative restaurant concepts in Canada, we are continuously celebrated as one of the country’s best places to work. We firmly believe in creating a workplace where everyone feels welcome, supported and valued. Today, these restaurants are a national brand, and are experiencing the fastest growth in its history. Continuously innovating and implementing new technology, our IT Team maintains and supports all technologies including audio visual, hospitality and head office based systems while partnering with Operations to rollout, implement and update programs to ensure efficiencies. YOU ARE: An Experienced Analytics Engineer: You have 5+ years in data or analytics engineering, with deep hands-on experience in cloud data platforms (e.g., Snowflake, BigQuery, Databricks). A Technical Leader: You set best practices, review code, mentor developers and write documentation people can follow. Strong in SQL, Modelling & Data Transformation: You're highly proficient in SQL, dimensional modelling, and data transformation tools (e.g., dbt). You have proven experience building governed semantic or metrics layers that business users and AI tools can rely on. Comfortable in the Cloud: You've built data pipelines across major cloud platforms and used serverless tools to support automated data workflows. Experienced with Modern BI & AI Tools: You know how to prepare data for cloud-native BI platforms (e.g., Sigma Computing) and emerging LLM/AI workflows (e.g., Claude, OpenAI APIs). YOU WILL BE RESPONSIBLE FOR: Building the Semantic Layer: Creating a governed semantic layer in our data warehouse (Snowflake) using transformation tools like dbt to standardize key business metrics for BI applications and natural language AI assistants. Building Pipelines and Models: Designing and maintaining ELT pipelines and data models that bring in data from our core operational systems (POS, labour/scheduling, inventory, reservations, finance). Supporting On-Demand Refreshes: Building serverless automation (e.g., AWS Lambda) so teams can refresh data on demand. Tuning Performance: Managing views, dynamic tables and warehouse sizing to keep data close to real time. Supporting Our Visualization Developers: Making sure our data models give them what they need for their reports and dashboards. Shaping Our Data Architecture: Working with the BI Director on architecture, platform design, data science infrastructure, and our AI-readiness roadmap. Mentoring the Team: Reviewing code and coaching developers as the team grows. WE WILL: Give you the ultimate Cactus discount — 50% off food + drinks, hungry yet? Focus on your training and development, we’re believers in lifelong learning Foster a fun culture that makes coming to work genuinely enjoyable Provide compensation between $170,000 - $195,000. The compensation package for this role takes various factors into consideration including market rates, experience, and qualifications Offer a competitive benefits package and wellness spending account Continuously on the grow, Cactus Club Cafe is one of the most successful concepts in Canada and our expansion will continue. We are always looking for talented and inspiring individuals to join our team. Applications are accepted from all individuals. Accommodations are available on request for candidates taking part in every aspect of the selection process. Please note that due to the high volume of applicants, we will only reach out if you are selected to move forward in the interview process.

What you’ll do

Build and maintain governed semantic layers, ELT pipelines, and data models in Snowflake to support business intelligence, operational reporting, and AI workflows. Improve data freshness and performance, support visualization developers, contribute to data architecture and AI-readiness planning, and mentor the growing team.

Requirements

Requires 5+ years of data or analytics engineering experience, strong SQL, dimensional modelling, and data transformation skills, plus hands-on experience with cloud data platforms such as Snowflake, BigQuery, or Databricks. Candidates should have experience with governed semantic or metrics layers, cloud pipelines and serverless automation, modern BI and AI tools, and technical leadership through code reviews, mentoring, and documentation.

Benefits

  • 50% Off Food And Drinks
  • Training And Development
  • Competitive Benefits Package
  • Wellness Spending Account

Listed skills

  • SQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Analytics Engineering
  • SQL
  • Dimensional Modelling
  • Data Transformation
  • dbt
  • Snowflake
  • Cloud Data Platforms
  • ELT Pipelines
  • Semantic Layer Development
  • Data Modelling
  • Serverless Automation
  • AWS Lambda
  • Performance Tuning
  • Business Intelligence
  • Code Review
  • Technical Mentoring

Job areas

  • Data & Analytics
  • Technology
  • Software
  • Management & Leadership
  • Food & Beverage

More jobs from Cactus Club Cafe

See all jobs from Cactus Club Cafe