Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operat[...]

S I Systems; Quebec, Calgary, Edmonton; On-site; CAD 60,000 - 80,000; Full time

Job summary

A data solutions provider is seeking an Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting. The ideal candidate will have over 5 years of experience in building analytical data models, with expertise in SQL and Redshift optimization. This contract position is based in Quebec, and offers a flexible hourly pay rate.

Qualifications

• 5+ years building analytical data models and marts.
• Expert SQL and dimensional modeling skills.
• Experience with Redshift performance optimization.

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 360 UAT testing and validation.
• Document business rules and calculations.

Skills

Analytical data models

SQL

Redshift performance optimization

Business intelligence tools

Airline metrics understanding

Tools

Tableau

PowerBI

Job description

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

Job Type: Contract

Positions to fill: 1

Start Date: Oct 20, 2025

Job End Date: Mar 20, 2026

Pay Rate: Hourly: Negotiable

Job ID: 148319

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 360 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