Safeway Interview Questions

Safeway Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(9)
Forecasting & Time Series
(3)
SQL
(3)
Business Case
(2)
Data Pipelines
(2)

Safeway Interview Questions

Practice for the Safeway interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).

Example:

Input:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

products table

Column Type
id INTEGER
name VARCHAR
price FLOAT

users table

Column Type
id INTEGER
name VARCHAR
sex VARCHAR

Output:

Column Type
month INTEGER
num_customers INTEGER
num_orders INTEGER
order_amt INTEGER
Data Structures & Algorithms
Easy
Machine Learning
Easy
Loading pricing options

View all Safeway questions

Challenge

Check your skills...
How prepared are you for working at Safeway?

Safeway Salaries by Position

Product Manager*
$165K
Product Manager
Median: $165K
Mean (Average): $165K
Data points: 1
$145K
$170K
Data Engineer
Median: $158K
Mean (Average): $158K
Data points: 4
$130K
$178K
Data Scientist
Median: $155K
Mean (Average): $152K
Data points: 8
$130K
$172K
Software Engineer
Median: $150K
Mean (Average): $150K
Data points: 21
$101K
$140K
Business Analyst
Median: $102K
Mean (Average): $117K
Data points: 5

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Product Manager role pays the most with a $165,000 base salary while the Business Analyst role on average pays the least with a $117,022 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion