Snowflake/Python -Mississauga, ON or Montreal, QC
About the role
Role: Data Engineer with Python and Snowflake
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.
About W3Global
W3Global is a leading provider of end-to-end consulting services, empowering businesses to achieve their strategic goals and optimize their operations. With over 15 years of experience, we have a proven track record of delivering innovative and effective solutions across a wide range of industries.
Our Mission
At W3Global, we are committed to helping businesses of all sizes achieve their full potential. We believe that by combining our deep industry expertise with our innovative approach, we can deliver exceptional results that exceed our clients' expectations.
Our Services
We offer a comprehensive suite of consulting services designed to address the specific needs of our clients. Our services include:
Strategy Consulting: We help businesses develop and implement winning strategies to achieve their long-term goals.
Business Process Improvement: We identify and optimize business processes to enhance efficiency, reduce costs, and improve customer satisfaction.
Technology Consulting: We provide expert guidance on technology selection, implementation, and integration to support business objectives.
Talent Acquisition: We help businesses find and hire the right talent to support their growth and success.
Human Capital Management: We provide comprehensive HR solutions to help businesses manage their workforce effectively.
Snowflake/Python -Mississauga, ON or Montreal, QC
About the role
Role: Data Engineer with Python and Snowflake
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.
About W3Global
W3Global is a leading provider of end-to-end consulting services, empowering businesses to achieve their strategic goals and optimize their operations. With over 15 years of experience, we have a proven track record of delivering innovative and effective solutions across a wide range of industries.
Our Mission
At W3Global, we are committed to helping businesses of all sizes achieve their full potential. We believe that by combining our deep industry expertise with our innovative approach, we can deliver exceptional results that exceed our clients' expectations.
Our Services
We offer a comprehensive suite of consulting services designed to address the specific needs of our clients. Our services include:
Strategy Consulting: We help businesses develop and implement winning strategies to achieve their long-term goals.
Business Process Improvement: We identify and optimize business processes to enhance efficiency, reduce costs, and improve customer satisfaction.
Technology Consulting: We provide expert guidance on technology selection, implementation, and integration to support business objectives.
Talent Acquisition: We help businesses find and hire the right talent to support their growth and success.
Human Capital Management: We provide comprehensive HR solutions to help businesses manage their workforce effectively.