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 $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.
Department Operations Role Senior Consultant Locations Montre9al, Toronto Remote status Hybrid
