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. Company Description Devoteam is an AI-driven tech consulting firm with nearly 30 years of expertise in cloud platforms, data, cyber and sustainable digital transformation. With 11,000 tech professionals across 25+ countries, we leverage technology to create real value for people and organisations. As a leading Microsoft Partner in EMEA—1200+ Microsoft experts, 6 solution designations and 18 advanced specialisations—we support clients at every stage of their cloud and AI journey. From Azure architecture to managed services and AI-powered modernisation, we help organisations accelerate their transformation and build a future-proof digital ecosystem.