Search Jobs
Snowflake Developer (Data Warehouse Design & SQL)
Job Description
Location: Montreal (day 1 onboarding onsite/in-office presence required 3x/week)
Years of Experience: 5-7
Snowflake Developer with strong expertise in Data Warehouse design and SQL development. The candidate will be responsible for designing and building a scalable data warehouse layer on Snowflake, creating schemas, views and optimizing data models for analytics and reporting.
Key Responsibilities:
- Design and implement enterprise-grade data warehouse architectures on Snowflake.
- Develop and manage dimensional data models, including fact and dimension tables using star and snowflake schemas.
- Plan and execute data migrations from legacy and existing databases to Snowflake, ensuring data integrity and consistency.
- Develop and optimize SQL queries and views to support reporting and downstream data consumption.
- Implement performance tuning techniques, including clustering, query optimization, and warehouse best practices within Snowflake.
- Build and maintain CI/CD pipelines using Jenkins to support reliable and automated deployments.
- Manage version control, code reviews, and release deployments using GitHub.
- Strong hands-on experience with Snowflake, including schema design, performance tuning, and platform best practices.
- Advanced SQL skills with experience building complex views and transformations, alongside a strong understanding of data modeling, clustering, partitioning, and query optimization techniques.
- Proven expertise in data warehouse design, including star and snowflake schemas and fact and dimension modeling.
- Workflow orchestration experience using Apache Airflow for data ingestion pipelines, including DAG design, scheduling, dependency management, and operational troubleshooting.
- Experience implementing and managing CI/CD pipelines using Jenkins.
- Working knowledge of GitHub for source control, code reviews, and deployment workflows.
- Demonstrated experience leveraging Liquibase for automated and auditable database change management.
- Experience with AI-enabled solution development and implementation.
- Expertise in building and maintaining Power BI semantic models and dashboards.
*//EEO Employer: Minorities/ Females/ Disabled/ Veterans/ Gender Identity/ Sexual Orientation//*
Meet Your Recruiter
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Montreal, QC
Staffing Leader of the Year Anju Abel
CEO, LanceSoft
LanceSoft is proud to announce that its Chief Executive Officer, Anju Abel, has been honored with the prestigious "Staffing Leader of the Year" award at the 2025 TIARA Staffing Awards US. The award recognizes her visionary leadership and significant contributions to improving staffing processes, employee engagement, and workforce outcomes.
Anju Abel's leadership has been instrumental in transforming LanceSoft's global staffing operations. Her focus on innovation, employee satisfaction, and client-centric delivery has led to higher retention rates, a motivated workforce, and enhanced operational efficiency.
"This award is a testament to the incredible team at LanceSoft and our unwavering commitment to redefining staffing solutions," said Anju Abel. "I'm honored to receive this recognition and proud of the impact we continue to make in the lives of our clients and talent worldwide."
The judging panel highlighted Anju's ability to consistently deliver outstanding client success stories, exceed expectations, and foster professional development within her team. Her active community involvement and dedication to advancing the staffing industry were also key factors in her selection.
TIARA Awards are known for celebrating excellence, innovation, and achievement in the talent acquisition sector, and this accolade places Anju among the top leaders reshaping the future of workforce solutions.