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

J. F. Ahern Co.

Service Coordinator Job at J. F. Ahern Co.

 ...also involve assisting with the assembly of proposal and bidding...  ...a fast-paced, deadline-driven work environment. Being proficient...  ...need to thrive - at work and at home. Heres how we stand out from...  ...Mental Health Resources: Free, full-service mental health care... 

HealthTrust Workforce Solutions HCA

Travel Ultrasound Technologist - $2,370 per week Job at HealthTrust Workforce Solutions HCA

 ...HealthTrust Workforce Solutions HCA is seeking a travel Ultrasound Technologist for a travel job in Asheville, North Carolina. Job Description & Requirements ~ Specialty: Ultrasound Technologist ~ Discipline: Allied Health Professional ~ Duration: 12 weeks... 

Top Level Promotions

Entry-Level Office Assistant - Work from Home Job at Top Level Promotions

 ...Work from Home Data Entry & Office Administration Entry-Level Remote Job About the Job We are seeking dependable, detail-focused individuals...  ...Production, Film Festivals, Distribution Health Care Public & Home Care Manufacturing Raw Materials &... 

Danaher

Field Associate Director, Medical & Scientific Affairs - Cardiometabolic Job at Danaher

 ...potential and make a real difference within life sciences, diagnostics and biotechnology? At Beckman Coulter Diagnostics, one of Danaher's 15+ operating companies, our work saves lives-and we're all united by a shared commitment to innovate for tangible impact. You... 

jobgether

Sales Development Representative (SDR) Job at jobgether

 ...We are currently looking for a Sales Development Representative (SDR) in the United States. In this role, you will serve as the...  ...within a sales organization ~ Self-starter with the ability to manage multiple tasks and priorities independently Benefits: ~ Comprehensive...