Senior Analytics Engineer

Cactus Club Cafe

Vancouver

On-site

CAD 170,000 - 195,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

50% food & drinks discount
Training & development
Fun culture
Wellness spending account
Benefits package

Job summary

Cactus Club Cafe in Vancouver seeks an experienced Analytics Engineer to own the semantic layer, ELT pipelines, and data models across core operational systems. You will enable on-demand refreshes with serverless automation and tune warehouse performance for near real-time insights.

You will mentor the team, shape the data architecture with the BI Director, and partner with visualization developers to deliver robust dashboards.

Qualifications

  • 5+ years in data or analytics engineering.
  • Proficient in SQL, dimensional modelling and data transformation tools (dbt).
  • Built governed semantic or metrics layers for business users and AI tools.
  • Experience building data pipelines across cloud platforms and used serverless tools.
  • Familiar with modern BI & AI tools (Sigma Computing, Claude, OpenAI APIs).

Responsibilities

  • Build a governed semantic layer in our data warehouse (Snowflake) using dbt.
  • Design and maintain ELT pipelines and data models from core systems (POS, labour, inventory, reservations, finance).
  • Enable on-demand refreshes with serverless automation (AWS Lambda).
  • Tune performance with views, dynamic tables and warehouse sizing for near real-time data.
  • Support data visualization developers with robust models for reports/dashboards.
  • Shape data architecture in collaboration with BI Director on AI-readiness roadmap.
  • Mentor the team by reviewing code and coaching developers.

Skills

SQL
Dimensional modelling
dbt
Snowflake
BigQuery
Databricks
ELT pipelines
AWS Lambda
BI tools
AI workflows

Tools

dbt
Sigma Computing
OpenAI APIs
Claude
AWS Lambda
Snowflake

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Analytics Engineer - Cloud Data & AI Readiness
Senior Analytics Engineer - Cloud Data & AI Readiness

Cactus Club Cafe • Vancouver

On-site
CAD 170,000 - 195,000
50% food & drinks discount
Training & development
Fun culture
+2
Digital Marketing Coordinator
Digital Marketing Coordinator

Cactus Club Cafe • Vancouver

On-site
CAD 50,000 - 60,000
50% off food and drinks
Comprehensive benefits package
Focus on training and development
Sr. Analytics Manager
Sr. Analytics Manager

OpenTable • Toronto

Hybrid
CAD 154,000 - 174,000
Remote-friendly work
Therapy benefits
Headspace subscription
+6
Culinary Management | Park Royal
Culinary Management | Park Royal

Cactus Club Cafe • West Vancouver

On-site
CAD 55,000 - 75,000
Wellness Spending Account
Cactus Food Dine In Card
Annual Education Allowance
+2
Data Engineer II (Restaurant AI CoPilot)
Data Engineer II (Restaurant AI CoPilot)

OpenTable • Toronto

Hybrid
CAD 120,000 - 130,000
Generous vacation
Hybrid work arrangement
Mental health & well-being support
+7
Analyst, Restaurant Systems
Analyst, Restaurant Systems

Recipe Unlimited Corporation • Vaughan

Hybrid
CAD 63,000 - 76,000
20% associate discount dining card
Flexible/Hybrid work environment
Career advancement opportunities
+1
General Manager
General Manager

Cactus Club Cafe • Edmonton

On-site
CAD 85,000 - 120,000
Company-provided benefits package
Wellness spending account
Vacation program
+2
Restaurant Manager | Stephen Avenue
Restaurant Manager | Stephen Avenue

Cactus Club Cafe • Calgary

On-site
CAD 70,000 - 90,000
Wellness spending account
Dine-in card
Annual education allowance
+1
Sr. Manager, Data Engineering
Sr. Manager, Data Engineering

Cineplex • Toronto

On-site
CAD 130,000 - 155,000
Sr. Manager, Revenue Strategy & Operations
Sr. Manager, Revenue Strategy & Operations

OpenTable • Toronto

Hybrid
CAD 157,000 - 191,000
Flexible work options
Health benefits
Paid time off
+6