Intermediate BI/Analytics Engineer to create analytical datasets airline revenue and operations reporting

Job in Vancouver, BC, Canada

Listing for: S.i. Systems

Contract position
Listed on 2026-06-14

Job specializations:

IT/Tech
Data Analyst, Data Engineering, Business Systems/ Tech Analyst, Data Warehousing

Position: Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting

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:

Experience with Tableau or PowerBI

Knowledge of revenue management concepts

dbt experience

Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
View / Apply for Jobs
Matching My Jurisdiction

Intermediate BI​/Analytics Engineer to create analytical datasets airline revenue and operations reporting

Intermediate BI/Analytics Engineer to create analytical datasets airline revenue and operations reporting