Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reportingS.i. Systems • Edmonton

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

S.i. Systems • Edmonton

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 Engineer • Edmonton

Similar jobs

Billing Analyst

Seaboard Transport Group • Sherwood Park, AB, Canada

Full-time

Revenue & Settlements Analyst.This intermediate-level role focuses on reviewing, processing, and auditing customer invoices and driver settlements to ensure alignment with contracts, completed ...Show more

Last updated: 4 days ago • Promoted

BI Developer

Stantec • Edmonton

Full-time +1

Get AI-powered advice on this job and more exclusive features.At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best.Our business teams ...Show more

Last updated: 30+ days ago • Promoted

Intermediate Data Engineer

AltaML • Edmonton

Full-time

At AlphaLayer, we help institutional investors uncover investment edge at scale with a repeatable research process that leverages core technology, data, and AI to develop differentiated investment ...Show more

Last updated: 11 days ago • Promoted

Senior Business Analyst Cybersecurity (Remote)

Amaris Consulting • Edmonton, Alberta, Canada

Remote

Full-time

Le candidat idéal aura une solide connaissance des écosystèmes AWS, des concepts de cybersécurité et des meilleures pratiques de l’industrie, avec une expérience dans le secteur des assurances en t...Show more

Last updated: 15 hours ago • Promoted • New!

Business Intelligence Analyst - Intermediate

Handis Consulting Inc. • Edmonton

Full-time

Contract- 6 month (up to 6 month extension).Our public sector client is seeking an Intermediate Business Intelligence Analyst for a 6-month, full time contract, with the possibility of up to a 6-mo...Show more

Last updated: 12 days ago • Promoted

Senior Cognos BI Specialist (Level III) – Hybrid Role

First Canadian Financial Group • Sherwood Park

Full-time

A financial services company in Sherwood Park, Alberta, is seeking a Business Intelligence Specialist Level III (Cognos). This role involves creating and managing BI solutions, delivering corporate ...Show more

Last updated: 11 days ago • Promoted

Insurance Analytics & Insights Analyst

Acord (association For Cooperative Operations Research And Development) • Edmonton

Full-time

A leading cooperative organization in Canada seeks an Analyst, Business Analysis to join their Finance team within Insurance Services. This role involves analyzing data trends, collaborating with te...Show more

Last updated: 3 days ago • Promoted

Senior Manager, CRC Data & Analytics — Global Impact

KPMG Canada • Edmonton

Full-time

A leading global consulting firm seeks a Senior Manager for its Canadian Resource Centre specializing in Data and Analytics. The ideal candidate will have over 8 years of experience in public accoun...Show more

Last updated: 12 days ago • Promoted

BI Developer

Stantec Consulting International Ltd. • Edmonton

Full-time +1

At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best.Our business teams include finance, procurement, human resources, information tec...Show more

Last updated: 12 days ago • Promoted

BI Developer – Data Warehouse & Dashboards

Stantec • Edmonton

Full-time

A global engineering firm seeks a BI Developer in Edmonton, Canada.The ideal candidate will have experience in database development, data warehousing, and business intelligence tools like Oracle an...Show more

Last updated: 12 days ago • Promoted

Senior Data Engineer

Targeted Talent • Edmonton, AB, Canada

Permanent

We are looking for an experienced.This is a permanent position that is completely remote! Our client is a global enterprise company with a product that you've likely used.Within this role, you&...Show more

Last updated: 30+ days ago • Promoted

Senior BI Analyst

Targeted Talent • Edmonton, AB, Canada

Permanent

We are looking for an experienced.Our client is a global enterprise company with a product that you've likely used.This is a really exciting opportunity to work for a company whose product is u...Show more

Last updated: 30+ days ago • Promoted

Power BI Lead & Data Analytics Specialist

Synechron • Edmonton

Full-time

A global digital consulting firm is seeking a Senior Recruitment Associate in Edmonton to leverage Power BI for data analytics, developing dashboards and visualizations. Candidates should have exten...Show more

Last updated: 12 days ago • Promoted

BI Solutions Developer — Data Warehousing & Dashboards

Stantec Consulting International Ltd. • Edmonton

Full-time

A global engineering firm located in Canada is seeking a BI Developer to translate business needs into intelligence solutions through data modeling and reporting. The ideal candidate should have ove...Show more

Last updated: 30+ days ago • Promoted

Data Analyst

TSG Staffing Services • Edmonton

Full-time

TSG Staffing Services provided pay range.This range is provided by TSG Staffing Services.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Fort Sa...Show more

Last updated: 11 days ago • Promoted

Manager, Data & Analytics (Decision Sciences)

eLocal • Edmonton, Alberta, Canada

Full-time

Manager, Data & Analytics (Decision Sciences).Remote (Applicants must reside in one of the following Canadian provinces : Alberta, British Columbia, Nova Scotia, or Ontario).Local, part of Brookfiel...Show more

Last updated: 23 hours ago • Promoted

Insurance Analytics & Insights Analyst

Casualty Actuarial Society • Edmonton

Full-time

A financial services organization in Edmonton is looking for a Business Analysis Analyst to join their Finance team.The role involves analyzing trends and assisting in corporate reserving decisions...Show more

Last updated: 3 days ago • Promoted

Senior Business Analyst Cybersecurity (Remote) - Amaris Consulting

Amaris Consulting • edmonton, ab, ca

Remote

Full-time

Last updated: 21 hours ago • Promoted • New!