I so rarely write about my job that I actually did a double-take when I saw that my last entry in this category was while I was pregnant with Connor. I even went back to the old Movable Type installation (still in place for occasions such as this) to make sure something didn’t get missed in the port over to WordPress.
Nope. It really has been that long since I’ve weighed in about work.
Which is funny, since so many of my early entries (2002-2004) were centered around how unhappy I was in my bank gig. In those early days of blogging (early days for me, anyway), I didn’t think about searchability or future repercussions about complaining about one’s job online and naming names.
But I digress. I hadn’t intended to make this a meta-blog post about blogging about work.
I’ve been at my current Data Warehousing job for five years, six months. When I started, I knew zilch about Data Warehousing. My hiring manager told me that my job in the beginning was “to be a sponge.” I was hired to add that graphic design element to the team, to be the person who can make all the hard work on the back end look aesthetically pleasing and well-organized on the front end.
Over time, I was taught all about data warehouses. Operational data stores. Extraction, transformation, and loading. Replicated databases. Incremental loads. I learned about the dashboarding/reporting software we had at the time, and learned how to set up projects and filters and metrics and attributes and reports and dashboards.
After the manager who hired me left the company, somehow my path went astray. I was still to be a sponge, but I didn’t get the opportunity to build many dashboards. I did learn more about ETL and SQL and I got more comfortable with data and report building, but it wasn’t until a couple years later that I got to do any dashboarding outside the initial one I built when I was first hired in. Since then, I’ve ramped up and found my niche.
Now, I’m informally considered the Lead UI Designer on our team (although if I had a new job title, I’d prefer to be a Front-End Developer — avoiding buzz words that might have a different meaning than intended). I’ve worked on my hiring manager’s initial vision of unifying all the DW reports under a single style and “brand,” and I’ve built a total of two dashboard suites (corporate and individual facility views with drill-through reports for each) in MicroStrategy and three in Microsoft Reporting Services, currently in the mockup and specification phase of a fourth, with a fifth on the horizon in Q3.
Not bad for a Visual Communication major who taught herself SQL at her bank job.
Continue reading

