As a Business Intelligence developer I could be working in any of 4 environments, i.e. SSIS, SSAS, SSRS or Dashboards. In my case I am primarily on the latter three so a vast majority of my time is creation. Every once and a while I might be asked to help out on the SSIS side of things but that, as I said is rare. So, I spend probably 90% of my time creating and 10% "fixing". And, sometimes, as a report goes through different iterations - I am asked to make changes/improvements to that report - so the "creating" and "fixing" sometimes gets mingled together. Now, the other members of my team that work primarily in the SSIS area of our business. They are probably just the opposite. They are constantly/often "fixing" problems with data or the flow in one way or another - and doing little creation. I'd say they are doing about 80% "fixing" and 20% "creating".