Snowflake Developer
Canada or Mexico or other Nearshore Locations
Contract
Snowflake Developer
This role will be responsible for supporting Snowflake database management and Tableau dashboard development. Key role is to understand user requirements and build query logic to produce expected results.
Responsibilities and duties
Design and implement scalable and efficient data storage solutions using Snowflake. Must have experience with stored procedures, creating data objects, creating different views to be put into Tableau, functions \& data modeling within Snowflake/SQL
Integrate Snowflake with various data sources and third-party tools including Tableau. This person does not need to have experience working on a BI tool
Ensure data security and compliance with industry standards.
Collaborate with cross-functional teams to meet data-driven business objectives.
Stay updated with the latest Snowflake features and best practices.
Required skills and experience:
Snowflake modeling – roles, databases, schemas
SQL performance measuring, query tuning, and database tuning, creating data objects, stored procedures, creating different views
Coding in languages like Python, Java, JavaScript is a nice to have but not necessary
Snowflake warehousing, architecture, processing, administration
Data ingestion into Snowflake
Enterprise-level technical exposure to Snowflake applications
Proficient in SQL and familiar with ETL processes
Understanding of Azure cloud services including Azure Data Factory
Experience with data modeling and cloud computing environments.
Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
Understanding of data compliance and security best practices
Preferred skills and experience:
Familiarity with BI such as Tableau
Proven track record of data migration and optimization within Snowflake
Ability to translate business needs into technical specifications.
Experience in performance tuning and cost optimization in a cloud data platform.
Knowledge of master data management, data warehousing and business intelligence architecture.
Experience in data modeling and database design with excellent knowledge of SQL Server best practices.
Excellent interpersonal/communication skills (both oral/written) with the ability to communicate at various levels with clarity \& precision.
Should have clear understanding of DW lifecycle and contribute in preparing Design documents, Unit Test plans, Code review reports.
Experience working in Agile environment (Scrum, Lean, Kanban) is a plus
Qualifications \& Experience:
Should have 4 to 5 years of experience in Data Management and specialized in Analytical data warehouse.
2-3 year hands on with Snowflake cloud warehouse.
Job Type: Contract
Contract length: 6 months
Pay: $200.00 - $250.00 per hour
Expected hours: 40 per week
Experience:
Snowflake: 5 years (Required)
Tableau: 5 years (Required)