
This is software (AWS) generated transcription and it is not perfect.
in 2012. Well, it's closer back to more 2011. I was doing my undergrad in accounting, um, and a professor up at the University of Utah who happened to be a neighbor of mine. He and I got talking one day, and he's like, What are you gonna do after I was like, Well, I think I'm gonna go to my masters of accounting agencp and kind of go that route. Um, and he's like, you know, and he could tell I wasn't to set on it, you know? I mean, I was unknown. What you gonna do? I don't know. You know, that's kind of the path for an accounting undergrad. I was like, Well, why don't you check out the Masters and information systems? I was like, Well, I don't have any. You know, I enjoyed tinkering with computers, and I can, you know, know my way around technology fairly, uh, was pretty proficient at the time. He's like, Yeah, well, you don't need You don't need to have a background and CS or anything to do information systems. So that sparked my interest. And that kind of changed my path to go to the Thio, um, apply for the program up there at the University of Utah, which I started in, um, 2013 January 2013. And that was kind of my first drill experience, actually getting into, you know, database management systems, Really? The weeds of security and kind of, you know, you can kind of choose your path. I chose the business, intelligence and analytics route. Um, s I went through school that year. I wasn't working, Wasn't doing an internship. It was just full time school, you know, working in the field. You know, it was more just full time school. No, no, no jobs related to what I was doing in information systems, which we'll get to that shortly, Has some advice, but finish school in December 2013 and started at a health tech company called Health Catalyst in 2014. February, March of 2014 has a tier one support. Ah, and that was, uh that was great, because it kind of gave me some experience within the company, because at that point, I still don't know where I wanna go. I wanna go the development and I want to go operations continued on the B, I rolled database side of things and that evolved to, you know, it s so I did support for a year, Really learned our product, Learned our back end. Um, we're of Microsoft shop there. Microsoft Shops was all sequel server, single serve immigration services. Um, and that being said, I actually started talking to another kind of a colleague of mine that became a mentor in the sense. And he's like, you know, do you wanna We're looking for a database administrator. Do you want to go that route? I was like, Well, I'd love to learn, you know, the weeds of sequel server and, you know, even more so and, you know, really learn what it takes tow, um, manage a database system. And so I did that After a year of being in support, I became a database administrator and did that route for three years. And that evolved to kind of where I met. Today is a data engineer. Over the past 2.5, 3 years, um, left health Catalyst a couple years ago went to Trager pellet grills. That was a data engineer there again working on sequel server and like your soft They're sorry. Single serve integration services. Um, and then spend a little time there and then really wanted to become more of a proficient data engineer. Really? Learning python are Scarlett whatever it takes, you know, Microsoft, you know, people server and just knowing Sequels only getting me so far. So I made a move ah, year ago to a company called Collective Medical. Another health tech company was going to get back into going from the product side of things that trigger back to the health side of things. Um, and now at traeger and, you know, a little bit at sorry at trigger a little bit. I was able to start that kind of that pivot. Um and it's just only accelerated mawr since moving to collective eso. Now it's yes, there's sequel everyday. Still not so much of the database side, but Anderson. I've been able to take all that knowledge I built from, you know, anyone can write sequel queries, right? Just like anyone can write code. What makes a good report writer or a sequel developer or anything else is a fishing code writing code that runs well writing code that doesn't bring down the system. Think it is based administrator that you know getting up at 3 a.m. When our service go down. You know, it's usually because not usually it happens more than off. More often than not, someone's let her grow query. Keep running, and it's brought down the systems. It's filled up our log files. I've been able to take that and pivoted into what I do now every day and you know, how is this query really gonna run on the system? Um, and it's, you know, what shaped my career path to kind of get me here has been I definitely say a good mentor. Um, he was with me at Catalyst. He actually came with me. He actually joined me when I left to go to trader and he was my director there, and he's always been something that I could go to for questions. Even yesterday, I reached out to him on G chat. I had a question about, uh, some data quality questions and, you know, we chat all the time, and I'd say that's definitely been one of the biggest benefits to me, for me is having a good mentor, so
eso every day. Now it's Python day and day out. Um, I work in, uh, engagement success? Uh, division. So working a lot in salesforce, writing out python, building out python projects to import and export a lot from Salesforce. Calling the Salesforce a p I, um where were were on the engagement and success side of things. A lot of metrics, a lot of reports. A lot of, um, a, uh, sequel queries. Um, where I'm a data engineer. I'm actually not on product or engineering, so it's It's kind of a unique role being in operations. Ah, lot of process improvement and O s a lot of process improvement, and it's building out those processes. Thio accomplish that? Um, I work a lot with our data science team. Also, I'm again. They're all metrics, all tableau, all KP ice. Okay, ours, um so so weekly work, work hours, you know, it's It's the standard, you know, 8 to 5. I find myself coming, you know, 8 to 5. And then if I'm working on something, I come back to it after dinner. Um, because it's interesting. Not so much, because I have thio. I mean, it's, you know, we have our sprints, but it's I'm working on this and it's rattling through your head throughout the night and you're like, You know, you take a break and you come back down to your office and you. And then the next morning, I find that when I for me when I in the day on a high note, it makes it that much more enjoyable to continue Thio work the next day. I actually live, you know, regarding, ah, commute hours or commuting time. I actually live about a mile from the office. It's I've always had a short commute, even a health catalysts and trigger, um, health Catalyst was only a few miles away. Also, obviously now, with, uh, Pandemic, I'm working from home full time and probably will continue to work from home even after the office reopens. Just because it's, you know, I've worked from home throughout my career, not something I would ever think I would do full time, but I really learned to enjoy it.
So, uh, currently at Collective Medical. Um, my sequel, where everything's running off of my sequel and Lennox servers. So even ableto. Obviously, a lot of what I've learned in Sequel Server has transferred over to my sequel. Most database management systems were similar. That's my sequel. Oracle Sequel Server. They all have their quirks, Um, relatively the same. And then python working in pie charm is the Is the i. D. I chosen. Um, but yeah, it's sequel in Python Day in, day out dabbled a little bit in tableau and tableau Domo and click you depending on which company I was out. No expert by any means, but definitely been exposed to those, um, b I tools also.