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

Sapp Bros Transportation

Class A Transport Fuel Delivery Driver Job Job at Sapp Bros Transportation

Class A Transport Fuel Delivery Driver JobTerminal loading for local deliveries of transport fuel. Pay: Load pay range $75,000 to $110,00...  ...Number: (***) ***-**** Tell em' Gary's Job Board sent you.This truck driving job may have an alternate application method. Look... 

S B Cox

Fuel Truck Driver Class B Hazmat Tanker Job at S B Cox

 ...Job Summary We are seeking a skilled and safety-conscious Fuel/Lube Truck Driver to join our team. This position is responsible for delivering fuel and lubricants to heavy equipment, trucks on various job sites, ensuring timely service and compliance with all safety... 

ExecutivePlacements.com

Python Data Analyst Entry Level Job at ExecutivePlacements.com

 ...a motivated and detail-oriented Python Data Analyst to join our dynamic team. This entry-level...  ...position, providing flexibility while working with cutting-edge tools and datasets....  ...performance-based incentives. Work-from-home flexibility and remote work... 

Joby Aviation

Commercial Operations Project Manager Job at Joby Aviation

 ...toward certifying the Joby aircraft, scaling our manufacturing, and launching our initial commercial service. Overview Joby Aviation is seeking a passionate pilot and project manager to join our commercial operations team with a focus on flying for our certificated 14... 

Marshfield Clinic

RN - Acute, Med/Surg (Baylor/Weekend Only) Night Shifts Job at Marshfield Clinic

 ...teamwork come together to support the most exciting missions in the world!****Job Title:**RN - Acute, Med/Surg (Baylor/Weekend Only) Night Shifts**Cost Center:**301691175 WesHos-Med-Surg-4**Scheduled Weekly Hours:**36**Employee Type:**Regular**Work Shift:**Fri...