We are looking for an experienced Snowflake Developer to design, implement, and optimize data solutions on the Snowflake platform. The ideal candidate will have strong expertise in data warehousing, ELT/ETL processes, cloud platforms, and performance tuning to ensure scalable, secure, and efficient data solutions.
Roles & Responsibilities
- Design scalable and efficient data warehouse schemas, tables, and views.
- Build and maintain data pipelines to extract, load, and transform data from sources such as AWS S3, Azure, or other cloud platforms into Snowflake.
- Tune SQL queries, optimize virtual warehouse sizes, and implement best practices for high-performance, cost-efficient data processing.
- Implement security measures including row-level security, masking, and data access policies to ensure compliance and governance.
- Create and maintain Snowflake stored procedures, User-Defined Functions (UDFs), and scripts to support business requirements.
- Plan and execute migration of legacy databases to Snowflake while ensuring data integrity and minimal downtime.
- Work with cross-functional teams, including data engineers, analysts, and business stakeholders, to deliver robust data solutions.
Required Skills and Qualifications
- Strong knowledge of SnowSQL, data loading techniques (COPY), data sharing, and Snowflake best practices.
- Advanced SQL skills; proficiency in Python, Java, or other relevant programming languages.
- Experience with data warehousing concepts such as star schema, snowflake schema, and dimensional modeling.
- Hands-on experience with ETL/ELT tools such as Talend, Informatica, or Apache Airflow.
- Familiarity with cloud services like AWS, Azure, or GCP.
- Strong analytical skills and the ability to communicate technical concepts clearly to stakeholders.