Working with data can present a variety of challenges. Can you think of a time where you ran into an unexpected challenge bringing together data from different sources? How did you end up overcoming this challenge?

"While working in my previous positions, my teams and I have always strived to anticipate data issues that may occur during the ETL process. However, inevitably, an unforeseen issue or circumstance will arise. In particular, I worked for a company that included a franchise system that required data to be collected from a variety of locations and systems. One of the franchisees changed his system without notice which created loading issues for his store's data. I worked to develop a short-term solution to get the crucial data into our system for corporate-wide reporting and also began developing a long-term solution to avoid similar situations in the future. "