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

Devil May Care Media

Writer Job at Devil May Care Media

 ...Devil May Care Studios is looking to hire a Writer for AM Update and The Megyn Kelly Show , a daily, two-hour news, politics, legal, and cultural live radio show and podcast. The Writer will work closely with the host, producers, and editorial team to craft clear,... 

Indeck Energy Services

Power Plant Operator Job at Indeck Energy Services

 ...Energy Services is looking for an individual with combined cycle power plant experience to fill an immediate position. This position...  ...Energy has developed, financed, managed the construction, owned and operated numerous power generation facilities across the United States... 

Pierce Technology Corp

Low Voltage Cable Technician Job at Pierce Technology Corp

 ...completion of any local work, the ability to travel nationally is expected. Install and maintain low voltage cabling systems for telecommunications and data networks. Utilize hand tools and computer hardware to troubleshoot and repair network issues. Provide... 

ExecutivePlacements.com

Remote Project Manager Job at ExecutivePlacements.com

 ...Technical Project Manager The Technical Project Manager is an experienced leader who oversees complex technology projects, ensuring they are well-planned, executed, and delivered according to client goals. They use advanced project management skills to lead projects... 

A Hug Away

Sitter for Katy Area Job at A Hug Away

Job Summary: Primary function is to provide personal healthcare and related services to the patient/client in his or her place of residence; to assist in providing a safe and clean environment, work cooperatively with the patient/client and family and share observations...