Snowflake Technical Specialist

Job Summary

The Technical Specialist will be responsible for managing Snowflake data platform, using DBT for transformation, and developing SQL and Python scripts to support data operations. They will play a key role in optimizing and maintaining database performance, ensuring data quality, and implementing data pipelines.

Key Responsibilities

1. Manage and administer snowflake data platform including security, access control, and performance optimization.

2. Utilize dbt to create and maintain data transformation workflows, ensuring data accuracy and consistency.

3. Develop sql queries and stored procedures to extract and manipulate data for business requirements.

4. Write python scripts for automating data tasks, data processing, and data quality checks.

5. Collaborate with cross functional teams to design and implement efficient data pipelines and etl processes.

6. Troubleshoot and resolve data related issues, ensuring data integrity and reliability.

7. Stay updated with the latest trends and best practices in snowflake, dbt, sql, and python to enhance data operations.

Skill Requirements

1. Strong experience working with snowflake data platform, including administration, security, and performance tuning.

2. Proficiency in utilizing dbt for data transformation and modeling.

3. Excellent command of sql for querying and manipulating data in databases.

4. Advanced coding skills in python for scripting, automation, and data processing.

5. Ability to collaborate effectively with cross functional teams to deliver data solutions.

6. Strong analytical and problem-solving skills to troubleshoot data issues and optimize data processes.

Other Requirements

1.Snow Pro Core Certification in Snowflake would be a plus.