Senior Data Consultant - Power BI & Databricks
Keyrus Canada EN•Montreal, QC
•$105,000 - $120,000•Hybrid
About The Position
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.
Requirements
- 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 Haves
- 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
Responsibilities
- 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
- 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
- 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
- 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
Benefits
- 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)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
