Gilad Lifshitz
Plainview, New York, United States
2K followers
500+ connections
2K followers
500+ connections
About
As a Senior Analytics Consultant at Keyrus, I bring over 13 years of expertise in…
Activity
-
GOODBYE CTEs. GOODBYE Subqueries. GOODBYE Nested Filters. Hello 𝗤𝗨𝗔𝗟𝗜𝗙𝗬. It allows you to filter the results of window functions. No more…
GOODBYE CTEs. GOODBYE Subqueries. GOODBYE Nested Filters. Hello 𝗤𝗨𝗔𝗟𝗜𝗙𝗬. It allows you to filter the results of window functions. No more…
Liked by Gilad Lifshitz
-
What took me a week to build out a year ago just took me about 15 seconds. Since late 2022, I've been assigning personas to LLMs to have them poke…
What took me a week to build out a year ago just took me about 15 seconds. Since late 2022, I've been assigning personas to LLMs to have them poke…
Liked by Gilad Lifshitz
-
17 lessons I learned about Query Optimization over the last 8 years and 9 months at Amazon...(It took me a lot of slow queries to realize these, but…
17 lessons I learned about Query Optimization over the last 8 years and 9 months at Amazon...(It took me a lot of slow queries to realize these, but…
Liked by Gilad Lifshitz
Experience & Education
Licenses & Certifications
Courses
-
John Bryce-Business Intelligence developers in MS SQL server 2008 R2 environment
-
Languages
-
English
Full professional proficiency
-
Hebrew
Full professional proficiency
-
Spanish
Professional working proficiency
More activity by Gilad
-
12 months ago I attended Southern Manufacturing & Electronics as a total outsider - yet to close on my acquisition of Wiring Solutions Limited and…
12 months ago I attended Southern Manufacturing & Electronics as a total outsider - yet to close on my acquisition of Wiring Solutions Limited and…
Liked by Gilad Lifshitz
-
Some of the hardest conversations with my managers were about deals that went dark, then reappeared months later. Roughly 3% of the market is…
Some of the hardest conversations with my managers were about deals that went dark, then reappeared months later. Roughly 3% of the market is…
Liked by Gilad Lifshitz
-
כולם מדברים על AI אבל מה שבאמת מעניין זה המקום שבו הטכנולוגיה פוגשת אותנו כאנשים. אני מאמינה שתמיד יהיה צורך בבהירות, סדר והכי חשוב חיבור…
כולם מדברים על AI אבל מה שבאמת מעניין זה המקום שבו הטכנולוגיה פוגשת אותנו כאנשים. אני מאמינה שתמיד יהיה צורך בבהירות, סדר והכי חשוב חיבור…
Liked by Gilad Lifshitz
-
I’ve never used Airflow. I’ve never used Databricks. I’ve never used Apache Kafka. And yet, I’ve built a solid career as a Data Engineer. I…
I’ve never used Airflow. I’ve never used Databricks. I’ve never used Apache Kafka. And yet, I’ve built a solid career as a Data Engineer. I…
Liked by Gilad Lifshitz
-
The most underrated SQL function that will make your life so much easier: UNPIVOT Yes. You can unpivot data directly in SQL. (𝘛𝘢𝘬𝘦 𝘵𝘩𝘢𝘵…
The most underrated SQL function that will make your life so much easier: UNPIVOT Yes. You can unpivot data directly in SQL. (𝘛𝘢𝘬𝘦 𝘵𝘩𝘢𝘵…
Liked by Gilad Lifshitz
-
If you want to get up to speed fast on data engineering and analytics basics (in 1 month or less), read these seven articles: 1) What It Actually…
If you want to get up to speed fast on data engineering and analytics basics (in 1 month or less), read these seven articles: 1) What It Actually…
Liked by Gilad Lifshitz
-
Apps I do not have on my iPhone: - LinkedIn (I swear) - Instagram (although I use the web version here and there) - X - TikTok - Snapchat Apps I…
Apps I do not have on my iPhone: - LinkedIn (I swear) - Instagram (although I use the web version here and there) - X - TikTok - Snapchat Apps I…
Liked by Gilad Lifshitz
-
Data Analyst → SQL + Excel + PBI Data Scientist → SQL + Python + Statistics Data Architect → SQL + Data Modeling + Cloud Data Engineer → SQL + Python…
Data Analyst → SQL + Excel + PBI Data Scientist → SQL + Python + Statistics Data Architect → SQL + Data Modeling + Cloud Data Engineer → SQL + Python…
Liked by Gilad Lifshitz
-
I entered the data world when everyone was talking about self-service analytics. Ten years later, the conversation hasn’t changed. It started with…
I entered the data world when everyone was talking about self-service analytics. Ten years later, the conversation hasn’t changed. It started with…
Liked by Gilad Lifshitz
-
We’re looking for an amazing Technical Account Manager to join Jedify! If you love data analysis, data modeling, AI, and building real partnerships,…
We’re looking for an amazing Technical Account Manager to join Jedify! If you love data analysis, data modeling, AI, and building real partnerships,…
Liked by Gilad Lifshitz
-
I’m pleased to share that I’ve joined Citadel’s Legal & Compliance team! Grateful for the support and mentorship that made this possible, and…
I’m pleased to share that I’ve joined Citadel’s Legal & Compliance team! Grateful for the support and mentorship that made this possible, and…
Liked by Gilad Lifshitz
-
It’s not easy to sum up four years in a single post, but I want to try. After 4 years at Kaltura, I’m closing a chapter that has been one of the…
It’s not easy to sum up four years in a single post, but I want to try. After 4 years at Kaltura, I’m closing a chapter that has been one of the…
Liked by Gilad Lifshitz
-
A few weeks ago, I wrapped up a significant chapter: over eight years at Microsoft. Since then, I’ve been reflecting on what made this journey so…
A few weeks ago, I wrapped up a significant chapter: over eight years at Microsoft. Since then, I’ve been reflecting on what made this journey so…
Liked by Gilad Lifshitz
Other similar profiles
Explore top content on LinkedIn
Find curated posts and insights for relevant topics all in one place.
View top content