Cloud BI Modernization Analytics Engineer (SQL & Modeling)

Alquemy; Kelowna; On-site; CAD 90,000 - 130,000; Full time

Job summary

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 collaborate with BI, analytics, and data engineering teams to ensure accurate, timely insights.

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.

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.

Skills

SQL

Data modeling

Semantic modeling

Data quality

Education

Bachelor's degree in CS / IS / Data / Analytics / Engineering

Tools

GCP BigQuery

dbt Semantic Layer

LookML

Power BI

Tableau

Cognos

Git

Alteryx

Job description

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 collaborate with BI, analytics, and data engineering teams to ensure accurate, timely insights.