Senior Data Consultant – Power BI, Databricks

Role Overview

• Keyrus North America 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.
• 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
• 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

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

Tech Stack

• Azure
• PySpark
• Python
• SQL

Benefits

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