IHG Hotels and Resorts Programmatic Analytics Analyst interview questions

Actually had applied for something else. However was brought in for this role after a referral. Quick phone screen, then didn't hear anything back. It turns out someone else had contacted me and it went to a spam folder, as they had set up a job interview time without checking my availability. And then the day before sent over a large excel file containing company marketing data and asked me to put together a presentation on it. These were two massive red flags. It felt insulting being asked to prove I could do a job, one working with data I've had over 7 years of exposure to working with, that they wanted to bring me in to interview for. While throwing together a report is easy, I was told I wouldn't have access to wifi and would need to bring in my personal laptop. Needless to say, if they were so interested in hiring someone, they wouldn't make ridiculous demands like this. It's arrogantly rude and insulting in a labor market with sub 5% tech unemployment to act like that. Did look over the data and had some easily noticeable trends to it, but in talking with the hiring manager it turned out she hadn't looked at it herself and said as much during the interview. To me that is a red flag, asking someone to do something that you haven't done yourself. It had me questioning the position's stability as it was going on eight months since the job had been posted. For them to blame the recruiters at IHG was also unfair, as they seem to have unrealistic expectations and had me wondering if she was qualified for her own role. Was a panel interview with groups rotating in, was done around noon. It turns out they want a business intelligence developer with multiple years of experience in SAS to prepare reporting dashboards using data from DoubleClick imported into SAS since it's what the hiring manager knows. All while underpaying for the experience needed to do something like that. The interview process felt rushed and unprofessional, and felt like I was a token interview who had no chance of being hired on. I feel bad for the company and its shareholders since it basically has a license to print money. Even if I'd been offered the role I likely would have declined as it seems like unrealistic expectations have been entrenched for this role that has been open since around April of 2016.