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

S.i. Systems

📍 Ottawa, Ontario, Canada 💼 Contract 🕒 Posted June 04, 2026

Apply Now Similar Jobs

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:
<...
            

Ready to Apply?

Submit your application today and join our talented team at S.i. Systems.

Submit Application

Job Details

Location Ottawa, Ontario
Job Type Contract
Category Mathematical Science Occupations
Posted Date June 04, 2026
Application Deadline July 14, 2026