Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting
S.i. Systems
Toronto, ON- Salary To be discussed
-
Contract job
-
Published since 3 weeks ago
-
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
AI may be used in evaluating candidates.
Apply
Requirements
Level of education
undetermined
Diploma
undetermined
Work experience (years)
undetermined
Written languages
undetermined
Spoken languages
undetermined
Other S.i. Systems's offers that may interest you