Product Ops Analyst at Zenefits


Miles S

How long have you been working there?

1 year 4 months

What is your educational background?

I studied Finance & Accounting at the University of San Diego

How long did it take you to go through the course?

2 weeks and approximately 15 hours

How did SQL training help you in your day-to-day work? Any new projects that it's helped with?

Zenefits had an automation product that was still in its infancy, and Zenefits wanted to take advantage of the many processes it did automate and prevent inevitable errors as the product continued to develop. I used SQL to gain insight on the situation.

By running queries to isolate companies that were these edge cases the feature could not handle, I removed the risk that incomplete information was conveyed. If I didn't know SQL to do this, we would have had to either (1) disable this feature or (2) wait until an error occurs to identify a company that needed to be excluded in the automation.

I'm now writing SQL queries probably twice a week. Access to this data has enabled me to proactively make decisions in circumstances that I previously couldn't. I'm now always thinking about how I can use data to support whatever decision I'm making.

What did Leada do best?

The content was especially useful and practical to my day-to-day work.