📍 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. 1. 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 2. 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 3. 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 4. 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. Department Operations Role Senior Consultant Locations Montréal, Toronto Remote status Hybrid