Senior Snowflake ETL Developer

About the role

Client: CPKC

We are looking for a Senior ETL Developer with strong Snowflake expertise to design and implement scalable data solutions, modern data architectures, and high-performance data pipelines.

The role involves working closely with business stakeholders, providing technical leadership, and developing AI-driven solutions using structured and unstructured data.

Requirements

• 8+ Years in Data Engineering
• Overall Experience: 8+ years in Data Engineering, Data Warehousing, and Data Architecture.
• Snowflake: 4+ years of hands-on experience with Snowflake Data Cloud.
• Medallion Architecture: Proven production experience implementing Bronze, Silver, and Gold layers.
• ETL & Data Pipelines: Strong experience designing and developing end-to-end ETL/ELT pipelines.
• Programming: Proficiency in Python, SQL, and Stored Procedures.
• IDMC: Expertise in developing and managing IDMC pipelines.
• Data Ingestion & CDC: Experience with Change Data Capture (CDC), Snowpipe, and Python-based ingestion.
• Data Governance & Security: Strong knowledge of RBAC, Dynamic Data Masking, Row-Access Policies, and Column-Level Security.
• Data Quality: Experience with data validation, profiling, transformation, and cleansing.
• CI/CD: Experience implementing data pipeline CI/CD using Git and Azure DevOps.
• Data Modeling: Strong understanding of data warehousing and data modeling methodologies.
• Stakeholder Management: Excellent communication skills and experience working directly with business stakeholders.
• Snowflake Cortex Analyst/Search and Snowflake Intelligence.
• Snowflake Marketplace and AI agent development using structured or unstructured data.

Schedule

• 5 Days Onsite

Location

• Calgary, Alberta, Canada