Senior Data Consultant - Power BI & Databricks

Keyrus; Toronto; Hybrid; CAD 105,000 - 115,000; Full time

Benefits offered by this job

Group insurance for you and family

RRSP and DPSP participation

Monthly Wellness Allowance

Telecommunication costs reimbursement

Flexible work from home policy

4 weeks of paid vacation

Language courses

Job summary

Keyrus North America is seeking a Senior Data Consultant to support a high-demand analytics environment focused on Power BI development and Databricks engineering. You will design scalable data models, optimize dashboards, and maintain production reporting pipelines while collaborating with business users and technical teams.

The role emphasizes autonomy, strong problem-solving, and delivering high-quality outputs in a fast-paced setting across hybrid work arrangements in Canada.

Qualifications

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

Responsibilities

• Power BI development and optimization of enterprise dashboards and reports.
• Databricks development including data pipelines and transformations.
• Work with structured and semi-structured data sources.
• Support QA, validation, and troubleshooting of reports and pipelines.
• Collaborate with business users and technical teams end-to-end.
• Contribute to documentation, standards, and best practices.

Skills

Power BI

Databricks

SQL

Azure DevOps

CI/CD

Data architecture

Data engineering

AI workflows

Stakeholder comms

Autonomy

Tools

PySpark

Python

Notebooks

Job description

Why Keyrus, Why Now!

Keyrus is an international group of 2,800 consultants and experts across 28 countries, built on a single conviction: AI does not transform businesses. Architected intelligence does. For more than 30 years, we have been building the data foundations that make intelligent systems work — designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value: we operationalise intelligence.

AI does not replace humans. It repositions us to a place no system can follow: understanding, deciding, designing, and creating. At Keyrus, you will not just develop skills - you will develop judgment. Your expertise sharpens with every system you architect, every client challenge you solve, every deployment that compounds on the last.

Over time, you grow into one of the rarest professionals of the intelligence era: someone who bridges data, AI, and human decision-making at scale, across industries and geographies. This is not a role you fill. It is a discipline you master and a story you help write to become a Keyrus Architect of Intelligence.

Technology amplifies. Keyrus culture differentiates. Industrial discipline connects the two.

Location:

Hybrid – Toronto or Montreal, Canada (2 days per week on-site)

Contract:

Permanent, Full-time

What You'll Architect

Keyrus North America (NORAM) 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.

• 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

Qualifications

• 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 At Keyrus

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

About Keyrus

At Keyrus, we help organizations move from experimental AI to industrialized AI, from isolated agents to orchestrated systems, and from insight to execution. This is the discipline we call being an Architect of Intelligence. Designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value: we operationalize intelligence.

Powered by our proprietary Human Orchestrated Model™ (HOM), we architect reliable:

• Intelligence Foundations,
• Human in Command governance,
• and Performance Steering,

To create intelligent environments where technology amplifies human capabilities and performance compounds over time.

With 30+ years of expertise and 2,800 employees across 28 countries, we help organizations go beyond transformation: to build adaptive, resilient, and continuously improving intelligent organizations.