Senior Data Consultant - Power BI&Databricks, Montréal

Join KEYRUS and transform the future with us!

Keyrus Group is a trusted leader in Data Intelligence with offices across the globe in 26 countries with more than 3500 consultants worldwide. Our expert team provides strategic data engineering, data discovery, and data science solutions for our clients, primarily in the retail, non‑profit, and financial services industries.

If you are looking to join an innovative startup‑style company that has the support of an internationally recognized brand, we encourage you to apply and join our team!

Location Hybrid mode (Toronto or Montreal)

Keyrus Canada 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, anddeliver high‑quality outputs under scrutiny.

Key Responsibilities

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 pipelinesIdentifer lili>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

Required Skills&Experience

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

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 $120,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.

Keyrus believes in diversity and, therefore, we only evaluate the technical and behavioral aspects of our candidates. We encourage everyone to participate in our hiring processes, regardless of their gender, age, ethnicity, religion, identity or condition! We do not allow any type of discrimination in our team.

See you in the process!

#J-18808-Ljbffr