Snowflake Engineer II or III

Requirements

• Design and build scalable, secure, and cost-effective data solutions using Snowflake's architecture, including virtual warehouses, databases, and schemas.
• Develop and optimize complex SQL, Python, and other code for ELT/ETL processes to load, transform, and manage data within the Snowflake environment.
• Implement data pipelines using Snowflake features like Snowpipe, Streams, and Tasks, along with orchestration tools like dbt or Airflow.
• Monitor and fix query performance, analyze execution plans, and implement solutions to ensure efficient data processing.
• Implement robust data governance and security measures, such as role-based access control (RBAC), data masking, and encryption.
• Automate essential data processes and deployment workflows using CI/CD pipelines, Git-based version control, and scripting languages.
• Collaborate with data engineers, architects, data scientists, and business partners to define requirements and deliver solutions that meet business needs.
• Mentor other engineers and support collaboration within the team, setting and promoting data engineering standards and proven methods.

Benefits

• Paid time off
• Paid holidays
• Community service and self-care days
• Medical/dental/vision/pharmacy insurance
• 401(k) matching and non-contributory plan
• Life insurance
• Short and long term disability
• Education reimbursement
• Employee assistance plan (EAP)
• Adoption assistance program
• Paid family leave program