Snowflake Architect

Slalom; Calgary; Hybrid; CAD 142,045 - 204,544; Full time

Benefits offered by this job

Cell phone reimbursement

RRSP with matching

TFSA

Medical & dental benefits

Life insurance

EAP & Therapy

Job summary

Slalom is hiring a Snowflake Architect for our Snowflake Center of Excellence. You will lead a pod to design holistic data solutions on Snowflake, mentor teams, and collaborate with clients to deliver scalable data platforms.

You will work across AWS/Azure/GCP, maintain Snowflake certifications, and partner with data leaders to drive sales and delivery excellence. The role includes a hybrid in-office arrangement.

Qualifications

• 8+ years data engineering experience with at least 4+ years hands-on Snowflake delivery.
• Experience with Cloud Data Warehouses (Amazon Redshift, Snowflake, Google BigQuery).
• Advanced Java and Python programming skills.
• Experience with NoSQL databases (DynamoDB, Cosmos DB, MongoDB).
• Experience with Kubernetes and container orchestration.
• Experience with Big Data tools: Spark, Hadoop, Presto, EMR.
• Advanced SQL experience and data modeling.
• Hands-on data pipelines (batch/streaming).
• Experience with AI/ML tools (Sagemaker, Azure ML).
• Experience with streaming ingestion (Kinesis, Kafka).
• Experience with visual analytics (Tableau, PowerBI).
• Experience with modern workflows (Airflow, dbt, Dagster).

Responsibilities

• Develop and implement Snowflake-based data solutions.
• Lead and mentor engineering teams to drive data best practices.
• Collaborate with clients to deliver data platform outcomes using Snowflake.

Skills

Snowflake delivery

Java

Python

Kubernetes

NoSQL databases

SQL

Data modeling

Airflow/dbt/Dagster

Education

Bachelor's degree in a related field

Tools

Snowflake

AWS

Azure

GCP

Tableau/PowerBI

Spark/Hadoop

Job description

Slalom is a fiercely human business and technology consulting company that leads with outcomes to bring more value, in all ways, always. From strategy through delivery, our agile teams across 52 offices in 12 countries collaborate with clients to bring powerful customer experiences, innovative ways of working, and new products and services to life. We are trusted by leaders across the Global 1000, many successful enterprise and mid-market companies, and 500+ public sector organizations to improve operations, drive growth, and create value.

At Slalom, we believe that together, we can move faster, dream bigger, and build better tomorrows for all.

Job Title: Snowflake Architect (For Vacant Role)

The Snowflake Center of Excellence (CoE) is focused on building, developing, and delivering holistic data solutions leveraging Snowflake and its evolving data platform. Snowflake’s product roadmap has expanded to meet a wider range of customer needs and is a major player in the data ecosystem that is well‑positioned for continued growth and strategic alignment with our work.

What You’ll Do

The Snowflake CoE is comprised of passionate technologists committed to refining and mastering their craft. As an Architect for the Snowflake CoE you will be expected to:

• Lead a small to medium size agile program pod to deliver cutting‑edge solutions utilizing the Snowflake ecosystem and adjacent technologies to deliver holistic solutions.
• Comfortable leading development on at least one of the main cloud providers (AWS, Azure, and GCP).
• Maintain “active” status of a Snowflake SnowPro Core certification and one advanced Snowflake certification of your choice.
• Work as the Solution Architect of a delivery pod with a Delivery Owner to design complex delivery patterns, implement solutions, and build components of our clients’ data platform solutions.
• Lead a delivery pod in Agile ceremonies and design sessions, break down complex development tasks, take responsibility for the timely completion of your pods assigned development items in the backlog.
• Contribute to the Snowflake CoE, the internal capability growth, and partnership initiatives.
• Collaborate closely with other Slalom data leaders to drive sales, recruiting, account management, consulting, and operational excellence across the capability
• Act as a Snowflake SME, supporting business development efforts and guiding clients through best practices in architecture, core data engineering, and scalable analytics
• Be a mentor and thought leader, regularly recommending emerging technologies and tools that align with client goals and future‑state data strategies
• Bring a business‑first lens to every conversation, driving impactful, tech‑enabled outcomes that elevate our clients’ competitive edge
• Embody Slalom’s core values and culture, bringing authenticity, curiosity, and care into every interaction

