How could you re-write this SQL statement to make it more efficient? How would you scale this system to handle a large number of users and TBs of data?
Analytics Engineer Interview Questions
1,259 analytics engineer interview questions shared by candidates
Question about which tools do you use in existing role
Typical questions around stakeholder management and project management. Technical questions relating to best practices.
What makes a good data warehouse?
Write queries to answer each question. They shared table schemas and asked me to write queries to meet each scenario. The tables were related to marketing.
Tell me about a time you had to deal with push back from a stakeholder regarding a proposed solution.
Who is the data analytics Engineer?
Pretty standard stuff, the task alone was a bit ambiguous and strange.
Tell me about the hardest data pipeline you have worked on.
How you worked with backend engineers before? What do you do when they don’t collaborate e.g. don’t want to fix issues that affect data downstream?
Viewing 551 - 560 interview questions