Senior Data Consultant - Power BI & Databricks
We usually respond within a week
🌟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 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.
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 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
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.
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!
- Department
- Operations
- Role
- Senior Consultant
- Locations
- Montréal, Toronto
- Remote status
- Hybrid
Why you'll love working at Keyrus Canada
Our team is on a mission to help enable a more data-driven world. As we work towards this mission together, we make sure to have a lot of fun along the way!