Snowflake Developer

Machine Learning Technologies, LLC; San Jose (CA); In loco; USD 120.000 - 200.000; Tempo pieno

Descrizione del lavoro

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

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Snowflake data models

Complex SQL

LLM integration

RBAC architecture

Data integration

SnowPro certification

Supply Chain/Cisco experience

Descrizione del lavoro

We are looking for an experienced Snowflake Developer with strong expertise in Snowflake, SQL, Python, and data warehousing. The ideal candidate will be responsible for developing and optimizing data pipelines, implementing data integration solutions, and ensuring efficient data processing and storage.

Required Skills:

• Design and Develop snowflake data models/complex calculation views
• Complex SQL Queries, optimization for cost reduction
• LLM integration/Proficient with Cortex
• RBAC controlled data architecture
• Data Integration/Ingestion with multiple data sources Oracle, Hana (plus)
• Snowflake SnowPro certification (plus)
• Supply Chain/Cisco experience (plus)

Key Responsibilities:

• Design, develop, and maintain data warehouse solutions using Snowflake.
• 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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.