Senior Technical Specialist Snowflake
Location : Bangalore, Pune, Chennai, Hyderabad, India
Experience : 10+ Years
Role Overview :
As a Senior Technical Specialist Snowflake, you will be a key member of an Agile development team, focusing on building and enhancing critical healthcare applications. Your expertise in Snowflake will be crucial in designing, implementing, and optimizing data solutions that support our mission. You will play a pivotal role in ensuring data availability, reliability, and performance, with a strong emphasis on best practices and operational excellence.
Key Responsibilities :
- Collaborate effectively within an Agile team environment to design, develop, and deploy scalable and efficient data solutions on the Snowflake platform for healthcare applications.
- Implement new features and enhancements, ensuring high-quality code and adherence to established coding development standards and architectural guidelines.
- Contribute significantly to the ongoing maintenance, optimization, and support of existing Snowflake data infrastructure and applications.
- Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO).
- Regularly test backups to ensure meeting the business Recovery Time Objectives (RTO), documenting results and identifying areas for improvement.
- Proactively monitor Snowflake environments, troubleshoot and resolve complex Snowflake-related issues, including providing support during after-hours as needed to ensure continuous operation.
- Optimize Snowflake queries, data pipelines, and data models for performance and cost efficiency.
- Participate in code reviews, providing constructive feedback to peers and ensuring code quality and adherence to best practices.
- Work closely with data architects, solution architects, and business stakeholders to translate business requirements into technical data solutions.
- Stay updated with the latest Snowflake features, best practices, and industry trends to continuously improve our data capabilities.
What You'll Bring :
10+ years of overall experience in data warehousing, data engineering, and database management, with a significant focus on Snowflake.Deep expertise in Snowflake architecture, including virtual warehouses, data sharing, Snowpipe, Streams, Tasks, and external stages.Proficiency in SQL and advanced SQL concepts, with a strong ability to write complex, optimized queries.Extensive experience with data modeling techniques (dimensional modeling, Kimball, Inmon) in a cloud data warehouse environment.Proven track record of managing and troubleshooting production database environments, specifically Snowflake.Solid understanding of backup and recovery strategies for cloud data platforms and the ability to implement and test these strategies effectively.Experience working in an Agile / Scrum development methodology.Familiarity with ETL / ELT tools and processes, and experience building robust data pipelines.Excellent problem-solving skills and the ability to diagnose and resolve complex technical issues under pressure.Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.Experience in the healthcare domain or with healthcare data (e.g., FHIR, HIPAA compliance) is a significant plus.Qualifications :
Bachelor's or Master's degree in Computer Science, Engineering, or a related field.Snowflake certifications (e.g., SnowPro Core, SnowPro Advanced Architect) are highly desirable.Experience with cloud platforms like AWS, Azure, or GCP and their integration with Snowflake is a plus.ref : hirist.tech)