Senior Data Consultant - Power BI & Databricks

Keyrus; Montreal (administrative region); Híbrido; CAD 105.000 - 115.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Group insurance

RRSP and DPSP participation plan

Monthly Wellness Allowance

Telecommunication reimbursement

Flexible work from home policy

4 weeks of paid vacation

Language courses (French & English)

Descripción de la vacante

Keyrus North America is seeking a skilled data and BI architect to design, build and maintain enterprise-grade Power BI dashboards and data pipelines. Hybrid role based in Toronto or Montreal with on-site 2 days a week.

You will translate business requirements into scalable data models, optimize performance, and work with Databricks and other sources. Strong SQL, Azure DevOps, and AI-enabled workflows are valued, along with a proactive, detail-oriented mindset.

Formación

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

Responsabilidades

• Design, build, and maintain enterprise-grade Power BI dashboards and reports.
• Translate requirements into scalable data models with business stakeholders.
• Optimize report performance using DAX and data model design.
• Develop and maintain Databricks data pipelines and transformations.
• Support medallion-style architectures (Bronze/Silver/Gold).
• QA and troubleshoot data quality and pipeline issues.
• Collaborate with cross-functional teams and own deliverables end-to-end.

Conocimientos

Power BI development

Databricks

SQL

Azure DevOps

AI workflows

Stakeholder communication

Autonomy & quality

Herramientas

Python

PySpark

Databricks notebooks

SAP Datasphere

Descripción del empleo

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.

Location:

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

Contract:

Permanent, Full-time

What You’ll Architect

Keyrus North America (NORAM)

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