Python Snowflake ETL Developer

Job Description

Role: Python Snowflake ETL Developer

Location: Montreal, QC OR Mississauga, ON (hybrid/3 days in a week) from day one

Employment: Full time or contract hybrid – relocation assistance is provided

Requirement: Must be in either Mississauga, ON or Montreal from day one

Key Skills Required

• Python
• SQL
• Data Warehousing
• Data integration/ETL
• Azure
• Snowflake

Primary Responsibilities

• Working on Azure Architecture, design, implementation, and operationalization of large-scale data and analytics and warehousing solutions on Snowflake Cloud Data Warehouse
• Hands-on development experience with Snowflake features such as Python, SQL, Tasks, Streams, Time travel, Zero Copy Snow SQL, Snow Pipe Cloning, Optimizer, Metadata Manager, data sharing, and stored procedures
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling
• Developing ETL pipelines in and out of the data warehouse using a combination of Data bricks, Python, and SQL/Snow SQL
• Developing scripts UNIX, Python etc. to Extract, Load and Transform data, as well as other utility functions
• Perform code reviews to ensure fit to requirements, optimal execution patterns, and adherence to established standards

Basic Qualifications

• Minimum 8 years of hands-on experience with productionized data ingestion and processing pipelines using Python, PySpark, Data bricks, and SQL/Snow SQL
• Experience designing and implementing an operational production grade large-scale data solution on Microsoft Azure Snowflake Data Warehouse experience highly desired

What We Offer

• Highly competitive compensation and benefits package
• Multinational organization across 19 countries with the possibility to work abroad
• Laptop
• 15 days of paid annual leave (plus sick leave of 10 days and national holidays)
• Maternity & Paternity leave plans
• A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
• Retirement savings plans
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development

Synechron's Diversity & Inclusion Statement

• Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer
• Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all
• We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company