Data Engineer

BlueRose Technologies

📍San Ramon, CA

Posted May 21, 2026

← Back to Jobs

Job Overview

Position

Data Engineer

Company

BlueRose Technologies

Location

San Ramon, CA

Work Type

On-site

Job ID

li-4418116850

Job Description

<< Locals to CA needs to apply >>
**Data Engineer

San Ramon, CA (Hybrid/2 Days Onsite)

12+ months**
Interview - Phone then In-Person
We are looking at 10+ years of overall experience with at least strong of hands-on experience with AWS, SQL, Python, Pyspark and Snowflake.

✦

Interview Prep

AI-powered insights to help you prepare

Key Skills

Required:

Preferred:

Practice Questions

💡Technical Questions (3)

1.How do you design an efficient data pipeline using AWS, PySpark, and Snowflake to process large-scale streaming data?
2.Can you explain how you would optimize a slow-running SQL query in Snowflake?
3.What are the common challenges you have faced when writing PySpark applications, and how do you overcome them?

🎯Behavioral Questions (3)

1.Tell me about a time you had to migrate a complex data pipeline to AWS and Snowflake. What was your approach and the outcome?
2.Describe a situation where you had to troubleshoot a critical data pipeline failure under a tight deadline.
3.With this being a hybrid role requiring 2 days onsite, tell me about a time you successfully collaborated with cross-functional teams in a hybrid or remote environment.

🧩Situational Questions (2)

1.You discover that a PySpark job writing to Snowflake is suddenly taking twice as long to run, but the data volume hasn't increased. How do you investigate and resolve this?
2.A business stakeholder needs a new real-time reporting dashboard, but your current architecture only supports batch processing. How would you approach this request?

Resume Keywords

Make sure these keywords appear on your resume

AWSSnowflakePySparkPythonSQLETL PipelinesData ModelingCloud MigrationPerformance TuningData LakesAgileHybrid Work

Interested in this position? Apply directly on LinkedIn.

Apply on LinkedIn →