Senior Data Consultant - Power BI & Databricks

🌟 Why Keyrus, Why Now! Keyrus is an international group of 2,800 consultants and experts across 28 countries, built on a single conviction: AI does not transform businesses. Architected intelligence does. For more than 30 years, we have been building the data foundations that make intelligent systems work — designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value: we operationalise intelligence. AI does not replace humans. It repositions us to a place no system can follow: understanding, deciding, designing, and creating. At Keyrus, you will not just develop skills - you will develop judgment. Your expertise sharpens with every system you architect, every client challenge you solve, every deployment that compounds on the last. Over time, you grow into one of the rarest professionals of the intelligence era: someone who bridges data, AI, and human decision-making at scale, across industries and geographies. This is not a role you fill. It is a discipline you master and a story you help write to become a Keyrus Architect of Intelligence. Technology amplifies. Keyrus culture differentiates. Industrial discipline connects the two. 📍 Location: Hybrid – Toronto or Montreal, Canada (2 days per week on-site) 💼 Contract: Permanent, Full-time WHAT YOU'LL ARCHITECT: Keyrus North America (NORAM) is looking for a Senior Data Consultant to support a high-demand data and analytics environment, with a strong focus on Power BI development, Databricks engineering, and production support.This role is critical to maintaining and enhancing a live analytics ecosystem, requiring a consultant who can operate independently, troubleshoot complex issues, and deliver high-quality outputs under scrutiny. Power BI Development Design, build, and maintain enterprise-grade Power BI dashboards and reports Work closely with business stakeholders to translate requirements into scalable data models Optimize report performance (DAX, model design, query folding, etc.) Support and enhance reporting pipelines connected to Databricks and other sources Contribute to/report via MCP server-based report development workflows Databricks Development Develop and maintain data pipelines and transformations in Databricks Work with structured and semi-structured data sources Support medallion-style architectures (Bronze/Silver/Gold) Troubleshoot data quality, performance, and pipeline issues Contribute to evolving data engineering practices including AI-assisted/agentic workflows QA, Gap Analysis & Troubleshooting Perform QA validation across reports and data pipelines Identify gaps between business expectations and delivered outputs Act as a problem solver for production issues, often under tight timelines Ensure consistency, reliability, and trust in reporting outputs Cross-Functional Delivery Work directly with business users and technical teams Own deliverables end-to-end with minimal oversight Support solution design, enhancements, and continuous improvement Contribute to documentation, standards, and best practices QUALIFICATIONS: • Strong experience with Power BI development (data modeling, DAX, optimization) • Hands-on experience with Databricks (PySpark, Python, SQL, notebooks) • Solid understanding of modern data architectures (lakehouse / medallion) • Strong SQL and data engineering skills • Experience with Azure DevOps, CI/CD, and version control best practices • Familiarity with distributed data environments and data pipeline orchestration • Exposure to AI-assisted or agentic AI workflows in data engineering environments • Excellent problem-solving and stakeholder communication skills • Highly autonomous with strong attention to detail and quality Nice to have: • Experience with MCP or similar orchestration frameworks • Consulting experience in demanding client environments • Experience supporting migrations, divestitures, or complex transformation initiatives • Exposure to support/run environments and delivery coordination • Familiarity with SAP Datasphere Technology Stack: Databricks, Power BI, Python, SQL, Azure DevOps, SAP Datasphere WHAT WE OFFER AT KEYRUS: A stimulating environment where you will be able to surpass yourself and discover new horizons; A strong culture of innovation and entrepreneurship; Many occasions to celebrate your success : 5 @ 7, team activities, birthdays, breakfasts and other special events; Group insurance for you and your family members; RRSP and DPSP participation plan; Monthly Wellness Allowance; Reimbursement of telecommunication costs; Flexible work from home policy; 4 weeks of paid vacation; Language courses (French & English); The expected annual compensation for this position ranges from $105,000 to $115,000 CAD, depending on experience, skills, location, and internal equity. This salary range is provided as a guideline and may be adjusted for the selected candidate. ABOUT KEYRUS: At Keyrus, we help organizations move from experimental AI to industrialized AI, from isolated agents to orchestrated systems, and from insight to execution. This is the discipline we call being an Architect of Intelligence. Designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value: we operationalize intelligence. Powered by our proprietary Human Orchestrated Model™ (HOM), we architect reliable: Intelligence Foundations, Human in Command governance, and Performance Steering, To create intelligent environments where technology amplifies human capabilities and performance compounds over time. With 30+ years of expertise and 2,800 employees across 28 countries, we help organizations go beyond transformation: to build adaptive, resilient, and continuously improving intelligent organizations.

Design and maintain enterprise-grade Power BI dashboards and Databricks data pipelines within a medallion-style architecture. Perform QA validation and troubleshoot production issues to ensure reliability and trust in reporting outputs.

Requires strong expertise in Power BI, Databricks, and SQL, with a solid understanding of modern data lakehouse architectures. Candidates should be proficient in Azure DevOps and have experience with AI-assisted data engineering workflows.

• Group Insurance • RRSP Participation Plan • DPSP Participation Plan • Monthly Wellness Allowance • Telecommunication Cost Reimbursement • Flexible Work From Home Policy • 4 Weeks Paid Vacation • Language Courses

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Power BI
• Databricks
• PySpark
• Python
• SQL
• DAX
• Data Modeling
• Azure DevOps
• CI/CD
• Medallion Architecture
• Data Engineering
• Stakeholder Communication
• QA Validation
• Lakehouse
• SAP Datasphere
• Problem Solving
• Semi-Structured Data
• Agentic AI
• Pipelines
• Solution Design
• Stakeholder Communications
• Workflow Management
• Data Pipeline Management
• Data Analysis Expressions (DAX)
• Go (Programming Language)
• Report Development
• Resilience
• Artificial Intelligence
• Telecommunications
• Dashboard
• Business Process
• Decision Making
• Software Documentation
• Version Control
• Consulting
• Continuous Improvement Process
• Data Quality
• Operating Systems
• DevOps
• Distributed Data Store
• Divestitures
• English Language
• French Language
• Gap Analysis
• Governance
• Scalability
• Innovation
• Intelligent Systems
• Python (Programming Language)
• Language Education

• Data & Analytics
• Consulting
• Technology
• Software
• Engineering
• Data Consultant
• Business Intelligence Developer / Architect
• Software Developers

Expérience minimale

5+ ans

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Présence au bureau

2 jours par semaine