Data Engineer with Python, DataBricks and Snowflake Job at Godspeed Workforce, Ontario, CA

RTdDZERBQ0hMR3NTeW1EeXo0dTlmWEZqQ2c9PQ==
  • Godspeed Workforce
  • Ontario, CA

Job Description

Job Title: Data Engineer with Python, DataBricks and Snowflake

Location: Montreal, QC or Mississauga, ON - Hybrid

No. of positions: 2

Exp: 8-14 years

willing to relocate to Mississauga or Montreal

Responsibilities

  • Hands-on development experience with Snowflake features such as Snow SQL; Snow Pipe; Python; Tasks; Streams; Time travel; Zero Copy Cloning; Optimizer; Metadata Manager; data sharing; and stored procedures.
  • Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
  • Need to have working knowledge of MS Azure configuration items with respect to Snowflake.
  • Developing EL pipelines in and out of data warehouse using combination of Data bricks, Python and Snow SQL.
  • Strong understanding or Snowflake on Azure Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
  • Developing scripts UNIX, Python etc. to Extract, Load and Transform data, as well as other utility functions.
  • Provide production support for Data Warehouse issues such data load problems, transformation translation problems
  • Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.
  • Understanding data pipelines and modern ways of automating data pipeline using cloud-based testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
  • Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Requirements:

  • Minimum 8 years of designing and implementing an operational production grade large-scale data solution on Microsoft Azure Snowflake Data Warehouse.
    • Including hands on experience with productionized data ingestion and processing pipelines using Python, Data bricks, Snow SQL
  • Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
  • Excellent presentation and communication skills, both written and verbal, ability to problem solve and design in an environment with unclear requirements.

Job Tags

Relocation,

Similar Jobs

DivIHN Integration Inc

IT Project Manager - Remote Job at DivIHN Integration Inc

 ...opportunity, please contact one of our Talent Specialists. Arun Kumar at (***) ***-**** Vinod at (***) ***-**** Title: IT Project Manager - Remote Duration: 11 Months Location: Remote Only W2 candidates are eligible for this position. Third-party or C2C... 

Language Trainers

Chinese Language teacher- ID: 1086797 Job at Language Trainers

 ...Current Language Level: Lower Intermediate Native language: Chinese *Motivation: to improve his English quickly for university study...  ...in the U.S. He wants to become more confident and accurate in speaking and writing, and he hopes to build the skills he needs to... 

Pennichuck Water Works Inc.

Environmental Engineering/Environmental Science Intern Job at Pennichuck Water Works Inc.

 ...and non-regulated water management services. Our Distribution center is located in Merrimack, New Hampshire. Environmental Engineering / Environmental Science Internship - Summer 2026 In this position you will gain field experience assisting and supporting the needs... 

Cambridge Security Services

Armed Security Officer Job at Cambridge Security Services

**Join Our Elite Team as a Security Officer with Cambridge Security Services** Are you ready to take your career in security to the...  ...ensuring the safety and security of our clients. **Position: Armed Security Officer **Location: Hialeah, FL **Shift: 2nd... 

Altom Transport

Company Driver - CDL A - Tanker Driver Job at Altom Transport

 ...Choose Your Driving Option ~ Regional Driver ~ Home every few days (35 days...  ...Responsibilities ~ Safely operate tanker trucks transporting bulk liquid materials...  ...interactions Requirements ~ Valid CDL Class A License Tanker...