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

Dinamic AS Group

Marketing Assistant Job at Dinamic AS Group

 ...Dinamic As Group is a forward-thinking company dedicated to delivering high-impact advertising solutions that help brands elevate their visibility and connect with the right audience. Known for our strategic mindset, commitment to innovation, and collaborative culture... 

Commonwealth of Pennsylvania

Fish Culturist 1 (Seasonal) - Pleasant Gap Job at Commonwealth of Pennsylvania

 ...Reference #: 5181593 THE POSITION Would you like physical work in the outdoors, for a state agency that provides fishing and boating opportunities for individuals and families in Pennsylvania's many lakes, river, and streams? Would you be interested in a position that... 

Honor Community Health

Medical Assistant- Pediatrics Job at Honor Community Health

 ...FULL MEDICAL ASSISTANT JOB DESCRIPTION (click to view) Honor Community Health is a 501c3 Federally Qualified Health Center co-located within 20 locations. Our mission is to provide for the health and wellness needs of the underserved of Oakland County through the provision... 

MCI

Wireless Civil Technician - Travel Position Job at MCI

 ...diligent individuals to join our team as Civil Technicians. This entry-level position is an exceptional opportunity to enter the wireless...  ...dirt work, such as digging and preparing sites for construction using shovels and other hand tools. This position is physically... 

Liberty Personnel Services, Inc.

Legal Secretary - Temporary Consultant Job at Liberty Personnel Services, Inc.

 ...Job Details: Legal Secretary - Consultant 60+ day assignment Hamilton NJ Liberty Personnel is working with a multi office law firm client adding a Legal Secretary to their administrative support team. An ideal candidate will excel in afast-paced environment...