Microsoft Data & AI Engineer

Job Description

You will help clients build modern, reliable, and AI-ready data platforms using the full Microsoft stack. You balance hands-on delivery with strategic advisory, and you work in hybrid environments where legacy systems meet modern cloud architectures. If you are passionate about data engineering, analytics, and the future of AI in enterprise environments, we’d love to meet you.

What you will do : 

• Design and build ELT/ETL pipelines across the Microsoft stack — from on-prem SSIS workflows to Azure Data Factory and Microsoft Fabric;
• Model and maintain semantic layers in Power BI (DAX, RLS, deployment pipelines, Apps) that serve as the single source of truth for reporting;
• Migrate and modernise BI environments: SQL Server → Synapse Analytics / Microsoft Fabric / ADLS Gen2 / OneLake;
• Implement Analytics Engineering standards: data testing, documentation, version control, and performance tuning (T-SQL optimisation, stored procedures);
• Support clients in defining their data modeling strategy (Kimball / Inmon) and analytical architecture;
• Prototype and evaluate emerging capabilities — Copilot Studio, Azure AI Services, Azure AI Foundry — and translate them into production-ready recommendations.

Qualifications

Must-have:

• At least 3 years of hands-on experience;
• T-SQL (optimization, stored procedures, functions);
• Power BI Desktop and Service (DAX, RLS, Apps);
• Data warehousing : proficiency in modeling concepts(Kimball/Inmon);
• On-Prem stack : SQL Server, SSIS, SSAS;
• Cloud stack : Azure Data Factory (ADF), Azure Synapse Analytics, Microsoft Fabric;
• Storage : ADLS Gen2, OneLake;
• AI Integration : Copilot Studio,  Azure AI Services;
• Fluent in both English and French (spoken and written).

Soft skills:
Analytical thinker • Structured & autonomous • Clear communicator • Curious and proactive

Nice-to-have
Databricks • Azure AI Foundry • Python/PySpark • dbt (Data Build Tool) • Microsoft/DBT certifications (DP-600, PL-300, DP-700, DP-203

Additional Information

Life at Devoteam ✨

Join a community where technology meets humanity. We believe that a job should be more than just a to-do list; it should be a place where you grow, connect, and make an impact. With us, you will find: 

• 🚀 A playground for innovation: You will work with the latest Microsoft tech (Fabric, Copilot, Azure AI) to build future-proof solutions. This is your chance to stay ahead of the curve.
• 🤝 A culture of connection: We are 140+ tech enthusiasts from 30+ countries. We don't just work together; we celebrate diversity and win together.
• 📈 Continous growth: Between our Training Center, certifications, and mentoring, we take your development seriously. Your ambition sets the pace.
• 🌱 Meaningful impact: Through the Devoteam Foundation, your skills can serve social causes and sustainability initiatives.

Who thrives here? 💡

We are looking for problem-solvers who turn challenges into elegant solutions and curious minds who never stop learning. If you love combining deep technical work with human interaction, you will fit right in.

Devoteam stands for equal opportunities. We are convinced that diversity contributes to the creativity, dynamism, and excellence of our organization. All our positions are open to people with disabilities.