Data Engineer SDE2
CommerceIQ
Company Overview
At CommerceIQ, we help consumer brands accelerate their retail ecommerce market share growth and profitability through machine learning algorithms. We are building the world’s most complete and sophisticated Retail Ecommerce Management Platform, which connects and intelligently automates the management of retail ecommerce channels like Amazon, Walmart, and Instacart, across the entire ecommerce operational chain of retail media management, sales operations, supply chain, and digital self analytics.
We are in hyper growth mode, having recently raised our Series D funding at unicorn valuation (>$1B) and ended our third year of triple-digit revenue growth. Continued acceleration of our growth is fueled by landing new customers, expanding our platform through new products, managing new retail ecommerce platforms, and delivering exceptional customer service to unlock high net retention rates.
The Role:
The team's mission is to maintain the snowflake and schema evolution tool. This involves working with application teams in evolving snowflake schema for various applications, development and maintenance of our in house schema evolution process and tool.
Exploring Snowflake capabilities for role based access, zero copy cloning and resource monitoring to reduce our cost and improve data security.
What You'll Do:
- Enhance and support our in house tool for applying data definition changes to all our snowflake databases.
- Work on enhancing RBAC (Role Based Access Control) and security models in snowflake.
- Enhance and support database access libraries for snowflake.
- Improving and reviewing database schema.
- Reducing snowflake cost by optimizing usage patterns.
- Advocate Snowflake usage and best practices
What You'll Bring:
- Advanced SQL - Beyond just CRUD.
- Able to code in java.
- An understanding of data modeling, data access, data storage, and optimization techniques
- Experience working with cloud based technologies and development processes
- A pragmatic approach and desire to learn new things
- Knowledge on schema model design like STAR schema / Snowflake Snowflake
Something looks off?