Snowflake DeveloperCanada or Mexico or other Nearshore LocationsContract**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- 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 plusQualifications & 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**: ContractContract length: 6 monthsPay: $****** - $****** per hourExpected hours: 40 per week