Snowflake Developer - Data Modeling

<p><p><b>About the Role : </b></p><p><br/></p><p>We are looking for a highly skilled Snowflake Developer to design, develop, and optimize scalable data warehouse solutions.<br/><br/>The ideal candidate will have strong expertise in SQL, data modeling, and Snowflake development, along with hands-on experience in integrating Snowflake with various systems and building efficient data pipelines.<br/><br/><b>Key Responsibilities : </b></p><p><br/></p><p>- Design, develop, and maintain Snowflake-based data warehouse solutions to support business analytics and reporting.<br/><br/>- Write and optimize complex SQL queries for data extraction, transformation, and reporting purposes.<br/><br/>- Develop and manage stored procedures, UDFs, and tasks in Snowflake using SQL and JavaScript.<br/><br/>- Implement and manage data integration between Snowflake and external systems using ETL tools, APIs, or Snowpipe.<br/><br/>- Create and maintain logical and physical data models, ensuring data quality, integrity, and consistency across environments.<br/><br/>- Collaborate with data engineers, analysts, and business stakeholders to translate requirements into technical solutions.<br/><br/>- Monitor system performance, troubleshoot issues, and implement performance tuning best practices.<br/><br/>- Enforce security, access controls, and compliance policies within Snowflake.<br/><br/><b>Required Skills & Qualifications : </b></p><p><br/></p><p>- Strong hands-on experience with Snowflake platform and architecture.<br/><br/>- Proficiency in Python libraries for data processing and automation.<br/><br/>- Advanced skills in SQL with expertise in writing and optimizing complex queries.<br/><br/>- Experience with stored procedures, UDFs, and scheduling tasks in Snowflake.<br/><br/>- Familiarity with data integration tools such as Informatica, Talend, Apache Airflow, DBT, or Fivetran.<br/><br/>- Strong understanding of data modeling (star/snowflake schemas) and data warehouse design principles.<br/><br/>- Knowledge of cloud platforms (AWS, Azure, or GCP) and Snowflake integrations with them.<br/><br/>- Proven experience handling large datasets and optimizing data loads/queries for high performance.<br/><br/>- Strong analytical, problem-solving, and communication skills</p><br/></p> (ref:hirist.tech)