Senior Data Engineer Consultant (Snowflake)
To integrate a community of curious and passionate experts and to evolve in a multi-cultural environment promoting international mobility. Because you are a #DataGeek and an #InnovationLover!
We usually respond within a week
🌟 Join KEYRUS and Shape the Future with Us! 🌟
About Keyrus
At Keyrus, we empower organizations to make their data matter. A French company with over 28 years of expertise and a presence in 27 countries worldwide, we are recognized leaders in Data Intelligence, Strategic Advisory, and AI Innovation. Our US team blends the energy of a startup with the resources of a global firm—delivering bleeding-edge solutions for clients across Financial Services, Healthcare, CPG/Retail, and more.
If you’re passionate about data, thrive on solving business challenges, and want to build what’s next — let’s talk!
🌍Location: Canada Hybrid mode (Toronto/Montreal in Canada)
Keyrus North America (NORAM) is seeking a full-time Senior Data Engineer / Snowflake Architect with deep hands-on Snowflake expertise, strong architecture capabilities, and a proven ability to operate confidently in client-facing environments.
This role is ideal for someone who combines technical depth, architectural judgment, and consulting presence. The right candidate will not only build and optimize Snowflake solutions, but also work closely with client architects and senior stakeholders, challenge decisions when needed, and proactively bring forward new Snowflake features, best practices, and optimization opportunities.
This is a high-impact role for someone who is dynamic, pragmatic, and able to quickly assess an existing environment while understanding what is possible and what should come next.
What you will do:
Lead the design, development, and optimization of Snowflake-based data solutions for enterprise clients
Work closely with the client's internal architect and delivery teams to shape scalable, secure, and high-performing data architecture
Confidently challenge technical decisions when needed, bringing a strong point of view grounded in Snowflake best practices and modern data architecture principles
Assess current-state data platforms, pipelines, and patterns, then identify opportunities for improvement, simplification, modernization, and optimization
Design and implement robust batch and near real-time data pipelines to support analytics, reporting, and advanced data use cases
Develop and optimize data transformation layers using SQL, Python, dbt, and related modern data engineering practices
Drive Snowflake platform excellence across performance tuning, workload optimization, cost efficiency, data modeling, security and governance, and orchestration and automation
Proactively introduce and evaluate relevant Snowflake capabilities such as Snowpark, Streams and Tasks, Dynamic Tables, data sharing, and other platform enhancements
Contribute to platform strategy discussions, including articulating the strengths and tradeoffs of Snowflake versus other modern data platforms.
Partner with engineers, analysts, architects, and business stakeholders to deliver production-ready solutions in a fast-paced consulting environment
Support pre-sales, discovery, and technical advisory conversations when needed
What we are looking for:
Bachelor's degree in Computer Science, Engineering, Information Technology, or equivalent practical experience
7+ years of experience in data engineering, cloud data, or modern data platform roles
Strong hands-on experience with Snowflake development and architecture
Snowflake certification: SnowPro Core or any SnowPro Advanced certification
Strong command of advanced SQL and solid experience with Python for transformation, automation, and pipeline development
Proven experience designing and delivering end-to-end production data solutions
Strong understanding of data warehouse, lakehouse, and modern cloud data architecture patterns
Experience working directly with client stakeholders, architects, and technical leads
Ability to operate with confidence and credibility in front of client teams, including the ability to push back constructively and influence architecture direction
Experience with dbt or similar transformation and testing frameworks
Experience with ingestion and integration patterns using APIs, file-based ingestion, ELT platforms such as Fivetran or equivalent, and cloud-native services
Strong communication skills with the ability to explain technical concepts clearly to both technical and non-technical audiences
Experience working in Agile / Scrum delivery environments
Highly valued / nice to have
Solid hands-on experience with Databricks, including architecture, pipelines, and lakehouse design
Exposure to Azure data services including ADF, Microsoft Fabric, Event Hubs, or related services
Experience with Spark / PySpark
Spanish language skills
What we offer:
A strong culture of innovation and entrepreneurship, 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
4 weeks of paid vacation
Language courses (French & English)
Join us at Keyrus! 🌟
- Department
- Operations
- Role
- Senior Consultant
- Remote status
- Hybrid
Montréal
Why you'll love working at Keyrus Canada
Our team is on a mission to help enable a more data-driven world. As we work towards this mission together, we make sure to have a lot of fun along the way!