Mill is looking to prevent waste, specifically food waste, by building better environments and tackling climate and kitchen change. The data team supports this by providing frameworks to collect, transform, and curate data for internal use and user-facing features.
Requirements
- 3 - 5 years of experience as a data engineer or software engineer writing and testing data pipelines using Snowflake and AWS
- Hands on experience with Snowflake administration and familiarity with Role Based Access Control (RBAC)
- Experience with Infrastructure as Code tools (CDK, Terraform)
- Knowledge of best practices in collecting, cleaning, and managing data across Snowflake and other platforms like Customer Data Platforms and reporting platforms
- Experience writing Python and SQL
Responsibilities
- Develop, test, and deploy scalable data pipelines processes on cloud-based infrastructure using AWS and Snowflake
- Design, implement, and manage data access and management systems in Snowflake
- Optimize and tune Snowflake performance, including query optimization, resource management, and scaling strategies
- Solve challenges faced by a growing data team involving data storage, transformation, and security
- Read, write, and debug data processing and orchestration code written in SQL and Python
Other
- The estimated base salary range for this position is $140k to $175k, which does not include the any benefits or equity. Various factors are considered in making compensation decisions, including but not limited to experience, training, licensure and certifications, and business and organizational needs.
