Serve as a Snowflake Data modeler specializing in Snowflake streams Snowflake SQL and Snowpipe to design build and optimize cloud based data solutions that enable high quality analytics and reporting for global stakeholders. Collaborate in a hybrid work setting to deliver secure scalable and reliable data pipelines that support critical business decision making and societal impact through data driven insights.
Responsibilities
Design detailed Snowflake based data models that support reliable analytics and reporting while aligning to enterprise data standards and performance expectations.
Develop robust Snowflake SQL code that transforms raw data into curated datasets with clear structure strong data quality and efficient query performance.
Build and configure Snowflake streams to capture incremental data changes accurately and ensure near real time data availability for downstream consumers.
Implement and optimize Snowpipe to automate secure data ingestion from diverse sources minimizing latency and manual intervention in data loading.
Optimize query performance by tuning Snowflake SQL clustering strategies and warehouse configurations to reduce cost and improve response times for complex workloads.
Collaborate with data engineers analysts and product teams in a hybrid work model to translate functional requirements into scalable Snowflake based technical solutions.
Ensure adherence to data governance security and compliance standards by applying access controls masking policies and reliable audit mechanisms within Snowflake environments.
Troubleshoot production issues in Snowflake streams Snowpipe and SQL workloads by performing root cause analysis and implementing preventive improvements.
Document solution designs data flow diagrams and operational runbooks clearly so that teams can maintain extend and reuse Snowflake components effectively.
Contribute to continuous improveme