About BayRock Labs
At BayRock Labs, we pioneer innovative tech solutions that drive business transformation. As a leading product engineering firm based in Silicon Valley, we provide full-cycle product development, leveraging cutting-edge technologies in AI, ML, and data analytics. Our collaborative, inclusive culture fosters professional growth and work-life balance. Join us to work on ground-breaking projects and be part of a team that values excellence, integrity, and innovation. Together, let's redefine what's possible in technology.
We are seeking a highly skilled Snowflake Data Engineer to design, develop, and optimize our enterprise data foundation, specifically for our production-level AI applications built on Snowflake Cortex. This role is crucial for ensuring the AI agents receive clean, aggregated, and optimized data efficiently.
Key Responsibilities
- Snowflake Architecture & Design: Design and implement scalable and high-performance data models (e.g., Data Vault, Dimensional Modeling) within Snowflake, specifically structuring data for AI/ML consumption.
- Data Aggregation & Optimization: Lead the effort to reduce our existing columns down to the necessary, non-duplicated, and optimized feature set required by the AI Agents.
- ETL/ELT Development: Develop robust and performant ELT pipelines using Snowpipe, Tasks, Streams, and Dynamic Tables to aggregate data from diverse sources into Snowflake.
- Performance Tuning: Optimize Snowflake queries, clustering keys, and warehouse sizing to ensure low latency data retrieval for real-time agent workflows and baseline report generation.
- Collaboration: Work closely with the AI/ML Agent Developers to expose data via optimized views, UDFs, and Stored Procedures that can be easily called by Snowpark or Cortex Analyst tools.
- Data Governance: Ensure data quality, lineage, and adherence to security policies (e.g., Row Access Policies, Data Masking) within the Snowflake environment.
Required Skills & Qualifications
- Expert-level proficiency in Snowflake architecture, optimization, and advanced features (e.g., Streams, Dynamic Tables, Time Travel).
- Deep expertise in SQL and data modeling for high-volume, complex datasets.
- Strong hands-on experience with Python and Snowpark for custom data transformation logic.
- Proven ability to perform data cleansing, feature engineering, and dimensional reduction (reducing columns).
Top Skills
What We Do
Welcome to BayRock Labs, a global leader in engineering excellence and innovation. With HQ in the USA and inspired by Silicon Valley, we create scalable products driving business success. Our mission is simple: harness technology's power with unmatched agility and expertise. With 2000+ consultants worldwide, we deliver cutting-edge solutions to 70+ clients. Our track record: 500+ products, earning us trust as an innovation partner. From groundbreaking mobile apps to cloud optimization, excellence is our hallmark. Agility is our foundation, adapting swiftly to industry demands. At BayRock Labs, creativity and flexibility fuel innovation.
At BayRock Labs, we understand that great products are born from collaboration and expertise. That's why we've established four specialized labs to focus on different aspects of software product engineering:
1. Experience Labs: Where UX and Product Management converge to create intuitive and customer-centric solutions.
2. Engineering Labs: Focused on full-stack frameworks and development to ensure the highest quality and efficiency in engineering.
3. Data Labs: Harnessing the power of AI/ML and modeling to unlock insights and drive informed decision-making.
4. Cloud Labs: Dedicated to DevSecOps and security, ensuring the scalability and reliability of cloud-based solutions.
Our comprehensive suite of services covers a wide range of areas, including:
* Product Development
* Web/Mobile App Development
* IT Ops (Apps/Cloud)
* IT Consulting
* Bolt-ons for Enterprise Apps (CRM, ERP) Management
At BayRock Labs, we promote diversity and inclusion in the tech industry. We believe diversity drives innovation, so we actively promote and support women in technology roles.
Join us at BayRock Labs and be part of a team that is shaping the future of technology. Together, let's build products that transform businesses and change lives.
.png)
