Snowflake Solution Architect - ETL

Key Responsibilities :

• Design and implement efficient data models, including star schema and snowflake schema.
• Define data quality rules and standards to ensure data accuracy and consistency.
• Create and manage data pipelines using Snowpipe and other ETL tools.
• Write complex SQL queries and stored procedures to extract, transform, and load data.
• Utilize Snowflake's advanced features, such as micro-partitions, time travel, and zero-copy clones.
• Optimize query performance and troubleshoot performance issues.
• Implement data security and access controls to protect sensitive data.
• Integrate Snowflake with other cloud services, such as AWS S3 or Azure Blob Storage.
• Leverage cloud-native technologies to build scalable and cost-effective data solutions.
• Establish data governance policies and procedures to ensure data quality and compliance.
• Collaborate with data stewards and business analysts to understand data requirements.
• Diagnose and resolve complex data issues and performance bottlenecks.
• Proactively identify and address potential problems.

Qualifications :

ref : hirist.tech)