Blog: Technical and Leadership Articles

From a Sr. Business Intelligence Leader at Amazon

Are You Impressing Your SQL Interviewer or Accidentally Doing the Opposite? interviews sql Apr 28, 2024

I’ve been a people manager for over 12 years of my 20+ year career across Amazon, Ebay, VMWare, and more, and I’ve conducted a lot of interviews throughout that time. Unfortunately, I’ve seen about 90% of candidates fail their SQL interview due to a lack of understanding of SQL...

Continue Reading...
Is Your SQL Quality Code or a Collection of Bad Practices? data analyst sql Mar 31, 2024

I’ve spent over 20 years of my career in tech and the last 12 years as a people leader, building world-class analytics teams and organizations. Throughout my career I’ve held in roles in analytics, software development, software QA, and more. and I’ve had the opportunity to work...

Continue Reading...
The Dangerous World of Self-Service Analytics analytics analytics engineering data sql Apr 10, 2023

 

Most analytics leaders put self-service analytics at the top of their list of items on their annual roadmap, but they never seem to talk the potentially disastrous implications of creating self-service tools. Enabling self-service analytics sounds straight forward where data engineering...

Continue Reading...
Avoiding Vanity Metrics analytics data sql stakeholders Nov 15, 2022

Early in my career in the analytics field I started to become inundated with task request from stakeholders.  I felt overwhelmed and confused at times by what my stakeholders were asking for.  There were already countless dashboards and metrics, yet I was receiving more request to...

Continue Reading...
 
SQL Best Practices analytics analytics engineering data data engineering sql Jun 18, 2022

In this post I’m going to share some best practices for formatting SQL that I’ve learned and used over the last 20 years. Many of these tips are things that I’ve collected along the way out of frustration with inheriting code, needing to perform updates, chasing down bugs, and...

Continue Reading...

Stay up to date with the latest tips and best practices

We hate SPAM. We will never sell your information, for any reason.