Snowflake Developer - Data Modeling

About The Role

Key Responsibilities

• Design, develop, and maintain Snowflake-based data warehouse solutions to support business analytics and reporting.
• Write and optimize complex SQL queries for data extraction, transformation, and reporting purposes.
• Develop and manage stored procedures, UDFs, and tasks in Snowflake using SQL and JavaScript.
• Implement and manage data integration between Snowflake and external systems using ETL tools, APIs, or Snowpipe.
• Create and maintain logical and physical data models, ensuring data quality, integrity, and consistency across environments.
• Collaborate with data engineers, analysts, and business stakeholders to translate requirements into technical solutions.
• Monitor system performance, troubleshoot issues, and implement performance tuning best practices.
• Enforce security, access controls, and compliance policies within Snowflake.
  

Required Skills & Qualifications

• Strong hands-on experience with Snowflake platform and architecture.
• Proficiency in Python libraries for data processing and automation.
• Advanced skills in SQL with expertise in writing and optimizing complex queries.
• Experience with stored procedures, UDFs, and scheduling tasks in Snowflake.
• Familiarity with data integration tools such as Informatica, Talend, Apache Airflow, DBT, or Fivetran.
• Strong understanding of data modeling (star/snowflake schemas) and data warehouse design principles.
• Knowledge of cloud platforms (AWS, Azure, or GCP) and Snowflake integrations with them.
• Proven experience handling large datasets and optimizing data loads/queries for high performance.
• Strong analytical, problem-solving, and communication skills