if you do any gaming at all 8700k is better, if you want a pure workstation, 1700 is way better.
A few issues here! :-D
This is my 1700 workstation, while crunching and doing db load, and massive excel sheets, and youtube music, uses the same amount of power as my 7820x at light browsing.
7820X uses a lot of power, true. But that's not the CPU that OP is considering.
Also, since you're a data analyst, your workload will be significantly different to his (software development).
Never breaks 60C at 3.6ghz 1.1v
Which is just a pointless number. My kettle never breaks 100C, if that helps anyone. I've never broken 42*C - does it make me a better CPU?
And we don't even know it OP has any interest in OC or temp monitoring or whatever. If he simply wants to buy a CPU and forget about it, Intel gets bonus points for "just works" approach. AMD gets bonus points for "I like to run benchmarks every week to know if the weather affects my PC's cooling performance".
money/performance you cant beat amd at workstation.
Actually the price difference between 8700 and 1700 is just $40, which is hardly a lot, considering e.g. Intel will work with pretty much any RAM and you have to cherry-pick for AMD.
And if OP is not in a hurry, we'll soon see H370 mobos as well (by that time 8700 price should drop).
Both CPUs are just as fast in full core load, but Intel will gain A LOT when fed with single-threaded processes.
And yes: people have reported issues with Android Studio on Ryzen, so it's worth looking into.