Dear Hiring Manager,
A daily KPI pipeline I automated at Halcyon Commerce with Python and scheduled SQL took roughly 6 hours of manual spreadsheet work off my team every week, and that habit of removing recurring drudgery is how I tend to earn trust on a data team. Before Halcyon I cut my teeth at Brightfield Media, where I built Power BI reports tracking campaign ROI for 5 stakeholder teams and wrote the SQL that segmented a 2-million-row customer table. The Data Analyst role at Lakeshore Analytics Group looks like work where both speed and clean definitions matter, and those are the two things I keep coming back to.
At Halcyon Commerce I built 8 Tableau dashboards on a dbt-modeled layer that replaced weekly manual reports and cut ad-hoc data requests to my team by about 60 percent. When a core revenue model was taking 12 minutes to run against our Snowflake warehouse, I rewrote it with CTEs and indexed staging tables and brought it under 90 seconds. I also designed and analyzed an A/B test on the checkout flow in Python, found a variant that lifted conversion 7 percent, and walked product and marketing leads through the result so the decision was theirs to own, not mine to defend.
What I bring beyond the queries is a bias toward agreed definitions: at Brightfield I documented metric definitions in a shared data dictionary and standardized 15 recurring data checks, which cut the back-and-forth over conflicting numbers more than any single dashboard did. My PL-300 and Google Data Analytics work sits on top of a statistics degree from the University of Illinois, so the rigor is the foundation rather than a substitute for it. I can talk Tuesday or Thursday afternoon, and references from both of my past managers are ready when you want them.