Talent.com
S.i. Systems
Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operationsS.i. Systems • Ottawa
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 • Ottawa
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 • Ottawa

Similar jobs

Senior Data & Analytics Engineer

WagepointOttawa, ON, CA
Full-time

Senior Data & Analytics Engineer.This range is provided by Wagepoint.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.At Wagepoint, we’re good pe... Show more

 • Promoted

Data Insights Analyst — Bi & Informatics (Flexible) - C$81,600 - C$130,400 A Year

Telecommunications LeaderOttawa, Canada
Full-time

Analyze complex datasets and develop dashboards using Power BI for a telecommunications leader in Ottawa.Requires 3-5 years of experience and proficiency in Power BI, SQL, and Alteryx. Show more

 • Promoted

Snowflake Data Architect: Lead Analytics & AI Solutions

EYOttawa, ON, CA
Full-time

A global consulting firm is seeking a Snowflake Data Architect to lead projects and develop innovative data solutions.The role requires strong technical leadership and a proven track record in data... Show more

 • Promoted

Mining Project Reporting Analyst — Power BI

Phase ConsultingOttawa, ON, CA
Full-time

A leading consulting firm is seeking a Reporting Specialist to support major mining and construction projects.The role involves consolidating data, delivering actionable insights, and building dash... Show more

 • Promoted

Python & Kubernetes Data Engineer for AI/ML Analytics

CanonicalOttawa, ON, CA
Full-time

Join a pioneering tech firm at the forefront of the open-source movement.As a Python and Kubernetes Software Engineer, you'll develop cutting-edge data analytics solutions using popular machine lea... Show more

 • Promoted

Python & Kubernetes AI/ML Data Engineer — Remote/Distributed

CanonicalOttawa, ON, CA
Remote
Full-time

Canonical, a leader in open source software, seeks a Python and Kubernetes Software Engineer focused on Data, AI/ML, and Analytics Solutions.Collaborate on end-to-end data analytics solutions and c... Show more

 • Promoted

Senior AI Agent Engineer: Deploy & Integrate

CrestaOttawa, ON, CA
Full-time

A leading AI technology company in Canada is seeking an AI Agent Engineer to develop and deploy intelligent AI agents.The ideal candidate will have a strong background in software development and A... Show more

 • Promoted

BI Developer Co-op: Analytics & Data Warehouse (Ottawa)

EricssonOttawa, ON, CA
Full-time

A leading technology firm in Ottawa seeks a Business Intelligence Developer co-op for an 8 to 16-month term.The role involves analytics, building software on a large data warehouse, and data extrac... Show more

 • Promoted

Senior Data Engineer - Cloud ETL & BigQuery Expert (Remote)

ShyftLabsOttawa, ON, CA
Remote
Full-time

A growing data product company in Canada is looking for an experienced Data Engineer to join its dynamic team.The candidate will design and maintain scalable ETL pipelines, oversee data infrastruct... Show more

 • Promoted

Senior Analytics Developer

CNNottawa, on, Canada
Full-time

Discovery… the stuff dreams are made of.When we say, “the stuff dreams are made of,” we’re not just referring to the world of wizards, dragons and superheroes, or even to the wonders of Planet Eart... Show more

 • Promoted

AI and Data - Manager - Solution Architect/Tech Lead

EYottawa, on, Canada
Full-time

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you.And we’re counting on your u... Show more

 • Promoted

Business Analyst/Data Engineer - Life Sciences/Pharma Industry Exp - 8+ Years of exp

Cygnus Professionals Inc.Ottawa, ON, CA
Part-time

Business Analyst/Data Engineer - Life Sciences/Pharma Industry Exp - 8+ Years of exp.Be among the first 25 applicants.Direct message the job poster from Cygnus Professionals Inc.This is a contract ... Show more

 • Promoted

Senior Integrations Engineer: Cloud Data Pipelines

PlanHubOttawa, ON, CA
Full-time

A leading pre-construction SaaS platform is looking for a developer to design and maintain cloud-native systems.The ideal candidate will have expertise in AWS services and experience building robus... Show more

 • Promoted

Remote Data Analytics Scientist – AI & Dashboards

Handis Consulting Inc.Ottawa, ON, CA
Remote
Full-time

A consulting firm is seeking a Data Analytics Specialist for a one-year full-time contract in Edmonton, Canada.The role involves providing leadership on data initiatives, engaging with internal and... Show more

 • Promoted

Senior Data Analyst, Customer Success — Forecasts

SurveyMonkeyOttawa
Full-time

A leading survey platform company located in Ottawa is seeking a Senior Data Analyst to shape customer experience and success.The ideal candidate will lead forecast reporting, design scalable repor... Show more

 • Promoted

Data Engineer: Snowflake Pipelines & Power BI (Hybrid)

SynechronOttawa, ON, CA
Full-time

Une entreprise de conseil numérique recherche un spécialiste pour migrer des données vers Snowflake, impliquerait la conception de pipelines de données et l'écriture de scripts Python.Les candidats... Show more

 • Promoted

Senior Data Engineer: Build and Scale Innovative Data Solutions

LumenaltaOttawa, ON, CA
Full-time

Embrace an exciting opportunity as a remote Senior Data Engineer.Lead the charge in building scalable data solutions, utilizing Databricks on AWS for impactful results.This mid-senior level positio... Show more

 • Promoted

Senior Data & Analytics Engineer - Remote, Azure

WagepointOttawa, ON, CA
Remote
Full-time

A leading payroll software company in Canada is seeking a Senior Data & Analytics Engineer to tackle complex data challenges and build scalable data systems.The ideal candidate will design and impl... Show more

 • Promoted

Power BI & Data Insights Analyst - Remote Canada

Source CodeOttawa, ON, CA
Remote
Full-time

A technology consulting firm is seeking an Int.Business Intelligence Analyst in Edmonton.The role focuses on delivering BI solutions using Power BI, requiring strong skills in data analysis, visual... Show more

 • Promoted

Strategic BI Lead, Healthcare Data Transformation (Remote)

Odyssey GlobalOttawa, ON, CA
Remote
Full-time

A government healthcare project is seeking an experienced Business Intelligence Lead to champion the design and implementation of a comprehensive BI framework.This role requires over 10 years of ex... Show more