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

TRNT GROUP, LLC

FUEL TRUCK DRIVER Job at TRNT GROUP, LLC

FUEL TRUCK DRIVER

Strategic Employment

Business Intelligence Analyst Job at Strategic Employment

 ...Our client, a fast growing organization within the financial services sector, is seeking an experienced Business Intelligence Analyst to join their growing team.This role involves supporting stakeholders across multiple department to identify trends, build dashboards,... 

New paradigm staffing

Remote Data Entry Clerk (Healthcare) Job at New paradigm staffing

 ...Were looking for an accurate and dependable Entry-Level Healthcare Data Entry Clerk to join New Paradigm Staffing , entering patient and administrative data into secure digital systems. What Youll Do Input data into EHR and administrative platforms Review... 

Wolf & Badger

Brand Success Manager - Ethical Fashion Marketplace Job at Wolf & Badger

 ...around the globe, we connect customers with ethically sourced fashion, design, home and wellness through our online marketplace and flagship...  ...in the development of our Brand Partnerships team in the US market, being responsible for owning relationships with our US-based... 

YMCA of the Pines

Athletic Director Job at YMCA of the Pines

Overview: The Athletic Director is responsible for overseeing, leading, planning and implementing the Athletic department. Athletic Director...  ...Ensure adequate supplies and resources are available. Assist campers with achieving their goals. Supervise and participate...