Power BI Backend Data Engineer

Job Title: Power BI Backend Data Engineer (French description will follow)

Location: Montreal

Work Model: Hybrid – On‑site Tuesdays and Wednesdays

Workload: 35 hours/week

Start Date: as soon as possible

Language: English‑only accepted, bilingual (French) an asset

Salary: $80k

📌 About the Role

Astek Canada is seeking an experienced Power BI Backend Data Engineer to strengthen an established BI team.

This role is primarily focused on backend data modeling, SQL performance, and Azure SQL, while ensuring the reliability and performance of Power BI datasets and reports.

🎯 Your Responsibilities

Backend / Data Engineering (70%)

• Build and optimize BI data models following best practices:
• fact and dimension tables
• grain definition
• relationships between facts and dimensions
• Translate business rules into robust data models
• Work with Microsoft Azure SQL Database:
• update and optimize views
• develop and maintain stored procedures
• handle complex joins and aggregations
• Fix and stabilize backend logic affecting KPIs
• Optimize SQL performance to:
• improve dataset refresh times
• strengthen dataset reliability
• Investigate root causes of:
• incorrect KPIs
• failed refreshes
• data inconsistencies

Power BI (30%)

• Maintain and validate Power BI datasets
• Ensure the semantic model remains coherent and accurate
• Monitor dataset refreshes and resolve incidents
• Troubleshoot Power BI reports and datasets
• Guarantee the overall integrity of data consumed by end‑users

🧠 What You Bring

Education / Experience

• Proven experience as a Data Engineer or BI Engineer
• Comfortable in a hybrid backend / Power BI role

Key Skills

• Strong expertise in:
• dimensional modeling (facts, dimensions, grain)
• SQL (complex queries, performance optimization)
• Microsoft Azure SQL Database
• Solid knowledge of Power BI:
• datasets
• data modeling
• refresh pipelines
• troubleshooting
• Ability to translate business needs into reliable technical solutions

Personal Qualities

• Autonomous, structured, and detail‑oriented
• Analytical mindset with strong problem‑solving skills
• Strong data quality and reliability mindset
• Comfortable working in an English‑speaking environment

🎁 Astek Benefits

• Personalized CARE plan for employees
• Social activities (5@7, team buildings)
• Diversity & Inclusion charter
• Professional development opportunities

🚀 Why Join Us?

Astek is an international technology consulting group bringing together nearly 10,000 experts worldwide. We support our clients on complex, concrete, and high‑value digital projects.

In Canada, our teams work on strategic IT and engineering mandates: software development, data, cloud, cybersecurity, and digital transformation. We collaborate with leading companies on long‑term, large‑scale initiatives.

At Astek, there’s no empty corporate talk:

• real projects with real technical challenges
• a professional, human, and collaborative environment
• room for your expertise, your growth, and your ideas

Joining Astek means becoming part of a committed and accessible team where your impact is visible and your career can genuinely grow.

Ready to take on the challenge?

We offer an extensive range of employee benefits, including:

• a comprehensive and competitive group insurance plan
• public transit reimbursement
• cell phone plan/device reimbursement
• reimbursement of professional association fees (e.g., OIQ)
• annual allowance for sports/physical activities
• annual allowance for computer equipment
• a motivating employee referral program

Titre de poste : Power BI Backend Data Engineer

Localisation : Montréal

Mode de travail : Hybride – Présence au bureau requise mardi et mercredi

Rythme: 35 heures/semaine

Début : dès que possible

Langue : Anglais unilingue accepté, bilingue français un atout

Salaire : 80k

📌 À propos du poste

Pour le compte de notre client, Astek Canada recherche un(e) Power BI Backend Data Engineer expérimenté(e) afin de renforcer une équipe BI dynamique.

Le rôle sera fortement orienté backend (modélisation, SQL, Azure) tout en assurant la fiabilité et la performance des datasets et rapports Power BI.

🎯 Vos responsabilités

Backend / Data Engineering (70%)

• Modéliser les données selon les bonnes pratiques BI :
• tables de faits et dimensions
• définition du grain
• relations entre faits et dimensions
• Traduire les règles métiers dans le modèle de données
• Intervenir sur Microsoft Azure SQL Database :
• modification de vues
• stored procedures
• jointures, agrégations
• Corriger et fiabiliser la logique backend affectant les KPIs
• Optimiser les performances SQL pour :
• améliorer les temps de rafraîchissement
• stabiliser les datasets
• Identifier les causes racines :
• KPIs erronés
• échecs de rafraîchissements
• incohérences de données

Power BI (30%)

• Maintenir et valider les datasets Power BI
• Vérifier la cohérence du modèle sémantique
• Surveiller les rafraîchissements et résoudre les incidents
• Dépanner les