Ally Financial Sr Data Analyst interview questions

Tell me about a time when you were given very little background or instructions but were asked to develop insights out of a very large data set. What did you do, what resources did you use and what was the end result? Tell me about the most difficult project team you were a part of. What was your role, what were the challenges and what did you personally do to make sure the project was successful? Please provide a detailed example of how you used Microsoft Excel, SQL and/or PowerBI to complete a report or analysis. What observations did you make and how did you validate the data to ensure all requirements were met for the request? How do you develop your skills and abilities? Give specific examples.