Data/Analytics Engineer š #SQL #data #analytics #BigQuery #GoogleAnalytics
Joined January 2009
- Tweets 2,855
- Following 494
- Followers 767
- Likes 4,502
460 Photos and videos
Pinned Tweet
24 Jan 2024
One of the first things I like to do with new hires is show them our global asset lineage in Dagster (the master DAG). It looks something like this
5
1,941
28 Oct 2025
Ok proud work moment, we are #1 on the App Store right now!
I modelled all the tracking/telemetry data, integrating it with existing web analytics pipelines so we have one stop shop datasets for all our web/app sessions and conversion funnels
74
12 Jun 2025
Holy shit, this was > 5 years ago?
20 Apr 2020
Them: Can you just quickly pull this data for me?
Me: Sure, let me just:
SELECT * FROM some_ideal_clean_and_pristine.table_that_you_think_exists
3
947
12 Jun 2025
DuckLake is cool. Next question, how do we scale the local querying?
Let my iPhone 15, laptop and desktop scale out a query on 1TB of data
1
1
290
30 Apr 2025
Everyone else: LLMs are amazing, they are going to automate you out of a job
Me to LLM: Return BigQuery SQL that does a thing
LLM: Here is Redshift SQL
Me: ???
3
190
25 Apr 2025
Snowflake releasing semantic views, meaning you can semantic/metric layer directly in your cloud DW: docs.snowflake.com/en/user-gā¦
I'm here for it, but I don't see docs yet on how you would consume from the semantic view. Maybe like
select conversion_rate() from semantic_view?
1
4
259
11 Apr 2025
just wait til you get to your 30s
learning how similar you are to your dad in your mid to late 20's is the most terrifying thing they never tell you
5
265
Zach R retweeted
23 Mar 2025
everybody wanna train a ML model
but nobody wanna clean no big ass data
58
210
3,663
128,847
13 Feb 2025
Tech debt is good actually *
Good if your middleware SQL logic enables business to know WTF was going on thru 3 site migrations and web analytics platforms
165
10 Feb 2025
Anyone here used Looker (as a semantic/metrics layer) and Tableau together? How is the native Looker to Tableau connector?
1
187
7 Feb 2025
BigQuery just released UNION ALL BY NAME
It solves the issue of perfectly aligning each field properly in SQL. As long as the fields have the same name you're good!
7
266
7 Feb 2025
Another analytics engineering (AE) LinkedIn bash post.
Hard to not react (my current job) but having an AE title does not assume you will build a spaghetti data architecture.
There are tons of data engineers who create perfectly optimized data models that are used by no one.
6
17
1,197
7 Feb 2025
There's so much value to add anywhere along the data chain.
Honestly, blending business context (analyst focus) with data modeling is an extremely impactful role.
Yes there's some shit AE models out there, but I've seen some terrible SQL written by data engineers too
1
5
242
6 Feb 2025
Pro tip: mention āvanity metricsā once in a meeting and people will think youāre a freaking analytics mastermind š®
1
5
256
5 Feb 2025
It turns out taking your job a lot less seriously is good for your mental health. Who would have thought?
1
5
238
Zach R retweeted
3 Feb 2025
this is literally how i feel working in corporate
34
1,510
17,663
501,201
22 Jan 2025
I thought BigQuery was pretty cool but then I learned about Databricks Delta Live Tables and Snowflake Dynamic Tablesā¦
Why we out here writing manual incremental strategies in dataform and dbt, just let the engine figure it out (didnāt realize streaming could be that easy)
7
1
55
4,007
22 Jan 2025
Me when asked for too many āgee whizā data insights
Not enough scalable data infrastructure
Engineers just want to build plz
21 Jan 2025
You are not stressed from doing too much.
You are stressed from doing too little of what you care about.
2
284
18 Jan 2025
First thing you do at airport is locate your boarding gate. Doesnāt matter if your flight is 2 hours delayed.
I donāt make the rules
1
3
239