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

EA Sween Company

Class B Class B Route Delivery Driver Job Job at EA Sween Company

Class B Class B Route Delivery Driver JobE.A. Sween Company, also dba Deli Express, operates a Combined Distribution Center in Denver, Colorado. We deliver fresh food daily that includes sandwiches, milk, bread, bakery and other items to convenience stores across Colorado... 

Improveit Home Remodeling

Sales Recruiter Job at Improveit Home Remodeling

 ...Sales Recruiter Are you ready to kick-start your career in sales recruitment with a company that's not just growing, but thriving? Look no further than Improveit Home Remodeling! We're on the lookout for a dynamic and driven individual to join our team as an Entry-Level... 

GreatAuPair LLC

Housekeeper Job at GreatAuPair LLC

Seeking housekeeper 30-40hrs per week. Noon-6pm Monday to Friday. In addition to the usual housekeeper duties listed above such as cleaning and laundry, this person must be able to drive kid to/from schools/sports activities, light cooking and food prepping.

Mister B's Pizza & Wings

Kitchen Cook Job at Mister B's Pizza & Wings

 ...Starting Pay $11 - $15/hr (based on availability and experience)(Hiring starting at age 14 for basic kitchen prep and dishwashing positions. 14/15 year olds can work a maximum of 18 hours per week and must be off from work by 7pm on school days in accordance with Labor... 

ARCHER WEST SECURITY

Un-armed Security Guard Job at ARCHER WEST SECURITY

Looking for morning, swing, and night shift Un-armed Security Officers. Full time and Part-time Fridays, Saturday and Sundays. Security...  ...a professional appearance and demeanor-Must be able to work weekends and holidays-Must be able to pass a background and drug test...