Pros
You'll have a chance to do huge things. If you have the right manager and team, you will learn a lot fast and have a great time.
Cons
First off, if you are an external hire, make sure you ask about the job level. This will determine your fate. If you have a masters or multiple years of experience, do not accept anything below a level 5. It will screw you if you come in as a 4. Also check what peak will be like. Between Thanksgiving and Christmas for some teams it is hell. 80 hours a week does happen and really screws you up. The setting of the Pros is rare. You will likely be under a non-technical manager who thinks they understand data, but doesn't. You will likely be a data monkey generating reports and data for people who do not know how to use it. They will take credit for your work. You won't be able to get promoted because you won't get growth opportunities. Amazon tends to hire overqualified people for the BIE role. Amazon claims to be a data driven company, people most people don't know how to use it. The company compensates with BIEs be program manager's personal calculator. It sounds like an exaggeration, but it is the fate most BIEs face. If you are set on taking a BIE position, make sure the manager is a BIE or data engineer. Also make it clear that you will not be happy writing SQL all day.