Responsibilities and Duties:
· Candidate must be able to design, develop and implement efficient and scalable data storage solutions using Snowflake.
· Must be able to Write, optimize, and troubleshoot SQL queries within the Snowflake and SQL Server environments.
· Integrate Snowflake with various data sources and third-party tools: for example: Salesfore, AWS S3, SQL Server.
· Ensure data security (data encryption) and compliance with industry standards.
· Collaborate with cross-functional (internal and client) teams to meet data-driven business objectives.
· Stay updated with the latest Snowflake features and best practices.
Required skills and experience:
· Candidate must possess a Bachelor's degree in Computer Science, Computer Engineering, or a software-related discipline or similar work experience in relevant field.
· Mastery skills in SQL and familiar with ETL (extraction, transformation, and Load) processes
· Experience with data modeling and cloud computing environments
· Must possess hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
· Understanding of data compliance and security best practices
· Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe,Able to administer and monitor Snowflake computing platform
· Handling large and complex sets of XML, JSON, and CSV from various sources and databases
· Experience with any scripting languages, preferably Python
Preferred skills and experience:
· SnowPro Certification
· Familiarity with BI tools integration, such as Tableau or Looker
· 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
Flexible work from home options available.