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

Apex Systems

Creative - Prototyper III Job at Apex Systems

 ...which an Apex team member can provide. Apex Systems is part of the Commercial Segment of ASGN Incorporated. NYSE: ASGN 4400 Cox Road Suite 200 Glen Allen, Virginia 23060 Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination... 

Sasga Yachts

Laminador/a Job at Sasga Yachts

 ...SASGA YACHTS SL , astillero ubicado en Menorca (Islas Baleares) , precisa Personal para la Seccin de Polister reforzado con fibra de vidrio. REQUISITOS: Experiencia en aplicacin de gel coat mediante maquinaria de catalizacin interna Experiencia en acabados... 

TopView Sightseeing

Brand Ambassador Job at TopView Sightseeing

 ...tours. We own and manage the portfolio of brands, including TopView Sightseeing, Event...  ...growth; it offers a dynamic, one-of-a-kind work environment and is a workplace filled with...  ...supportive coworkers. About our Brand Ambassador position: As a Brand Ambassador for TopView... 

Canter Power Systems LLC

Journeyman Electrician Job at Canter Power Systems LLC

 ...Electric and Generator is looking to add an additional Journeyman Electrician to our team! This individual will be responsible for leading...  ...for our wonderful customers. This position will require travel throughout the state, and candidates are required to have a valid... 

Sunovio

Solar Sales Representative Job at Sunovio

 ...We are looking for solar sales reps, canvassers and managers for our new offices. The ideal individual is motivated, coachable and goal-oriented. We offer one of the highest payouts in the market for our reps and our training is second-to-none. Most reps do 2-3 accounts...