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

tapouts

Freelance Illustrator (1-Week Project) Job at tapouts

 ...Freelance Illustrator (1-Week Project) Timeline: 12 weeks Rate: $40$60/hour (1020 hours) Start: ASAP | Remote Scope: Design six two-sided collectible cards (2.5"3.5") for kids (ages 416). Each card features one tapouts mascot: Captain Confidence... 

Brainfuse

Online K-8 Math & ELA Tutor (Remote, Fixed 4-Hour Schedule) Job at Brainfuse

 ...Brainfuse is a leading provider of online tutoring and educational support, partnering with schools and districts nationwide to help K...  ...Overview: We're seeking experienced online educators to teach Math and ELA to K8 students in a structured, semester-long program.... 

Check-Mate Industries

1st shift: Part-time Worker- (Shifts: 10-2 M-F or 7-3:30 T,W,TH)- 15.00 hourly Job at Check-Mate Industries

 ...Part-time Assembly, Resize, Fabrication and Finishing As a part-time worker, you will...  ...Candidates can choose the following shifts: ~20 hours per week ~ Monday through Friday (10:00...  ...(7:00 a.m. 3:30 p.m.) Pay: ~$15.00/hour (paid weekly) EOE/AA/M/F/ET/D... 

Top Level Promotions

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

 ...Work from Home Data Entry & Office Administration Remote Online Role About the Job We are...  ...Pennsylvania, United States , for an entry-level remote position in office...  ...Festivals, Distribution Health Care Public & Home Care Manufacturing Raw Materials... 

Rooted Talent Solutions

Copy of Healthcare Recruiter Job at Rooted Talent Solutions

 ...Job Title: Healthcare Recruiter (Remote, Independent Contractor) Company: Rooted Talent Solutions Location: Remote (U.S. only) Compensation: Commission-based (Starting at $1,800 per successful placement) About Us: Rooted Talent Solutions is a dynamic staffing...