zachrenwick Profile Banner
Zach Renwick Profile
Zach Renwick

@zachrenwick

Followers
767
Following
5K
Statuses
3K

Data/Analytics Engineer 📊 #SQL #data #analytics #BigQuery #GoogleAnalytics

Vancouver, BC
Joined January 2009
Don't wanna be here? Send us removal request.
@zachrenwick
Zach Renwick
1 year
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
Tweet media one
0
0
4
@zachrenwick
Zach Renwick
3 days
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!
Tweet media one
0
0
6
@zachrenwick
Zach Renwick
3 days
0
0
0
@zachrenwick
Zach Renwick
3 days
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
0
5
@zachrenwick
Zach Renwick
3 days
@matsonj skill issue?
1
0
3
@zachrenwick
Zach Renwick
4 days
Pro tip: mention “vanity metrics” once in a meeting and people will think you’re a freaking analytics mastermind 😮
1
0
5
@zachrenwick
Zach Renwick
4 days
It turns out taking your job a lot less seriously is good for your mental health. Who would have thought?
1
0
5
@zachrenwick
Zach Renwick
6 days
RT @tekbog: this is literally how i feel working in corporate
0
2K
0
@zachrenwick
Zach Renwick
16 days
@dataenggdude Say more! Genuinely curious
0
0
0
@zachrenwick
Zach Renwick
17 days
What made you think someone in data would be responsible for physical security? 🤔 I've heard of cold outreach but this is arctic level...
Tweet media one
2
0
1
@zachrenwick
Zach Renwick
18 days
@matsonj Oracle has a marketing/awareness problem. I don’t even know what their cloud data platform is named
1
0
1
@zachrenwick
Zach Renwick
18 days
Me when asked for too many “gee whiz” data insights Not enough scalable data infrastructure Engineers just want to build plz
@IAmMarkManson
Mark Manson
19 days
You are not stressed from doing too much. You are stressed from doing too little of what you care about.
0
0
2
@zachrenwick
Zach Renwick
20 days
@theRealslimcam That’s great real slim Jim but I’m looking for data roles
0
0
0
@zachrenwick
Zach Renwick
20 days
4) Numerous performance refactor improvements that enabled us to load digital events data from a >60 billion row GA4 dataset
0
0
0
@zachrenwick
Zach Renwick
22 days
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
0
3
@zachrenwick
Zach Renwick
23 days
@tate_bowman @haro_ca_ @CasazzaNY @tate_bowman when I used Power BI I would just import the data at the lowest customer/transaction level and I could use DAX distinct counts But as you work at Walmart I'm sure you're working with some massive customer datasets that probably can't be loaded at that granularity 😆
0
0
2