Data Engineer - DBT Cloud and Snowflake

Job Title - Data Engineer - DBT Cloud and Snowflake

Type - Contract

Location - Markham, ON

About the Role

Data Engineer - DBT Cloud and Snowflake responsible for delivering high impact data projects, working with Snowflake, dbt Core/Cloud, AWS Cloud Technologies, and multiple programming languages to build performant, reusable, and maintainable data solutions.

Responsibilities

• Deliver over 10 high impact data projects from inception through warranty.
• Design, develop, and maintain data solutions using Snowflake, dbt Core/Cloud, and AWS Cloud Technologies.
• Develop and maintain code in multiple programming languages such as Python and Java.
• Work with relational databases including Snowflake, PostgreSQL, and Amazon Aurora.
• Utilize tools such as Snowsight and Streamlit.
• Write and optimize SQL, Python, Shell, and Terraform code with a strong focus on performance, reusability, and maintainability.
• Provide strong technical and business presentations.
• Identify and address gaps in data designs and processes with both internal and external stakeholders.
• Use orchestration tools like Zena and AWS Managed Airflow for pipeline orchestration.
• Thrive in fast paced, ambiguous, and high pressure environments.
• Communicate insights effectively using tools such as Qlik and SAP BusinessObjects.

Qualifications

• 7 years of professional experience delivering over 10 high impact data projects from inception through warranty.
• 5 years of Snowflake, dbt Core/Cloud, and AWS Cloud Technologies.
• 5 years of experience with coding in multiple programming languages such as Python and Java.

Required Skills

• Extensive Experience: 7 years of professional experience delivering over 10 high impact data projects from inception through warranty.
• 5 years of Snowflake, dbt Core/Cloud, and AWS Cloud Technologies.
• 5 years of experience with coding in multiple programming languages such as Python and Java.
• Deep knowledge of relational databases: Snowflake, PostgreSQL, Amazon Aurora.
• Skilled in tools such as Snowsight and Streamlit.
• Proficiency in SQL, Python, Shell, and Terraform with a strong focus on performance, reusability, and maintainability.
• Strong technical and business presentation skills.
• Ability to identify and address gaps in data designs and processes with both internal and external stakeholders.
• Hands on experience with orchestration tools like Zena and AWS Managed Airflow.
• Resilience and Adaptability: Proven ability to thrive in fast paced, ambiguous, and high pressure environments.
• Skills Mandatory Skills: Snowflake AI/ML, Snowflake-Data Science.

Preferred Skills

• Qlik and SAP BusinessObjects to communicate insights effectively.

"We are committed to fostering an inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by applicable law."