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

Senior Helpers

Caregiver no experience necessary Job at Senior Helpers

 ...someone just like you to join our team at Senior Helpers as a Caregiver!Job SummarySenior Helpers - Franklin is looking for a compassionate...  ...& BenefitsCompensation is competitive and based on experience. This role pays $15 - $16 an hour, paid biweekly. This position... 

Cepheid

Mass Spectrometry Scientist Job at Cepheid

 ...accelerate your potential and make a real difference within life sciences, diagnostics and biotechnology? At Genedata, one of Danaher's ( 15+ operating companies, our work saves lives-and we're all united by a shared commitment to innovate for tangible impact.... 

Rosaires Care

Travel Ultrasound Tech Job at Rosaires Care

We are seeking a Travel Ultrasound Tech for Englewood, NJ, near Paterson. Perform diagnostic ultrasound procedures with precision and attention to detail. Operate ultrasound equipment and adjust settings for optimal imaging. Collaborate with healthcare teams to... 

Domino's Franchise

Delivery Driver - 4507 Manatee Ave W Job at Domino's Franchise

 ...Job Description Are you ready to be part of the action? Do you like money in your pocket? Domino's Pizza drivers are paid cash nightly, which includes: tips and mileage reimbursement! Our Driver position is an excellent place to start learning about the delivery... 

Lee Construction Group, Inc.

Apprentice - General Construction Carpentry Job at Lee Construction Group, Inc.

 ...the LEAP Program (Lee Education Apprenticeship Program) at Lee Construction Group you will receive hands-on-training, technical instruction, and a paycheck. This apprenticeship program is an entry level general construction carpentry program. It is designed to prepare...