Data Engineer - DBT Cloud and Snowflake

Job summary

Deliver data projects from inception through warranty, designing and maintaining performant, reusable data solutions with Snowflake, dbt, AWS, and multiple programming languages. Orchestrate pipelines, identify gaps in data designs and processes, and communicate technical and business insights to stakeholders.

Job details

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."

What you’ll do

Deliver data projects from inception through warranty, designing and maintaining performant, reusable data solutions with Snowflake, dbt, AWS, and multiple programming languages. Orchestrate pipelines, identify gaps in data designs and processes, and communicate technical and business insights to stakeholders.

Requirements

Requires seven years of professional experience delivering high-impact data projects and five years of experience with Snowflake, dbt Core/Cloud, AWS technologies, and programming languages such as Python and Java. Candidates should have relational database, orchestration, coding, and presentation expertise, and be able to work effectively in fast-paced, ambiguous, high-pressure environments.

Listed skills

• Python · Preferred
• Java · Preferred
• SQL · Preferred
• Terraform · Preferred
• PostgreSQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Snowflake
• Snowflake AI/ML
• Snowflake Data Science
• dbt Core/Cloud
• AWS Cloud Technologies
• Python
• Java
• SQL
• Shell
• Terraform
• PostgreSQL
• Amazon Aurora
• Snowsight
• Streamlit
• Zena
• AWS Managed Airflow

Job areas

• Data & Analytics
• Technology
• Software
• Consulting

More jobs from Enterprise Solutions Inc.