Snowflake Data Engineer: Pipelines, Modeling & Optimization

Machine Learning Technologies, LLC; San Jose (CA); On-site; USD 120,000 - 200,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking an experienced Snowflake Developer to design and optimize data models, pipelines, and SQL queries for robust data warehousing solutions. The role focuses on efficient data processing, cost-aware query design, and secure RBAC-based data architectures, with opportunities to integrate LLMs and Cortex for advanced analytics.

The ideal candidate will collaborate with data engineers and business teams to deliver reliable data ingestion, transformation, and

Qualifications

• Design and develop Snowflake data models and complex calculation views.
• Complex SQL queries with optimization for cost and performance.
• Experience with LLM integration and Cortex.
• RBAC-based data architecture and security controls.
• Data integration/ingestion from multiple sources (Oracle, Hana, etc.).
• SnowPro certification preferred.
• Experience in supply chain or Cisco environments preferred.

Responsibilities

• Design, develop, and maintain Snowflake-based data warehouse solutions.
• Develop and optimize SQL queries, stored procedures, and data transformation processes.
• Build and maintain ETL/ELT pipelines for data ingestion and integration.
• Monitor and optimize query performance and resource utilization.
• Perform data validation and troubleshoot data-related issues.
• Collaborate with data engineers, architects, and business teams to meet data requirements.
• Support production deployments, testing, and ongoing maintenance.
• Maintain technical documentation and follow data engineering best practices.

Skills

Snowflake data models

Complex SQL

LLM integration

RBAC architecture

Data integration

SnowPro certification

Supply Chain/Cisco experience

Job description

Machine Learning Technologies, LLC is seeking an experienced Snowflake Developer to design and optimize data models, pipelines, and SQL queries for robust data warehousing solutions. The role focuses on efficient data processing, cost-aware query design, and secure RBAC-based data architectures, with opportunities to integrate LLMs and Cortex for advanced analytics.

The ideal candidate will collaborate with data engineers and business teams to deliver reliable data ingestion, transformation, and