Snowflake Data Engineer

BayOne Solutions; Santa Clara (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

BayOne Solutions in Santa Clara is seeking a Principal Business Intelligence Engineer to lead enterprise data architecture and analytics solutions. This hybrid role requires expertise in Snowflake, ELT/ETL pipelines, and Oracle EBS integrations.

The ideal candidate will collaborate with various teams to deliver scalable analytics solutions while establishing best practices for data governance and performance optimization.

Qualifications

• Strong technical leader with expertise in enterprise data platforms.
• Experience with Snowflake data warehousing and analytics engineering.
• Knowledge of Oracle EBS integrations and hybrid cloud solutions.

Responsibilities

• Lead the design and optimization of Snowflake data warehousing.
• Build scalable ELT/ETL pipelines and dimensional data models.
• Drive enterprise data integration initiatives involving Oracle EBS.

Skills

Enterprise data platforms

Dimensional modeling

ELT/ETL pipelines

Analytics modernization

Snowflake

SQL

APIs

Data modeling

Tools

Snowflake

SQL

dbt

Job description

Principal Business Intelligence Engineer (Oracle EBS)

Santa Clara, CA (Hybrid) - Local to CA Only

Position Overview

We are seeking an experienced Snowflake Engineer to lead enterprise data architecture, Snowflake data warehousing, analytics engineering, and Oracle EBS integrations across a global manufacturing environment.

This role requires a strong technical leader with deep expertise in enterprise data platforms, dimensional modeling, ELT/ETL pipelines, and analytics modernization. The ideal candidate will partner closely with Finance, Supply Chain, Manufacturing, Operations, and IT teams to deliver scalable enterprise analytics solutions.

Key Responsibilities

• Lead the design and optimization of enterprise-scale Snowflake data warehouse and analytics platforms.
• Build scalable ELT/ETL pipelines, dimensional data models, and enterprise reporting layers.
• Drive enterprise data integration initiatives involving Oracle EBS, ERP systems, APIs, and cloud platforms.
• Develop solutions using Snowflake, SQL, dbt, stored procedures, and orchestration frameworks.
• Establish best practices for data modeling, governance, CI/CD, testing, performance optimization, and operational support.
• Serve as the technical lead for enterprise BI and analytics engineering initiatives.
• Mentor engineering teams and collaborate with business stakeholders on scalable analytics solutions.

BayOne is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any federal, state, or local protected class.

This job posting represents the general duties and requirements necessary to perform this position and is not an exhaustive statement of all responsibilities, duties, and skills required. Management reserves the right to revise or alter this job description.