Data Engineer

📋 Description

• Design, develop, and maintain data feeds and integration pipelines from source systems through
• Build integrations using REST APIs, SFTP, SQL Server, Snowflake, and other data sources.
• Develop Python applications and scripts for data ingestion, transformation, validation
• Develop and support Snowflake data pipelines, including incremental data-loading patterns and
• Apply Data Vault modeling principles, including Hubs, Links, Satellites, hash keys, hash
• Write and troubleshoot T-SQL for data extraction, transformation, validation, reconciliation, and

🎯 Requirements

• Production experience developing data feeds, data integrations, or data pipelines.
• Strong Python development experience, including data processing and transformation.
• Strong hands-on experience with Microsoft SQL Server and T-SQL, including complex queries, joins
• Hands-on experience with Snowflake, including data querying, loading, transformation, validation
• Experience with Data Vault modeling, including Hubs, Links, Satellites, hash keys, hash
• Experience developing and supporting Snowflake pipelines using stages, Snowpipe, Streams, Tasks

🎁 Benefits

• 4 weeks of cumulative vacation starting from day one
• Flexible working hours
• Professional Development Allowance (PDA) for training, computer equipment, and physical activities
• Training tailored to your areas of expertise
• Registered Retirement Savings Plan (RRSP) with employer contribution up to 3% of gross salary
• Modular group insurance plan