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 ope rationalise intelligence.

Location:

Hybrid – Toronto or Montreal, Canada (2 days per week on-site)

Contract:

Permanent, Full-time

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

• 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 Dev Ops, 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

• 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

Databricks, Power BI, Python, SQL, Azure Dev Ops, SAP Datasphere

• 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.

At Keyrus, we help organizations move from…