EP 51: Robert Stover from Enverus

Robert shares insights into how data analysis is revolutionizing the industry, emphasizing the critical role of efficient data queries and the tools that manage large volumes of information. He discusses the transition from relying on spreadsheets to adopting more organized and structured data systems. Tools like Snowflake and DBT are driving this shift, enhancing data processes and improving data quality within the oil and gas sector.Join the conversation shaping the future of energy.Collide is the community where oil & gas professionals connect, share insights, and solve real-world problems together. No noise. No fluff. Just the discussions that move our industry forward.Apply today at collide.ioClick here to view the episode transcript. 00:00 - Intro01:34 - Distributed Compute Necessity07:05 - Enverus Role Overview10:51 - Transitioning from Spreadsheets17:12 - Data Quality Testing Techniques19:00 - Understanding DBT (Data Build Tool)21:15 - DBT Orchestration Explained24:35 - DBT Documentation Importance28:03 - Tech Stack Insights30:17 - Type 2 Slowly Changing Dimensions33:01 - FiveTran vs. Homegrown Pipelines36:00 - Rudderstack Overview38:20 - Snowflake's Semantic Layer40:40 - Hex Analytics Tool45:00 - Experience at Parsley47:43 - Journey from Planning to Engineering49:28 - Importance of Domain Experience54:55 - Changing Your Data Stack1:01:14 - ODBC Usage Today1:06:00 - Microsoft Power BI Overview1:07:40 - Lakehouses Explained1:11:50 - Speed Round1:14:20 - Exciting Open Source Packages1:19:41 - Favorite Roadside Stops1:21:52 - Podcast Wrap-Up1:22:34 - Where to Find Matthttps://twitter.com/collide_iohttps://www.tiktok.com/@collide.iohttps://www.facebook.com/collide.iohttps://www.instagram.com/collide.iohttps://www.youtube.com/@collide_iohttps://bsky.app/profile/digitalwildcatters.bsky.socialhttps://www.linkedin.com/company/collide-digital-wildcatters