Senior Analytics Engineer | Home assignment review | Part 2 | Surfalytics

In this video, Nikita discusses refactoring a complex data query, focusing on ensuring accurate outputs and data quality. He explains his approach using a three-layer data infrastructure: staging, intermediate, and marts. Then he covers a pull request (PR) review, where he identifies issues such as complex calculations on the staging layer, which should be one-to-one models. He also highlights incorrect model referencing, advocating for Jinja for lineage tracking.

Timecode:
00:00 - Intro
00:18 - Task description
01:16 - Query decomposition
05:35 - Refactoring the query
10:47 - Pull Request review
19:39 - Question. Data contracts vs dbt test

Thank you for watching our video "Senior Analytics Engineer | Home assignment review | Part 2 | Surfalytics" on Surfalytics_TV.
Click the link to watch more mock interviews: https://www.youtube.com/watch?v=qUwbpgbEymE&list=PLNCDg7zJiXhPD0ethFHC-1V1pkvWhc633&pp=iAQB

Subscribe for channel for more videos: https://www.youtube.com/@SurfalyticsTV?sub_confirmation=1

#dataengineering #dbt #sql #datarefactoring #datamodeling #dataquality #analyticsengineering #etl #dataarchitecture #facttables #dimensiontables #pullrequest #codereview #datacontracts #dbtcore #datavalidation #technicalinterview

=================
What is Surfalytics?
Inspired by West Coast surfing spots 🏖️ and Pacific Ocean vibes 🌊. Created to help you start a new career in the data analytics space, and develop data engineering and analytics skills through coaching. It will teach you not just dry skills, but will keep your focus on delivering significant value to businesses in the analytics realm as well as help to get fair compensation 💰 for the work you’re passionate about ❤️‍🔥.

The goal of Surfalytics is to assist you in achieving one of the following: 🏄‍♂️ Land your first job in the data industry with literally zero experience. I have accomplished this many times across the globe. 🏄 Advance from a middle-level role to a senior position (as an Analyst or Engineer). 🏄‍♀️ Transition from a non-technical Analyst role to a technical Engineer role. Moreover, we will focus on creating a highly competitive CV and securing top job offers.

We will not consider any lowball offers, focusing only on top-tier companies and well-paid opportunities. Finally, Surfalytics is a results-driven community with a very narrow focus, resulting in a high return on investment (ROI).

Here, ‘investment’ does not mean money but your time. I am literally fighting for your attention to encourage you to study and work hard, instead of watching Netflix or playing video games.

This is the best YouTube channel for Data Analytics and Engineering. You will patch up a lack of knowledge and get new experience or you build a Data Analyst roadmap or Data Engineer roadmap for yourself.

Want to be part of our growing community?
Site: https://surfalytics.com/
Blog: https://blog.surfalytics.com/

#surfalytics #nikitavolynets #sql #mockinterview #technicalskills #cte #windowfunctions #database

Видео Senior Analytics Engineer | Home assignment review | Part 2 | Surfalytics канала Surfalytics | Fast Track to Data Career