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

Process Improvement Analyst — Power BI & Ops Optimizer

Finning International Inc. • Edmonton

Full-time +1

A leading remanufacturing firm is seeking a Process Improvement Analyst to optimize processes and drive meaningful change. This permanent role requires expertise in project management, data analysis...Show more

Last updated: 26 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: 26 days ago • Promoted

Business Analyst III - Empire Life

Empire Life • edmonton, ab, ca

Full-time +2

Empire Life is looking to hire a Business Analyst III to join our Group Initiatives team! We are actively seeking candidates to fill a current, open position. The total target compensation (TTC) ran...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: 5 days ago • Promoted

Senior BI Reporting & Data Visualization Specialist

Vantix Systems Inc. • Calgary, Edmonton

Full-time

A leading company in the data solutions sector seeks a seasoned professional for reporting and dashboard development.In this role, you will focus on developing and maintaining SSRS reports and Powe...Show more

Last updated: 5 days ago • Promoted

Strategic BI Analyst : Public Safety Insights

City of Edmonton • Edmonton

Full-time

A municipal government is seeking a Methods Analyst II to conduct strategic analyses and develop business intelligence solutions. This role involves transforming data into actionable insights, desig...Show more

Last updated: 5 days ago • Promoted

Power BI & Data Insights Analyst

Vantix Systems Inc. • Edmonton

Full-time

A leading business intelligence firm in Canada is searching for a skilled data analyst to deliver insights using Power BI and collaborate with internal and external stakeholders.The candidate shoul...Show more

Last updated: 5 days ago • Promoted

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: 5 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: 5 days ago • Promoted

Intermediate BI Analyst (onsite)

Vantix Systems Inc. • Edmonton

Full-time

Contribute as part of a team, responsible for delivering business intelligence capabilities to support internal and external department stakeholders’ information needs. Deliver work products based o...Show more

Last updated: 5 days ago • Promoted

Power BI Reporting Analyst : Real-Time Project Insights

Turner & Townsend • Edmonton

Full-time

A leading global professional services company is seeking an experienced Program Reporting Analyst in Edmonton, Canada.This role requires expertise in Power BI and SQL, focusing on developing dashb...Show more

Last updated: 5 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: 5 days ago • Promoted

Business Analyst III

Empire Life • edmonton, ab, ca

Full-time +2

Last updated: 30+ 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: 5 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: 5 days ago • Promoted

BI Reporting Specialist

Vantix Systems Inc. • Calgary, Edmonton

Full-time

Reporting & Dashboard Development.Manage report development cycles including testing, stakeholder sign-off, and migration to production. Create visually appealing dashboards beyond the standard Powe...Show more

Last updated: 5 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: 26 days ago • Promoted