Description
Key Skills: Snowflake SQL, Python, Snowflake Cortex, Amazon S3, Snowflake Tasks, Data Engineering, Cloud Platforms, SQL Optimization, Data Analytics, ETL
Good to Have Skills: Experience with Snowflake streams, enterprise grade practices including source control, continuous integration, continuous delivery, testing strategies and monitoring for data solutions. Preferred certifications include SnowPro Advanced Architect and AWS Certified Data Analytics or equivalent cloud data engineering credentials. Strong communication skills with technical and non-technical stakeholders in hybrid working environments.
Roles & Responsibilities:
- Design and implement robust data solutions using Snowflake Cortex Code and core Snowflake capabilities to support complex analytics and reporting needs.
- Develop efficient Python components that orchestrate data workflows and integrate external services with Snowflake to deliver reliable data products.
- Configure and optimize Snowflake Tasks to automate recurring data pipelines while ensuring predictable execution monitoring and timely recovery.
- Engineer secure and efficient data ingestion patterns from Amazon S3 into Snowflake including structured and semi-structured data.
- Optimize Snowflake SQL queries views and stored logic to improve performance control compute costs and provide responsive data experiences.
- Collaborate with data engineers analysts and product teams to translate business needs into technical specifications and deliver measurable outcomes.
- Implement strong security and governance practices within Snowflake and Amazon S3 including data access patterns and compliance requirements.
- Troubleshoot complex production issues across Snowflake Python components and Amazon S3 integrations while providing clear root cause analysis.
- Create and maintain detailed technical documentation that explains data models pipeline logic operational runbooks and environment configurations.
- Introduce and apply best practices for version control testing and deployment of Snowflake and Python assets to improve stability.
- Mentor less experienced developers by sharing practical guidance on Snowflake Python and cloud data patterns to improve team capability.
- Continuously evaluate new Snowflake Cortex features and related cloud capabilities to propose improvements that enhance efficiency and innovation.
Experience Required: Seven to ten years of hands-on experience in data engineering or advanced analytics development with strong focus on cloud-based data platforms. Deep proficiency in Snowflake SQL including complex joins, window functions, performance tuning and secure data sharing for analytics workloads