Talent.com
S.i. Systems
Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operationsS.i. Systems • Toronto
Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations

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

S.i. Systems • Toronto
30+ days ago
Job type
  • Full-time
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:

  • Experience with Tableau or PowerBI
  • Knowledge of revenue management concepts
  • dbt experience


Create a job alert for this search

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

Similar jobs

BI Engineer

AdastraMarkham, Ontario, Canada
Full-time

Develop and maintain data pipelines, ensuring robustness, reliability, and scalability.Utilize your strong SQL skills to extract, transform, and load data from various sources into our data warehou... Show more

 • Promoted

Remote Analytics Data Engineer Role

SwoonToronto, ON, CA
Remote
Full-time

Explore a dynamic Remote Analytics Data Engineer position focused on Treasury and Finance.Utilize your programming and data engineering skills to influence business strategies through data insights... Show more

 • Promoted

Hybrid Analytics Engineer Ii — Data Pipelines & Dashboards - C$74,500 - C$111,700 Par An

TD BankToronto, Canada
Full-time

Conception et maintenance de solutions analytiques, création de rapports et tableaux de bord pour décisions commerciales. Show more

 • Promoted • New!

Senior Bi Visualization & Analytics Lead - C$70 - C$80 An Hour

TMX GroupNorth York, Canada
Full-time

This role involves designing BI solutions, managing Tableau, mentoring developers, and requires 7+ years of Tableau experience. Show more

 • Promoted

Data Engineer - Analytics Pipelines & Power BI (Hybrid)

AccentureToronto, ON, CA
Full-time

A global technology consulting firm in Toronto is seeking a Data Engineer to support large-scale infrastructure programs.This role involves designing data transformation frameworks for analytics-re... Show more

 • Promoted

Analytics Lead, LUS

LyftToronto, ON, CA
Full-time

At Lyft, our purpose is to serve and connect.We aim to achieve this by cultivating a work environment where all team members belong and have the opportunity to thrive.Data and analytics are at the ... Show more

 • Promoted

BI Data Engineer

Jonas Club SoftwareMarkham, York Region, CA
Full-time

We are seeking a Development Analyst to join our Business Intelligence and Reporting team.You will design, build, and optimize BI assets—dashboards, reports, data models—primarily using AWS QuickSi... Show more

 • Promoted

Analytics Engineer

Unchain Datatoronto, on, Canada
Full-time

Our mission is to democratize finance for all.An estimated $124 trillion of assets will be inherited by younger generations in the next two decades—the largest transfer of wealth in human history.W... Show more

 • Promoted

Azure Data Engineering & Bi Lead (Databricks) - C$82,544 - C$110,058 A Year

Anishinabek Employment & Training ServicesToronto, Canada
Full-time

A non-profit organization in Toronto seeks a Data Engineering and BI Systems Lead to manage and optimize their business intelligence systems in Azure.This role involves overseeing enterprise data i... Show more

 • Promoted • New!

BI Analyst III | Data Visualization & Strategy Lead Toronto

TD SecuritiesToronto, ON, CA
Full-time

A leading financial services firm in Toronto is seeking a Business Intelligence Analyst III to support BI initiatives and develop reporting tools.The role requires strong SQL and Python skills, kno... Show more

 • Promoted

Bi Engineer

AdastraMarkham, Canada
Full-time

Responsibilities:Develop and maintain data pipelines, ensuring robustness, reliability, and scalability.Utilize your strong SQL skills to extract, transform, and load data from various sources into... Show more

 • Promoted

Senior OBIEE & Analytics BI Specialist | Oracle Expert

BevertecToronto, ON, CA
Full-time

A prominent consulting firm is seeking a Senior Business Intelligence Specialist to work onsite in Toronto.The ideal candidate will have extensive experience with OBIEE and related Oracle analytics... Show more

 • Promoted

Manager BI & Analytics

Rogers Communications, Inc.Toronto, Ontario, Canada
Full-time +1

We are committed to connecting Canadians through unique partnerships, our world‑class network and content Canadians love—and our innovative team is growing.We are looking for dedicated team members... Show more

 • Promoted

Power Bi Developer: Energy Analytics & Dashboards - C$56.3 - C$66.3 An Hour

Canadian energy organizationToronto County, Canada
Full-time

Develops and designs Power BI reports, dashboards, and data models for energy analytics.Requires advanced Power BI and SQL skills, collaboration with stakeholders, and an agile work environment. Show more

 • Promoted • New!

SAS Analyst — Banking Data & BI Specialist

RedPicoToronto, ON, CA
Full-time

A financial services company is seeking a highly proficient SAS Analyst in downtown Toronto.The role involves developing complex data analysis, creating Power BI dashboards, and optimizing SQL quer... Show more

 • Promoted

Power BI Lead - Enterprise Analytics & Dashboards

Tata Consultancy ServicesToronto
Full-time

A leading IT services provider is looking for a Talent Acquisition Specialist in Toronto, Ontario.This full-time role involves designing and delivering Power BI dashboards and collaborating with bu... Show more

 • Promoted

Data Solutions Consultant: ETL, BI & AI

KlickToronto, ON, CA
Full-time

A leading healthcare analytics firm in Toronto is seeking an experienced analytics professional to join their team.You will design and maintain data architecture, develop data pipelines, and work c... Show more

 • Promoted

Senior Business Intelligence & Analytics Lead

Livingston InternationalToronto, ON, CA
Full-time

A leading logistics firm located in Toronto is seeking a Senior Analyst, Business Intelligence and Analytics.This role involves transforming data into insights, collaborating across teams to enhanc... Show more

 • Promoted

BI Analyst (Multiple Openings)

Tundra Technical SolutionsToronto, ON, CA
Temporary

Tundra Technical Solutions provided pay range.This range is provided by Tundra Technical Solutions.Your actual pay will be based on your skills and experience — talk with your recruiter to learn mo... Show more

 • Promoted

Senior FP&A Analyst | Hybrid Toronto | Power BI & Forecasting

Glass, Lewis & Co.Toronto, ON, CA
Full-time

A leading financial services provider is seeking a Senior FP&A Analyst to support strategic decision-making through financial reporting and analysis.This hybrid role based in Toronto requires 3-5 y... Show more