Key Responsibilities
- Design and implement scalable Snowflake data warehouse solutions to meet complex analytics and reporting objectives, ensuring high availability and performance
- Develop, optimize, and maintain ETL pipelines using SQL, Python, and DataStream, achieving efficient data ingestion and transformation with measurable throughput targets
- Configure and manage Snowflake features such as Time Travel, Fail Safe, Snowpipe, and SnowSQL to ensure robust data management, recovery, and automation
- Collaborate with cross-functional teams to gather data requirements and deliver reliable, high-performance data solutions aligned with business goals
- Develop and maintain stored procedures using PLSQL and T-SQL to automate business logic and streamline data processing workflows
- Monitor data platform performance, proactively troubleshoot issues, and implement improvements to optimize query efficiency and resource utilization
- Enforce data integrity, security, and compliance standards across all Snowflake environments and data pipelines
- Document technical designs, data flows, and operational procedures to support ongoing maintenance and facilitate knowledge sharing
Required Skills
- Expertise in Snowflake data warehouse architecture, administration, and feature configuration
- Advanced SQL skills for complex query development and optimization
- Hands-on experience developing ETL pipelines with Python and DataStream
- Proficiency in Snowpipe for continuous data loading and automation
- Experience using SnowSQL for command-line operations
- Strong skills in developing stored procedures with PLSQL and T-SQL
- Ability to configure and utilize Time Travel and Fail Safe features in Snowflake
Preferred Skills
- Experience with cloud data platforms (AWS, Azure, Google Cloud)
- Familiarity with data governance and security best practices
- Knowledge of data modeling techniques for analytical workloads
- Exposure to CI/CD pipelines for data engineering projects
- Experience with performance tuning and query optimization in Snowflake
Desired Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline
- Snowflake SnowPro Core Certification
- Certification in data engineering or cloud platforms, such as Google Cloud Professional Data Engineer or Microsoft Azure Data Engineer Associate
Rate:
Not specified
Location:
Remote
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Mid-Level