Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting
S.i. Systems
Toronto, ON-
Number of positions available : 1
- Salary To be discussed
-
Contract job
- Published on September 28th, 2025
-
Starting date : 1 position to fill as soon as possible
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 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
- dbt experience
Requirements
undetermined
undetermined
undetermined
undetermined
Other S.i. Systems's offers that may interest you