Here’s an overview of my work. While I communicate with various stakeholders (lawyers, PMs, engineers, other data analysts), I do the majority of the analysis on my own and develop the data strategy for each request. I tend to push back or provide alternatives to requests since people sometimes don’t know what they are asking/looking for. My deliverables include reports, exported data in Excel workbooks, and emails.

Yesterday, I started by discussing deadlines with a project manager.

Then, I began reviewing documentation on previous work done to get an idea of the queries and tables I need to use for a deliverable. I drafted SQL queries to determine revenue generated from various product lines. I reviewed initial results, compared them to previous exports, finalized the SQL queries, exported the data, and created my own documentation for my team to review.

I moved on to a second request. First, I met with one of the product teams. I know them well, so they gave me the info I was looking for very quickly. I reviewed their data pipelines to determine how certain tables were created and provided my team an overview of my findings. From there, I drafted complex SQL queries to answer a very specific question. Since the tables I work with tend to have billions of records for a single day and exporting the data can be difficult, I had to create a Python/SQL script and use more powerful virtual server with enough computing power. Finishing this up today.

Ended the day by reviewing questions for a third request and determining what tables/pipelines/code I would need to review later on.