Skill: Snowflake DBT
Experience: 6 to 9 years
Location: AIA Chennai
Job Summary
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 environment 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 solid 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.
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 improvement by evaluating new Snowflake features suggesting enhancements to data pipelines and sharing best practices with peers.