Nike Interview Questions

Nike Interview Guides

Click or hover over a slice to explore questions for that topic.
SQL
(14)
Machine Learning
(11)
Behavioral
(6)
A/B Testing
(5)
Product Sense & Metrics
(4)

Nike Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

As a data analyst in a fitness app company, you are tasked with analyzing the user’s daily step count.

Write a SQL query to calculate the 3-day rolling average of steps for each user, rounded to the nearest whole number.

Notes: The rolling average should only be calculated for days where there are 3 previous days of step counts, including the current day. The first 2 days for any user should be excluded.

Example:

Input:

daily_steps table

Column Type
id INTEGER
user_id INTEGER
steps INTEGER
date DATE

Output:

Column Type
user_id INTEGER
date DATE
avg_steps FLOAT
SQL
Easy
SQL
Medium
Loading pricing options

View all Nike questions

Challenge

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

Nike Salaries by Position

$110K
$232K
Data Scientist
Median: $161K
Mean (Average): $164K
Data points: 56
$125K
$194K
Product Manager
Median: $150K
Mean (Average): $154K
Data points: 27
$98K
$208K
Software Engineer
Median: $146K
Mean (Average): $150K
Data points: 223
$113K
$167K
ML Engineer
Median: $144K
Mean (Average): $141K
Data points: 4
$105K
$174K
Data Engineer
Median: $132K
Mean (Average): $136K
Data points: 43
$97K
$136K
Product Analyst
Median: $120K
Mean (Average): $117K
Data points: 10
$89K
$131K
Data Analyst
Median: $115K
Mean (Average): $112K
Data points: 15
Business Intelligence*
$105K
Business Intelligence
Median: $105K
Mean (Average): $105K
Data points: 1

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

From the graph we can see that on average the Data Scientist role pays the most with a $164,096 base salary while the Business Intelligence role on average pays the least with a $105,000 base salary.

Discussion & Interview Experiences

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