Role: Snowflake Developer
Location: Canada (REMOTE)
Duration: Contractual
Experience Req: 5+ Years
What You Will Do
· Impressico is looking for snowflake developers to work on building data ingestion pipelines, their orchestration and eventually build the Datawarehouse on its clients’ projects.
· Create and maintain enterprise-level applications using the Snowflake platform.
· Design efficient data models tailored to Snowflake's architecture.
· Manage data migration, including extracting, transforming, and loading data into Snowflake.
· Work with data engineers, analysts, and other stakeholders to understand requirements and deliver solutions.
· Optimization: Ensure the performance and scalability of Snowflake environments to meet business needs.
· Testing and Deployment: Write code, conduct unit tests, and deploy new features.
· Work with internal and external stakeholders to assist with data-related technical issues and support data infrastructure needs
· Enable and run data ingestions from different sources like DB, streaming, files, SFTP.
· Perform thorough testing and validation in order to support the accuracy of data transformations and data verification to be used by downstream applications
· Recommend different ways to constantly improve data reliability and quality.
Must have Skills
· Proficiency in SQL: Strong grasp of SQL for database queries and optimization.
· Data Warehousing: Experience with data warehousing and dimensional modelling.
· Cloud Computing: Familiarity with cloud services like AWS, Azure, or Google Cloud Platform.
· Analytical Skills: Strong problem-solving and analytical abilities.
· CICD
· Hands-on experience in ETL tools, frameworks, processes
· Hands-on experience working on a data warehouse
· Hands-on experience working with multiple databases
Good to Have
· Other cloud experience like Azure/Google Cloud Platform or Databricks experience.
· Coding in Python is good to have.
· Matillion experience