Analytics Engineer, BI Modernization

6 hours ago
Kelowna, British Columbia, Canada Alquemy Full-time

Analytics Engineer, BI Modernization Overview

We are seeking an Analytics Engineer to support the modernization of legacy reporting and analytics capabilities into a governed, cloud-based architecture. This is a hands-on, SQL-heavy role focused on analytical data modeling, semantic layers, data quality, and BI modernization.

Key Responsibilities

  • Develop complex SQL queries, views, and reusable analytical datasets.
  • Build and maintain analytical, dimensional, and semantic data models.
  • Translate business and reporting requirements into scalable, governed data solutions.
  • Optimize SQL and analytical models for performance, scalability, and reuse.
  • Develop shared metrics, calculations, business rules, and semantic models.
  • Support migration and modernization of legacy BI, reporting, and analytics platforms.
  • Analyze legacy reports, SQL, workflows, calculations, and data dependencies as needed.
  • Simplify and consolidate duplicated legacy logic into reusable modern solutions.
  • Validate modernized outputs and investigate data or business-rule discrepancies.
  • Apply Git, version control, peer review, documentation, testing, and controlled deployment practices.
  • Collaborate with BI, analytics, data engineering, and business teams.

Required Qualifications

  • 5+ years of experience in Analytics Engineering, BI Engineering, Data Engineering, or a related field.
  • Strong experience developing complex SQL queries, views, and reusable datasets.
  • Experience with dimensional and analytical data modeling, including facts, dimensions, grain, measures, and relationships.
  • Experience with relational databases and cloud-based analytical platforms.
  • Experience with BI modernization, reporting migration, or legacy platform transformation.
  • Strong analytical, troubleshooting, validation, documentation, and communication skills.

Technical Skills

  • Expert-level SQL, including complex joins, CTEs, window functions, aggregations, and query optimization.
  • Strong analytical, dimensional, and semantic modeling skills.
  • Experience with cloud data platforms;GCP/BigQuery preferred.
  • Experience with semantic or metrics layers such as Cube, dbt Semantic Layer, LookML, or similar technologies preferred.
  • Experience with BI tools such as Cognos, Alteryx, Tableau, or Power BI is an asset.
  • Proficiency with Git/version control and modern development practices.
  • Experience using AI-assisted development tools for SQL, coding, documentation, analysis, or troubleshooting is preferred.

Education

Bachelor’s degree in Computer Science, Information Systems, Data, Analytics, Engineering, or a related field preferred. Equivalent professional experience will be considered.

  • Cloud BI Modernization Analytics Engineer

    2 hours ago

    Kelowna, British Columbia, Canada Alquemy Full-time

    Alquemy is seeking an Analytics Engineer to modernize legacy reporting into a governed, cloud-based architecture. The role is SQL-heavy and focuses on analytical data modeling, semantic layers, data quality, and BI modernization.You will develop complex SQL, build analytical models, translate requirements into scalable, governed data solutions, and...

  • Senior Software Engineer, Frontend

    3 days ago

    Kelowna, British Columbia, Canada Affirm Full-time

    AtAffirm, we exist for the moments that matter—giving people a clear, predictable way to pay over time, with no hidden fees, no surprises, and no tradeoffs on what matters most.Marketing & Privacy Engineering (MPE) builds trusted, privacy-aware consumer web experiences and measurement systems that enable sustainable growth. Within MPE, the Marketing pillar...

  • Software Engineer II, Frontend

    2 hours ago

    Kelowna, British Columbia, Canada Affirm Full-time

    At affirm, we exist for the moments that matter—giving people a clear, predictable way to pay over time, with no hidden fees, no surprises, and no tradeoffs on what matters most. Marketing & Privacy Engineering (MPE) builds trusted, privacy‑aware consumer web experiences and measurement systems that enable sustainable growth. Within MPE, the MarTech...

  • Intermediate Civil Engineer

    7 days ago

    Kelowna, British Columbia, Canada PRI Consultants Full-time

    PRI ENGINEERING Intermediate Civil Engineer Delivering civil design work across land development, municipal infrastructure, and site servicing projects Location: Kelowna, BC Full-time, permanent About the opportunity PRI is seeking an Intermediate Civil Engineer (P.Eng.) to join our Civil practice. This is a hands-on design and project-delivery role for a...

  • Software Engineer II, Frontend

    5 days ago

    Kelowna, BC, Central Okanagan Regional District, BC; British Columbia, Canada Affirm Full-time €133,000 - €183,000 Temporary

    At affirm, we exist for the moments that matter—giving people a clear, predictable way to pay over time, with no hidden fees, no surprises, and no tradeoffs on what matters most. Marketing & Privacy Engineering (MPE) builds trusted, privacy‑aware consumer web experiences and measurement systems that enable sustainable growth. Within MPE, the MarTech...

  • Senior Product Coordinator

    3 days ago

    Kelowna, British Columbia, Canada Okanagan College Full-time $35 - $40 Permanent

    When you join Okanagan College, you’re joining a team that’s transforming lives and communities. Every course you create, every student you support and every connection you build, it all matters. Be a part of a vibrant campus community, where the work you do every day truly makes a difference. Desired Start Date: November 16, 2026 Appointment End...

  • Intermediate Civil Engineer

    1 week ago

    Kelowna, British Columbia, Canada Proven Full-time

    PRI ENGINEERING Intermediate Civil Engineer Delivering civil design work across land development, municipal infrastructure, and site servicing projects Location: Kelowna, BC Full-time, permanent About The Opportunity PRI is seeking an Intermediate Civil Engineer (P.Eng.) to join our Civil practice. This is a hands-on design and project-delivery role...

  • Intermediate Civil Engineer

    1 week ago

    Kelowna, British Columbia, Canada PRI Engineering Full-time

    PRI ENGINEERING Intermediate Civil Engineer Delivering civil design work across land development, municipal infrastructure, and site servicing projects Location: Kelowna, BC Full-time, permanent About The Opportunity PRI is seeking an Intermediate Civil Engineer (P.Eng.) to join our Civil practice. This is a hands-on design and project-delivery role...

  • Project Controls Analyst

    2 hours ago

    Kelowna, British Columbia, Canada WSP in Canada Full-time

    Job Description What if you could redefine what’s possible? With us, you can. You want Purpose. Growth. Opportunity. People who get it. We are the home of ambitious, passionate, and innovative world shapers. With an unmatched breadth and depth of engineering, advisory and science-based expertise, our global minds unite to power local solutions. We are...

  • Senior Software Engineer, Frontend

    1 week ago

    Kelowna, BC, Central Okanagan Regional District, BC; British Columbia, Canada Affirm Full-time €153,000 - €213,000 Temporary

    AtAffirm, we exist for the moments that matter—giving people a clear, predictable way to pay over time, with no hidden fees, no surprises, and no tradeoffs on what matters most. Marketing & Privacy Engineering (MPE) builds trusted, privacy-aware consumer web experiences and measurement systems that enable sustainable growth. Within MPE, the Marketing...

Similar jobs in Kelowna

Top cities