This recruiter is online.

This is your chance to shine!

Apply Now

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

Toronto, ON
  • Number of positions available : 1

  • To be discussed
  • Contract job

  • Starting date : 1 position to fill as soon as possible

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
Apply

Requirements

Level of education

undetermined

Work experience (years)

undetermined

Written languages

undetermined

Spoken languages

undetermined