Senior Data Analyst Interview Questions (With Answers)

7 Questions asked

Sep 2026 First seen

Sep 2026 Last seen

7 Unique questions

🥧 Difficulty mix

How hard are these questions?

Easy 1 (14%)Medium 6 (86%)

📊 Question type

Breakdown by interview phase

🔥 12-week activity

When candidates are asked these

Last 12 weeks →

🏷️ Top topics

Where these questions cluster

Sql 5

Window Functions 4

Rolling Average 4

Revenue 1

Timestamp 1

Aggregation 1

Data Modeling 1

Logic 1

👤 Experience level mix

What seniority these are asked at

Junior (1-3yr) 5Mid (3-6yr) 2

📝 Recent questions

Latest 10 asked by candidates

🟡 Medium ✅

Write an SQL query to compute a 7‑day rolling average of daily revenue using a window function.

Sql Window Functions Rolling Average Revenue

Coding · Asked 1× · Sep 2026

🟡 Medium ✅

How would you modify your query to compute a 30‑day rolling average of daily revenue when you only have a transaction timestamp column and no order date?

Sql Window Functions Rolling Average Timestamp

Coding · Asked 1× · Sep 2026

🟡 Medium ✅

How would you compute a 7‑day rolling average of daily revenue when there can be multiple transactions per day, using transaction timestamps?

Sql Window Functions Aggregation Rolling Average

Coding · Asked 1× · Sep 2026

🟡 Medium ✅

How would you add a column that calculates the rolling average of revenue per transaction timestamp, given that you only have a transaction timestamp column and no order date?

Sql Window Functions Rolling Average

Coding · Asked 1× · Sep 2026

🟢 Easy ✅

Will this logic still work if the underlying data schema changes?

Data Modeling Logic Schema Changes

Conceptual · Asked 1× · Sep 2026

🟡 Medium ✅

When implementing slowly changing dimensions, how do you decide whether to count changes that occur within seven days versus those that occur after seven days? Also, can you walk through the SQL syntax you would use for handling SCD type 2?

Slowly Changing Dimensions Sql Data Warehousing

Conceptual · Asked 1× · Sep 2026

🟡 Medium ✅

At the table level, can you explain the difference between fact and dimension tables, how you define relationships between them, and what a primary key is? Also, how do you handle surrogate keys?

Dimensional Modeling Fact Tables Dimension Tables Primary Key Surrogate Key

Conceptual · Asked 1× · Sep 2026

🎤 Want these answered in real-time during your interview?

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

🥧 Difficulty mix

📊 Question type

🔥 12-week activity

🏷️ Top topics

👤 Experience level mix

📝 Recent questions

Write an SQL query to compute a 7‑day rolling average of daily revenue using a window function.

How would you modify your query to compute a 30‑day rolling average of daily revenue when you only have a transaction timestamp column and no order date?

How would you compute a 7‑day rolling average of daily revenue when there can be multiple transactions per day, using transaction timestamps?

How would you add a column that calculates the rolling average of revenue per transaction timestamp, given that you only have a transaction timestamp column and no order date?

Will this logic still work if the underlying data schema changes?

When implementing slowly changing dimensions, how do you decide whether to count changes that occur within seven days versus those that occur after seven days? Also, can you walk through the SQL syntax you would use for handling SCD type 2?

At the table level, can you explain the difference between fact and dimension tables, how you define relationships between them, and what a primary key is? Also, how do you handle surrogate keys?

🎤 Want these answered in real-time during your interview?

When implementing slowly changing dimensions, how do you decide whether to count changes that occur within seven days versus those that occur after seven days? Also, can you walk through the SQL syntax you would use for handling SCD type 2?