What are the responsibilities and job description for the Snowflake Technical Lead position at Xoriant Corporation?
Job Requirements
Key Responsibilities & Experience:
Work Experience
Core Skills: Snowflake, dbt, SQL, Python, GitHub, Snowflake Cortex, CI/CD, Data Modeling, Enterprise Integrations, Cloud Architecture, Agile Delivery
Key Responsibilities & Experience:
- Lead design, development, and integration activities for the Kraken platform and associated data solutions.
- Refactor legacy SQL views and ETL processes into scalable, reusable dbt models implementing SCD Type 1 patterns.
- Optimize Snowflake performance through query tuning, warehouse sizing, clustering, and micro-batch incremental processing.
- Establish and manage CI/CD pipelines for dbt projects using GitHub, Snowflake Cortex Code, and Snowflake Tasks orchestration.
- Drive architecture decisions, code reviews, and best practices across data engineering and analytics teams.
- Collaborate with business, product, and engineering stakeholders to deliver reliable, high-performing solutions.
- Mentor development teams and ensure adherence to security, scalability, and operational excellence standards.
Work Experience
Core Skills: Snowflake, dbt, SQL, Python, GitHub, Snowflake Cortex, CI/CD, Data Modeling, Enterprise Integrations, Cloud Architecture, Agile Delivery