Home / Jobs / Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting
Posted:
March 23, 2026
Location:
Calgary, Alberta, Canada

Job Description

Overview: Our client requires an Intermediate BI/Analytics Engineer to build analytical data models and optimize query performance for business intelligence consumption.

Responsibilities:

  • Design dimensional models for Revenue and Customer analytics
  • Optimize Redshift query performance and table design
  • Create aggregate tables and materialized views
  • Build semantic layers for BI tool consumption
  • Support Revenue UAT testing and validation
  • Document business rules and calculations

    • Must Haves:

  • 5+ years building analytical data models and marts
  • Expert SQL and dimensional modeling skills
  • Experience with Redshift performance optimization
  • Background in business intelligence tools integration
  • Understanding of airline metrics (RPK, ASK, load factor, yield)

    • Nice to Haves:

    <...

    Apply for this Job

    Submit your application for the Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting position at S.i. Systems.

    Apply Now Save for Later

    Job Overview

    Job Type: Contract
    Location: Calgary, Canada
    Posted: March 23, 2026
    Deadline: May 02, 2026