Senior Data Consultant – Databricks
Keyrus
A complete application in a minute
Tailored resume and cover letter, ready to send.
Benefits offered by this job
Job summary
Keyrus is seeking a Senior Data Consultant to strengthen enterprise data and analytics environments with emphasis on Databricks engineering, data pipelines, and production support. You will optimize transformations, ensure quality, and contribute to Power BI reporting while engaging with stakeholders and driving continuous improvement.
You will work in a hybrid setup in Toronto or Montreal (2 days in office).
Qualifications
- 5+ years of professional experience in data engineering, data consulting, or related data and analytics roles.
- 3+ years developing and optimizing Databricks pipelines and data transformations.
- Experience with lakehouse architectures, distributed data environments, and pipeline orchestration.
- Experience supporting production analytics environments with QA validation and incident resolution.
- Ability to collaborate with business stakeholders and own technical deliverables.
- Exposure to Power BI and reporting solutions is a plus.
Responsibilities
- Develop, maintain, and optimize Databricks data pipelines and transformations with Python, PySpark, and SQL.
- Support production analytics environments, including QA, gap analyses, and incident resolution.
- Collaborate with stakeholders to validate requirements, scope, and acceptance criteria.
- Identify blockers and risks, ensuring timely resolution and transparent communication.
- Own end-to-end technical deliverables and present solutions to stakeholders for validation.
- Support BI and reporting solutions, contributing to AI-assisted data engineering workflows.
- Maintain documentation and contribute to engineering standards.
Skills
Tools
Job description
Keyrus is an international group of 3,000 experts across 30 countries, built on a single conviction: AI does not transform businesses. Architected intelligence does.
Keyrus is an international group of 3,000 experts across 30 countries, built on a single conviction: AI does not transform businesses. Architected intelligence does.
For more than 30 years, we have helped organizations build the data foundations that power intelligent systems. Today, we go further by designing and operationalizing intelligence that delivers measurable business value.
Building AI capabilities is only part of the challenge. Real transformation happens when those capabilities work within existing business systems, data environments, workflows, and processes.
At Keyrus, you'll work closely with clients to develop, optimize, and support enterprise data and analytics solutions, combining Databricks, data engineering, and business intelligence capabilities to deliver reliable business insights.
Technology amplifies. Keyrus culture differentiates. Industrial discipline connects the two.
- Location: Hybrid - Toronto or Montreal, Canada (2 days per week in the office)
- Contract: Full-time
As a Senior Data Consultant, you'll support and enhance enterprise data and analytics environments, with a strong focus on Databricks engineering, data pipelines, and production support.
You'll develop and optimize data transformations, maintain reliable analytics pipelines, and troubleshoot complex issues across production environments, while contributing to reporting and business intelligence solutions, including Power BI.
Your role requires technical autonomy, strong problem‑solving skills, and the ability to deliver high‑quality solutions under demanding client expectations while contributing to continuous improvement.
- Develop, maintain, and optimize Databricks data pipelines and transformations using Python, PySpark, SQL, and notebooks, supporting modern lakehouse and medallion architectures (Bronze, Silver, Gold).
- Ensure data quality, reliability, and performance through pipeline testing, QA validation, gap analysis, troubleshooting, and production incident resolution.
- Collaborate with business and technical stakeholders to validate requirements, project scope, and acceptance criteria before development.
- Proactively identify and communicate blockers, dependencies, and delivery risks, ensuring transparency and timely resolution throughout the project.
- Own technical deliverables end-to-end, presenting completed solutions, explaining technical decisions, and obtaining stakeholder validation and acceptance.
- Support business intelligence and reporting solutions, including Power BI, while contributing to continuous improvement and emerging AI‑assisted data engineering workflows.
- Maintain clear technical documentation, contribute to engineering standards, and ensure effective knowledge transfer and operational handoffs.
You are an experienced Data Consultant with strong hands‑on expertise in Databricks, SQL, and modern data engineering. You are comfortable working independently in demanding production environments, investigating complex technical issues, and delivering reliable analytics solutions. You bring strong analytical thinking, attention to detail, and a consulting mindset, with the flexibility to contribute to business intelligence and reporting initiatives.
What you bring
- 5+ years of professional experience in data engineering, data consulting, or related data and analytics roles.
- 3+ years of hands‑on experience developing, maintaining, and optimizing Databricks pipelines and data transformations.
- Proven experience working with modern lakehouse architectures, distributed data environments, and pipeline orchestration.
- Experience supporting production analytics environments, including QA validation, gap analysis, and incident resolution.
- Experience collaborating with business stakeholders and technical teams, with ownership of technical deliverables.
- Exposure to business intelligence and reporting solutions, preferably Power BI.
- Strong Databricks development experience using Spark/PySpark, Python, SQL, and notebooks, including Delta Lake and lakehouse/medallion architectures.
- Experience with Unity Catalog for data governance, access management, and organization of data assets.
- Data pipeline orchestration and automation using Databricks Jobs, Lakeflow Pipelines, and Databricks Declarative Automation Bundles.
- Strong SQL and data engineering capabilities, including incremental data processing, pipeline testing, validation, and troubleshooting.
- Experience with performance and cost optimization across Databricks workloads and production data pipelines.
- Azure DevOps, CI/CD practices, version control, and development workflows in distributed data environments.
- Familiarity with AI‑assisted development, Databricks Genie Agents / Conversational Analytics, and agentic data engineering workflows.
- Hands‑on Power BI development, including DAX, data modeling, and report performance optimization.
- Experience with MCP servers or similar orchestration frameworks.
- Consulting experience in demanding client environments.
- Experience supporting migrations, divestitures, or complex transformation initiatives.
- Familiarity with SAP Datasphere.
- Experience contributing to AI‑assisted or agentic data engineering practices.
- You build and maintain reliable Databricks data solutions.
- You troubleshoot complex production issues independently.
- You communicate clearly and collaborate effectively with stakeholders.
- You maintain high standards of data quality and delivery.
- A stimulating environment where you can challenge yourself and discover new horizons.
- A strong culture of innovation and entrepreneurship.
- Opportunities to celebrate success through team activities, social events, and special celebrations.
- Comprehensive group insurance for you and your family.
- RRSP and DPSP participation plans.
- Monthly wellness allowance.
- Telecommunication reimbursement.
- 4 weeks of paid vacation.
- Language courses (French and English).
- Access to continuous learning through certifications, conferences, training programs, and industry events.
The expected base compensation for this position ranges from $110,000 to $120,000 CAD annually, depending on experience, skills, location, and internal equity. This salary range is provided as a guideline and may be adjusted for the selected candidate.
At Keyrus, we help organizations move from experimental to industrialized AI, from isolated agents to orchestrated systems, and from insight to execution.
As Architects of Intelligence, we design the Operating System of the intelligent enterprise, embedding intelligence into business processes so that it creates sustainable, measurable value.
Powered by our proprietary Human Orchestrated Model™ (HOM), we architect reliable:
- Intelligence Foundations
- Human in Command governance
- Performance Steering
With over 30 years of expertise and 3,000 experts across 30 countries, we build adaptive, resilient intelligent environments where technology amplifies human capability and performance compounds over time.
AI does not transform businesses. Architected intelligence does.
For more information: www.keyrus.com
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
