Design and implement efficient data models and schemas in Snowflake, considering factors such as performance, scalability, and data governance.
Develop and maintain data pipelines to ingest, transform, and load data from various sources into Snowflake, ensuring data quality and reliability.
Optimize SQL queries, warehouse configuration, and ETL processes to maximize performance and minimize resource consumption.
Implement and enforce security controls, data encryption, and access policies to protect sensitive data and ensure compliance with regulatory requirements.
Collaborate with data architects, engineers, and analysts to understand data requirements and design solutions that meet business needs.
Lead efforts to automate and orchestrate Snowflake administration tasks, such as provisioning, scaling, monitoring, and backup/recovery.
Stay up-to-date with the latest Snowflake features, updates, and best practices, and proactively identify opportunities to improve data platform capabilities.
Participate in cross-functional projects and initiatives, working closely with stakeholders to deliver data-driven insights and drive business outcomes.
Qualifications:
6+ years of experience in data engineering, with at least 3 years of hands-on experience with Snowflake.
Strong proficiency in SQL and experience with performance tuning and optimization techniques.
In-depth understanding of Snowflake architecture, features, and capabilities, including virtual warehouses, data sharing, and semi-structured data handling.
Experience designing and implementing scalable data solutions using Snowflake, including data modeling, ETL/ELT processes, and data warehousing best practices.
Solid understanding of data governance, security, and compliance requirements in a cloud data environment. - Exposure to agile development methodologies
