Supervisor - Snowflake Engineer

We are currently seeking an experienced Snowflake Engineer for our Data Analytics team. This role involves designing, building, and maintaining our Snowflake cloud data warehouse. Candidates should have strong Snowflake, SQL, and cloud data solutions experience.

Responsibilities:

• Design, develop, and maintain efficient and scalable data pipelines in Snowflake, encompassing data ingestion, transformation, and loading (ETL/ELT).
• Implement and manage Snowflake security, including role-based access control, network policies, and data encryption.
• Develop and maintain data models optimized for analytical reporting and business intelligence.
• Collaborate with data analysts, scientists, and stakeholders to understand data requirements and translate them into technical solutions.
• Monitor and troubleshoot Snowflake performance, identifying and resolving bottlenecks.
• Automate data engineering processes using scripting languages (e.g., Python, SQL) and orchestration tools (e.g., Airflow, dbt).
• Designing, developing, and deploying APIs within Snowflake using stored procedures and user-defined functions (UDFs)
• Lead and mentor a team of data engineers and analysts, providing technical guidance, coaching, and professional development opportunities.
• Stay current with the latest Snowflake features and best practices.
• Contribute to the development of data engineering standards and best practices.
• Document data pipelines, data models, and other technical specifications.

Qualifications:

• Bachelor's degree or higher in computer science, Information Technology, or a related field.
• A minimum of 5 years of experience in data engineering and management, including over 3 years of working with Snowflake.
• Strong understanding of data warehousing concepts, including dimensional modeling, star schemas, and snowflake schemas.
• Proficiency in SQL and experience with data transformation and manipulation.
• Experience with ETL/ELT tools and processes.
• Experience with Apache Iceberg.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.

Preferred Qualifications:

• Snowflake certifications (e.g., SnowPro Core Certification).
• Experience with scripting languages (e.g., Python) and automation tools (e.g., Airflow, dbt).
• Experience with cloud platforms (e.g., AWS, Azure, GCP).
• Experience with data visualization tools (e.g., Tableau, Power BI).
• Experience with Agile development methodologies.
• Experience with Snowflake Cortex, including Cortex Analyst, Arctic TILT, and Snowflake AI & ML Studio.