Senior Data Consultant - Power BI & Databricks

Join KEYRUS and transform the future with us!

Who are we?

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 l ooking 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.

Key Responsibilities

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

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

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

1. 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 $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.

Join us at Keyrus!

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!