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

The Wilkes Brentwood

Assistant Pastry Chef Job at The Wilkes Brentwood

The Wilkes Brentwood, a 100-seat Farm to table restaurant featuring elevated comfort classics, we are seeking a friendly, experienced Pastry Assistant to join our team! Our ideal candidate has a passion for all things Farm to table California, thrives in a fast-paced...

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... 

Minneola Healthcare

Medical Laboratory Technician / Medical Laboratory Scientist Job at Minneola Healthcare

 ...Minneola Healthcare is seeking a dedicated and qualified Medical Laboratory Technologist (MLT) or Medical Technologist/Medical Laboratory Scientist (MT/MLS) to join our team. As a critical access hospital, we are committed to providing high-quality healthcare services... 

SST Direct

Construction Project Manager Job at SST Direct

 ...seeking a highly motivated and experienced individual to join our team as a Project Manager in the Columbia, SC. area. You will be responsible for overseeing Heavy Civil construction projects from start to finish, ensuring they are completed on time, within budget and... 

Avelis Health (YC S25)

RN - Post Partum Job at Avelis Health (YC S25)

Seeking a dedicated RN - Post Partum in Carmel, IN, earning $1,579/week. Responsibilities include providing compassionate postpartum care, monitoring maternal and newborn health, and educating new mothers on self-care and infant care. Assess patient conditions and...