What You’ll Bring

As an Architect in the Snowflake CoE capability, you will bring a curious mindset to your client’s engagement, a thirst for knowledge, and a hunger for fearless experimentation in new and interesting ways to meet our clients’ most pressing data challenges. You will have an insatiable need to become the best at what you do and will have opportunities to gain hands‑on experience with new tools, features, and platforms as you explore the range of technologies that we help our clients with.

Key Responsibilities

• Develop and implement data solutions using Snowflake, while collaborating with team members to leverage its capabilities.
• Lead and mentor engineering teams, fostering a culture of learning and innovation, while driving best practices in data management and performance optimization.
• Engage with clients to understand their business challenges and deliver solutions that align with their goals, utilizing Snowflake’s capabilities to enhance outcomes.

Requirements

• 8+ years of data engineering experience with at least 4+ years of hands‑on Snowflake delivery and or development experience.
• Expertise in hands on development with Cloud Data Warehouses (Amazon Redshift, Snowflake, Google BigQuery)
• Advanced Object‑Oriented Programing skills (Java, Python)
• Experience with NoSQL Databases (DynamoDB, Cosmos DB, MongoDB)
• Experience with Container Management Systems (Kubernetes, Amazon ECS)
• Experience with Big Data Tools/Frameworks: Spark, Hadoop, Presto, Amazon EMR.
• Advanced SQL experience
• Hands on experience developing data pipelines: batch and or streaming.
• Experience with data modeling
• Experience with Artificial Intelligence / Machine Learning (Amazon Sagemaker, Azure ML Studio)
• Experience with Streaming Data Ingestion (Amazon Kinesis, Apache Kafka)
• Experience with Semantic Modeling or Visual Analytics (Tableau, PowerBI)
• Experience with Modern Data Workflows & Orchestration (Apache Airflow, dbt, Dagster).

Hybrid/In office

We are hybrid but there are expectations that if your team leader requires you onsite that you are able to meet those expectations/requirements.

Slalom is committed to fair and equitable compensation practices. For this position, the expected base salary pay range is $100,000 to $144,000. In addition, there is potential for a 10% discretionary bonus based on individual and company performance. Actual compensation will depend upon individual’s skills, experience, qualifications, and other relevant factors.

Benefits

• Culture & fun!
• Lunch & learns
• Health & wellness activities
• Holiday parties
• Employee community groups
• Social clubs & activities
• Vacation (20 days prorated based on start date & wellness/sick days)

Perks

• Competitive compensation package
• $100 cell phone monthly reimbursement
• Registered Retirement Program (RRSP) & Employer Matching
• Tax-Free Savings Account (TFSA)
• Family planning/ Fertility Benefit
• Maternity/Parental Leave Top-Up
• Medical & Dental Benefits
• Life and AD&D Insurance
• Access to Supplementary Life and AD&D Insurance
• Access to the Employee Assistance Program (EAP) and Inkblot Therapy
• And more!

*All benefits are subject to eligibility requirements

Equal Opportunity Statement

Slalom is an inclusive, equal opportunity employer dedicated to building a diverse workforce. We encourage applications from all qualified candidates and will work to reasonably accommodate applicants’ needs throughout all stages of the recruitment and selection process. Please advise the talent acquisition team if you require accommodations during the interview process. At Slalom, we leverage artificial intelligence (AI) to enhance the efficiency and scalability of our recruitment process. To learn more about how we leverage AI please read our TA AI Usage policy here.

Please note if you are hired at Slalom you will be required to complete a background check.