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

Whole Foods Market

Cake Decorator - Full Time Job at Whole Foods Market

 ...Core Values and goals, promote companywide, regional, and store programs and initiatives, ensuring strict adherence to all applicable Food Safety and compliance duties required in the department. Job Responsibilities Assemble, fill, and finish/decorate cakes, tarts,... 

Peachtree Group Hospitality Management

Chief Engineer Job at Peachtree Group Hospitality Management

Job Details Description The Chief Engineer is responsible for all administrative, financial, and operational aspects of the hotel as they directly relate to the engineering department. The Chief Engineer is responsible for the safe and profitable operation of the... 

Brio living Services

Dietary Aide, Part Time 4pm - 7:30pm Job at Brio living Services

 ...Love Working Here: Wellness Program & Reimbursemen t Prioritize your health and well-being, reimbursed 120 a year! Retirement Savings Plan Secure your future with employer contributions. Daily Pay Get paid when YOU want! Team Member Referral Bonus Program... 

Electronic Silk Road (Shenzhen) Tech Co., Ltd

Senior English Copywriter Job at Electronic Silk Road (Shenzhen) Tech Co., Ltd

Qualification:-- Native English speaker is preferred, excellent in both written and spoken English. Good Chinese communication skills is a plus-- 2 years+ related experience in creative job or copywriting, experience in advertising company preferred.--Bachelor Degree... 

Openkyber

Salesforce Administrator Job at Openkyber

 ...system without interruption to the user Modify/configure the system to increase benefits and usability Daily administration and support of Salesforce including but not limited to managing multiple user setups, permission groups, customization of objects, fields,...