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

NavitsPartners

MRI Technologist - MRI25-26277 Job at NavitsPartners

 ...MRI Technologist Location: Elmhurst, NY Type: Contract (13 Weeks) Schedule: 35 hours/week, 4:00 PM 12:00 AM, Monday through Friday, with alternating weekends and holidays Pay(Local): Up to $2,250/Week Overview: "Navitas Healthcare, LLC" is... 

Families USA

Senior Policy Analyst Job at Families USA

CareersSenior Policy AnalystPosition Type: Exempt, Full-time positionReporting To: Deputy Senior Director, Health PolicyPosition Location...  .... This role leads project work at the state and federal levels, collaborates across internal teams and external partners to inform... 

TERRACON

2026 Geotechnical/Environmental/Construction Materials Engineering Intern Job at TERRACON

 ...Join Terracon as an intern supporting our Materials, Environmental, and/or Geotechnical service lines! In this official program, you...  ...progress in a science or related field (environmental, safety, engineering, chemistry, biology, geology). The ideal candidate will have... 

Blue World Construction, Inc.

Construction Technician/Laborer Job at Blue World Construction, Inc.

 ...CONSTRUCTION TECHNICIAN ABOUT US: Blue World Construction has specialized in civil construction projects for over a decade, including...  ...and pumping systems, and installation of thousands of feet of pipeline. Our offices in Arizona, Texas, and New Jersey rely on our... 

Banner Health

Registered Nurse RN Outpatient Infusion Clinic Job at Banner Health

 ...City/State:**Tucson, Arizona**Department Name:**Outpatient Infusion-Hosp**Work Shift:**Day**Job Category...  ...shift with varied days off during the week. The RN will be required to work one weekend shift per month; Clinic hours allow for 4 10-hour shifts.** Infusion RN'...